ref: https://www.enhansoft.com/updated-how-to-create-a-sql-server-computer-account-login/
This post will probably work for other use cases, but I am specifically needing it for VMware App Volumes Manager.
Open SQL Server Management Studio (SSMS)
Expand Security
Right-click Logins
Select New Login…
1. Do not use the Search… button! Type the Login name: as
DOMAIN\computer-name$
The dollar sign is necessary to signify the account as a computer and not the name of a user. (ref: https://social.technet.microsoft.com/Forums/en-US/eec574c0-5421-4d7a-a806-a3c5af3d29bf/why-in-samaccount-name-of-computer-account-in-active-directory?forum=winserverDS)
2. Choose the Windows authentication radio button.
3. Select the Default database for App Volumes Manager if it was already created. You can assign it later after creating the database if needed.
4. Select the Default language
Do not click OK!
On the Server Roles page, choose the sysadmin checkbox to grant the role to the user. Don’t click OK, yet.
On the User Mapping page, Choose the checkbox next to the database being mapped to the user (computer) account (assuming the database has already been created).
Click OK.
Verify the computer account is added to the list of logins.
This concludes this post.
Leave a Reply