sql server 2005 - Error when creating assembly in SQL: MSG 33009 -


I am trying to load a DLL in MSSQL:

  Uses DBN Make ASSAMBI from 'C: \ FU \ FU DILE' PERMISSION_SET = UNSAFE with Go  

and I'm getting an error which states:

 Message 33009 , Level 16, State 2, the database owner, SID, entered in the line 2 master database, has entered the database 'dbname' from database owner SID. You should change this situation by resetting the owner of the database 'dbname', which is an ALTER AUTHORIZATION statement. 

MSDN is not really telling me about the error.

I have seen everything on the internet and it has come to the conclusion that only to avoid doing this is done:

  Use DBN to go EXEC dbo Sp_changedbowner @loginame = nsa ', @map = false  

But the only way to avoid this error is by changing the owner? Why do I have to do this, is there another way? I want to know more about this error before I come in and let the owner close my eyes.

I was the exact problem and only the solution was for me to change the owner, then it Changed back.

The problem is that users are both per database and per-server What is the per-database user with username that is similar to a per-server user, although they do not match SIDs, So it thinks that it can be a different person.


Comments