Securely logging onto an SQL server

[Boris Zakharin]

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

 

[Sreejumon[MVP]]

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

 

[Boris Zakharin]

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)

Hi,

If you SQLServer and WebServer in same network you can have Trusted

Connection. Please try the followings.