CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

If you encounter this

Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5.

When you try and CREATE an ASSEMBLY, you might think well I'm not connected as that user. The user it sqawks about is the database owner.

I run on a laptop and often find myself not connected to the domain (although I can still log in with cached domain credentials). When I create a database the database automatically becomes owened by my domain account so when I then try and create an assembly it sqawks because it can't verify the domain account that owns the database.

The simple way around this is to create a sql user account and change the database owner to that user.



-
Published 28 November 2006 11:18 by simonsabin

Comments

01 October 2014 19:05 by van Man London

# van Man London

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user - Simons SQL Blog

02 November 2014 06:13 by dragons world cheats ios

# dragons world cheats ios

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user - Simons SQL Blog

13 November 2014 11:27 by mah jong set

# mah jong set

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user - Simons SQL Blog

13 November 2014 21:49 by appliance service

# appliance service

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user - Simons SQL Blog

15 November 2014 04:22 by For more details, you can visit site

# For more details, you can visit site

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user - Simons SQL Blog

20 November 2014 06:39 by jamaican mafia 2014

# jamaican mafia 2014

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user - Simons SQL Blog