Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Windows Login for ODBC Connection

Author  Topic 

manutsav
Starting Member

1 Post

Posted - 2008-09-09 : 17:06:05
How do we create an ODBC data source for windows NT based username?
Right now it is using the my domain login id (as I am logged on that box) and I need to change it to something else.
Also when front end applications creates a connection string using windows login how can we specify the same login and password?
Should it match the login id used to start the front end application?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-09 : 17:14:01
When using Windows authentication, it will use the current security context. So login with the appropriate account to use it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -