Wondering how to allow domain user access to SQL Server instance on EC2? We can help you.

Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.

Today, let us see how our Support Techs allow domain users access to SQL.

How to allow domain user access to SQL Server instance on EC2?

By default, only the built-in local administrator account can access a SQL Server instance launched from an Amazon Web Services (AWS) Windows AMI.

You can use SQL Server Management Studio (SSMS) to add domain users so that they can access and manage SQL Server.

Today, let us go through the steps followed by our Support Techs to give a domain user access to the SQL Server instance.

1. Firstly, connect to your instance using Remote Desktop Protocol (RDP) as a local administrator.
2. Open SSMS. For Authentication, choose Windows Authentication to log in with the built-in local administrator.
3. Then, choose Connect.
4. In Object Explorer, expand Security.
5. Then, open the context (right-click) menu for Logins, and then select New Login.
6. For Login name, select Windows authentication. Enter DomainName\username, replacing DomainName with your domain NetBios name, and username with your Active Directory user name.
7. On the Server Roles page, select the server roles that you want to grant to the Active Directory user.
8. Select the General page, and then choose Ok.
9. Log out from the instance, and then log in again as a domain user.
10. Open SSMS. For Authentication, choose Windows authentication to log in with your domain user account.
11. Finally, choose Connect.

[Need help with the troubleshooting? We’d be happy to assist]

Conclusion

In short, today we saw how our Support Techs allow domain user access to SQL Server instance.