How to Create a SQL Server Computer Account Login

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. If you have any questions about the steps in this blog post, please feel free to contact me @GarthMJ. Or, you can leave a message in the comment section below.

See how Right Click Tools are changing the way systems are managed.

Immediately boost productivity with our limited, free to use, Community Edition.

Get started with Right Click Tools today:

Share this:

en_USEnglish