NT Authentication 2

[Beesknees]

Hi, I need to set up a user in sql server that is nt authenticated. I need users to be abvle to log into sql server just using their nt logins. how do I set up a sql server user/login?!? to work this.
Hope I've explained my question properly! TIA

 

[RickCole]

From Enterprise manager right click on the required server and then go to properties. Then on the security tab select the Authentication method you require. In you case this would be 'Windows NT only'.

Rick.

 

[Beesknees]

it is on that mode already. how come I can't authenticate users?

 

[RickCole]

Next step is to connect to the required server and then expand the Security folder. From here right click on Logins and choose New Login. Enter the required NT groups and give database access as required.

Rick.

 

[tlbroadbent]

I assume you are using SQL 7 or 2000.

You must grant the NT users or groups access to SQL Server. This can be done with Enterprise Manager in the Security | Logins folder. You can also use sp_grantlogin from Query Analyzer.

EXEC sp_grantlogin 'DomainName\UserName'

You'll also need to grant permissions to databases and objects or assign users to database roles. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Beesknees]

ok, thanks a lot. Tell me, when I set up a new login then, do I have to specify an already defined NT group? Does this group have to be on the server or can it exist on the domain only? ie. do I need to create an NT group on the NT server?

 

[tlbroadbent]

You can use domain groups. The group or user must already exist in the domain. Read SQL BOL for details of granting access and other aspects of SQL Server security. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[RickCole]

Yes the NT group does need to be already defined but can just exist on the domain.

Rick.

 

[Beesknees]

Thanks a lot, that has given me all I need to go on. cheers.