Automatically Connecting to SQL Server

  • Thread starter Thread starter mac
  • Start date Start date
M

mac

Can anyone tell me how to automatically connect to SQL server? I am
always prompted for a Login ID and Password on the SQL Server Login
Windows. Use Trusted Connection is always checked by default and I
always have to uncheck it and type the appropriate Login ID/Password.

Thanks,

Jason
 
Check the ODBC DSN and make sure the Option "With Windows NT authentication
using the network login ID" is checked.
 

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

ODBC Failure, error 18456 0
Eeek! I am forbidden access? 12
Insert Record into Oracle Table 1
SQL Server Login requesting password when query is run. 4
connection to sql server 2005 problem 5
SQL Server connection string for deployment ? 1
How to make PC respond to dialouge box with text and clicking button itself? 0
SQL Connection 1

Back
Top