I am using SQL Server 2008 R2. When I try to execute a maintenance plan I get the following error:
Message  SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'WIN-6QFI9JAK804\sqladmin', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
I ran the following queries:
sp_dropserver 'WIN-OldName' GO sp_addserver 'VM-MSSQL-2008R2', local GO
I then restarted the MSSQLSERVER service and the agent service.
When I run
select @@servername I do get
VM-MSSQL-2008R2 returned however the original error persists when I try to execute the maintenance plan again.
Is there another step that I haven't performed yet?
select * from msdb.dbo.sysssispackages
and noticed that the only plan is called Backups. So I instead ran the query:
UPDATE msdb.dbo.sysssispackages SET ownersid = SUSER_SID('VM-MSSQL-2008R2\sqladmin') WHERE name = 'Backups'
I ran the following two selects to make sure that the are the same:
select SUSER_SID('VM-MSSQL-2008R2\sqladmin') select ownersid from msdb.dbo.sysssispackages WHERE name = 'Backups'
And they both return the same value.
When I run the plan, I get the same error message as before.
(I have created a new Backup Plan, but I'd still like to figure out why this one is working just for knowledge's sake)