Perry, thanks for your help.
Perry Whittle (7/30/2015)
wayne.mcdaniel (7/29/2015)
* The user is a member of the dbcreator role - and the serveradmin and sysadmin rolesOnce you grant sysadmin to an account all further permission checking is disabled, granting other roles is a futile exercise
wayne.mcdaniel (7/29/2015)
* The user is a member of dbowner on the database I am trying to overwrite with the restore* I have given the user the rights CREATE DATABASE and CREATE ANY DATABASE
All of this negated by granting sysadmin
We kept trying to escalate permissions to make it work, unsuccessfully. I eventually gave the account sysadmin. Once we get it working, we'll knock it back down to where it should be.
What does this return
select @@servername, serverproperty('servername'), server_id, name
from sys.servers
where name = @@servername
It was returning two different names - they let us fix the name and reset SQL this morning, and now we have the same name for both.
Now, however, the job returns a new error,
Message
The job failed. Unable to determine if the owner (MYDOMAIN\MYUSER) of job Make reports has server access
(reason: Could not obtain information about Windows NT group/user 'MYDOMAIN\MYUSER',
error code 0x6e. [SQLSTATE 42000] (Error 15404)).
I assume this is some kind of failure to talk to AD and the domain controller. They are going to run Windows updates tomorrow morning during maintenance and reboot the whole server, and I'll either report back success or a new error.