Archive

Change authorization to ease SQL Server development

2007-06-25 14:11:34 by Kjell-Åke Gafvelin

When you are not connected to a domain SQL Server might give you an error like the following:

An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user '[Domain]\[User]', error code 0x54b.

To fix this you could execute the following in SQL Server:

ALTER AUTHORIZATION ON DATABASE::[<Database>] TO [sa];

|