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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make PC respond to dialouge box with text and clicking button itself? 0
Windows Authentication 4
What are the steps to fix damaged MDF files in SQL Server? 0
Problem ASP.NET to SQL Server 6
Open Connection error 1
Retrieve return value of SQL User Defined Function? 2
The user is not associated with a trusted SQL Server 2
Login failed for user ''. The user is not associated with a trusted SQL Server connection. 4

Back
Top