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!

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

NT User login

Status
Not open for further replies.
dba123123

dba123123

Technical User
Sep 5, 2001
16
0
0
CA
Does any body knows the SQL statement we can use to create NT user login in SQL Server 7?

It seems to me that sp_addlogin can be used to create SQL Server login, but not for the NT User login.

Thanks.

Laura
 
Sort by date Sort by votes
Saw this on some site.maybe will help

EXEC sp_grantlogin @loginame = 'MTG\Guest'
/*
No password is requred since it is obtained via
NT Security
MTG = Domain; Guest = User Account
*/
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
77
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
70
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1
Replies
2
Views
40
Auguy
Auguy
baran121
  • Locked
  • Question
sql user default language problem
Replies
7
Views
77
gmmastros
gmmastros
ghbeers
  • Locked
  • Question
Using single user entered attribute in where to match one of 4 different columns 1
Replies
9
Views
50
mharroff
mharroff

Part and Inventory Search

Sponsor

Back
Top