Securely logging onto an SQL server

  • Thread starter Thread starter Boris Zakharin
  • Start date Start date
B

Boris Zakharin

How do I log onto an SQL server without saving my password in the connection
string?
 
Hi,

If you SQLServer and WebServer in same network you can have Trusted Connection. Please try the followings.
"Data Source=Pubs;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Pubs;Database=pubs;Trusted_Connection=True;"


--
Let me know if you need further help

Regards
Sreejumon[MVP]
www.mstechzone.com
 
The server is not on the same network (well, it is once it's moved to the
production machine, but even then both are on remote hosting machines and I
can only access the SQL server via IP address)

Sreejumon said:
Hi,

If you SQLServer and WebServer in same network you can have Trusted
Click to expand...
Connection. Please try the followings.
 
Back
Top