I have done this on a server (windows server 2008) before, but can not achieve the same thing on another virtual server
I want a low level domain user to run the
MSSQLSERVER service so that I can enable backup to a remote network location, this is working fine on my other SQL Server 2008R2 instance.
I have a domain user called
fred@mydomain I have added this user to the server local administrator group and the group
SQLServerMSASUser$**MYSERVER**$MSSQLSERVER. This is the group I believe is the one that allows members to run the
I have created the login in SQL Server for the user and added him to all the server roles but dbcreator and mapped it to all the instance databases as a public database role
HOWEVER when I go to SQL Server Configuration Manager to change the
MSSQLSERVER service and selected the
fred@mydomain and press apply I get a log on error.
Can anyone suggest what I might have missed please ? I have used Here as my reference