Log in to MS SQL 7.0 using NT login info

[gcole]

Can you log into MS SQL 7.0 using the local NT login info from the individual users machine?

 

[BeckahC]

That depends on how you have the security set-up. If you are logged into that machine with a user name and password that has access to the database, then you will be able to log in with that user's login. You won't be able to login to SQL Server 7.0 using NT security from someone else's computer without logging into that computer as someone with access to that SQL Server database.

I hope that made sense and helps! BeckahC

 

[gcole]

My users will be logged into that machine with a user name and password that has access to the database. How do I pass the NT login to the Server?

 

[WaltK]

You can define how information is passed to SQL when you define the connection. For example, if you are using Access for a front end, click File, Connection then option 2 defines how your users connect to the database. SQL will automatically retrieve the NT login info, so you won't have to worry about it.

The users do need to be defined in the SQL database of course. The easiest way I've found is define an NT group with the proper permissions, and you won't have to put each individual user in. Remember to define the group or users as <Domain>/<NTUserName>.