Aug 29, 2002 #1 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
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
Aug 29, 2002 #2 usesql Programmer Dec 13, 2001 5 0 0 US 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
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 */
Aug 29, 2002 Thread starter #3 dba123123 Technical User Sep 5, 2001 16 0 0 CA Thanks. It works. Laura Upvote 0 Downvote