Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Could not obtain information about Windows NT group/user Expand / Collapse
Author
Message
Posted Monday, January 21, 2008 5:53 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 1:56 AM
Points: 438, Visits: 754
Hi All,

I am getting the following error while creating an assembly.
Please tell how to solve.


Could not obtain information about Windows NT group/user 'Excel\101', error code 0x5.


Thanks in Advance
Post #445423
Posted Thursday, April 24, 2008 6:48 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:18 AM
Points: 479, Visits: 136
Hi,

I have faced the same problem. I tried to figure it out in the internet and I found this article

If you encounter this

Could not obtain information about Windows NT group/user , 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.

To go to the original article click here ...
Post #489869
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse