< Blog

How to Create a SQL Server Computer Account Login

By Garth Jones

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 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 $ sign because if you don’t, the login name will be treated as a user account and not a computer account.

How to Create a SQL Server Computer Account Login-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. If you have any questions, please feel free to contact me @GarthMJ.