Trusted Connections
-
How would I get users (or Group) in my domain to access SQL2000 database using trusted connections?
Thanks for your help
Raghu
Raghu -
Add the username or group along with the Domain. For instance:
MyDomain\AUser
MyDomain\AGroup
In Enterprise Manager,it'll look like:
If you want to use SQL, such as through Query Analyzer, use sp_grantlogin, which is for adding NT user accounts. For instance:
EXEC sp_grantlogin 'MyDomain\AUser'id=code>
id=code>
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply