Monday, June 25, 2012

SQLServer Error: 15404, Could not obtain information

Date  25/06/2012 08:40:01
Log  SQL Server Agent (Current - 25/06/2012 08:47:00)

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


If you ever clone sql server from other server. you might end up with this above error when you run any sql server agent jobs. Because name of the current sql server and oringally installed sql server is totally different.