Home | Troubleshooting |  Quick Setup  |  Cisco How to  |  Data Recovery  |  Forums   | Blog | IT Exam Practice | Services  | About Us | Chicagotech MVP  | Search  | Contact Us  |                 

 

 

How to add login user to SQL in trusted domain environment

 

1. To add a user from a different and trusted domain to SQL database, make sure you have created domain trust between two domains and have correct DNS settings. Please refer to these articles: How to create Domain Trust in Windows 2008 and DNS and NetBIOS Name Resolution Issues for Creating External, Realm and Forest Trusts

 

2. Run Microsoft SQL Server Management Studio.

 

3. Navigate to Server Name>Security>Login.

 

4. Right click on Login and select New Login.

 

5. In the Login name, enter the domaniname\username as shown below (Note: the chicagotech is trusted domain name).

 

6. Select the database and click OK to add it.

Post your questions, comments, feedbacks and suggestions

Contact a consultant

Related Topics


 

 


 

 

Hit Counter   This web is provided "AS IS" with no warranties.
Copyright © 2002-2018 ChicagoTech.net, All rights reserved. Unauthorized reproduction forbidden.