Wednesday, June 22, 2016

SQL Server error Cannot execute as the database principal because the principal “dbo” does not exist

After restoring adventure works database, when trying to see database diagrams I got an error Cannot execute as the database principal because the principal “dbo” does not exist.

The solution is to reassign database owner using script
use [databasename] EXEC sp_changedbowner 'sa'

 More Info
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

c# httpclient The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch

 If we get this error while trying to get http reponse using HttpClient object, it could mean that certificate validation fails for the remo...

  • SharePoint export and import terms
    SharePoint has a great feature to set terms which can be used to tag contents and enable terms based navigation and several other interesti...
  • (no title)
    Responsive design http://webdesignerwall.com/tutorials/5-useful-css-tricks-for-responsive-design http://palantir.net/blog/responsive-de...
  • Secure micro services using jwt and ocelot
      Secure Microservices Using JWT With Ocelot in .NET Core (code-maze.com)