SQL Server could not obtain information about Windows NT group/user 'DOMAIN\user_account'

Question

I have cloned our Microsoft SQL to a new server. The server contains a few databases and "SQL Server Agent" jobs that run on a scheduled basis. I have tried changing all existing references to this new server name and use accounts on this new server. However I am still getting the following error in my error log and my jobs fails to run (btw, this is through Microsoft SQL Management Studio),

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\user_account', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

I've got a couple of Maintenance Plans which are pointing to the old server. For some unknown reason I can't edit the existing connection and I can't delete it. I can add a new one but the other connection can not be removed.

I need to know where I need to change for this error to go away and the jobs start running.

Answer 1

This may be because SQL has the wrong server name in Master. Here is another article on the subject.

SQL Server Central Article

In order to fix this, run a search on Master with the following code:

use master
select SERVERPROPERTY('servername')
select @@SERVERNAME
select SERVERPROPERTY('machinename')
go

If you see the old server name in the list you will have to drop the server and add the new one

use master
exec sp_dropserver "OldServerNmae"
go

use master
exec sp_addserver "NewServerName","local"
go