connect to SQL Server via NT authentication

[Guest]

I need a VB app that can connection to a SQL Server DB but use the NT
authentication of whoever logged into the machine the app is running from.

How can I do this?

thanks,

mike w.

 

[Guest]

Jan. 17, 2005

You would have to grant the users of the application permissions to log
on to the server and then the permissions regarding databases. You would then
want to use Integrated Security=SSPI in your connection string, instead of
the username and password attributes. Adding this setting to your conn string
will use Windows Authentication to logon to the database. This is why you
will have to grant the users, that you want to be able to access the
information, permissions to logon and to read/write/etc. I hope this helps
and have a great day!


Joseph MCAD