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
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.