Endpoint Insights

How to Create a SQL Server Computer Account Login

Topics: Endpoint Insights

It is not always obvious how to add a SQL Server computer account login, but you will need to create one when SQL Server is remote to the Configuration Manager primary site server or CAS server.

Start by opening SQL Server Management Studio (SSMS) and connect to your SQL Server. Remember, in SQL Server 2012 and later, SSMS is NOT included with the ISO media, so you may have to add an extra step here to download it first.

How to Create a SQL Server Computer Account Login-Connect to SQL Server

In the Object Explorer window, expand the Security | Logins nodes.

How to Create a SQL Server Computer Account Login-Object Explorer Window

Right-click on the Logins node and then click on New Login

How to Create a SQL Server Computer Account Login-New Login

In the Login – New window, select the Search… button.

How to Create a SQL Server Computer Account Login-Search

In the Login name text box, type:

<domain name>\<computer name>$

It is important to include the dollar $ sign because if you don’t, the login name will be treated as a user account and not a computer account.

Login Name

After you assign the appropriate rights to the computer account, don’t forget to click on the OK button in order to close the window.

With that last step completed, the computer account will be able to login immediately.

Conclusion: How to Create a SQL Server Computer Account Login

If you have any questions about the steps in this blog post, please feel free to contact me @GarthMJ or reach out to Recast Software here.

Back to Top