Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NT Workstation SQL Server Security

Status
Not open for further replies.

BJH

MIS
Aug 3, 2000
1
US
My SQL Server logins are set to SQL Authentication (SQL Server is set up on NT Server).<br><br>However, if I'm logging on through an application and I'm on an NT Workstation where my NT login password is NOT the same as my SQL Server login, I cannot connect to SQL Server.<br><br>If I change my password on the NT workstation to match my SQL login, then I can connect.<br><br>Somewhere behind the scenes there is still an NT security check that is not letting me connect.&nbsp;&nbsp;<br><br>Anyone run into something similar?&nbsp;&nbsp;How do I resolve this?
 
Might be something to do with being a user of that database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top