How to: Add machine account to SQL logins

It maybe necessary to grant access to SQL database for machine account (e.g. for App-V server machine account to App-V management database on remote server) & it can not be done through SQL Management Studio GUI. To accomplish this you may run following query:\n\n— Create a login for the machine account\n\nCREATE LOGIN [Domainmachine_name$] FROM WINDOWS\n\ngo\n\n— Verify newly created login\n\nSELECT * FROM sys.server_principalWHERE name LIKE ‘Domainmachine_name%’\n\ngo\n\n 

Leave a Reply

Your email address will not be published. Required fields are marked *