Tuesday, July 19, 2016

dbo orphaned user

After I Restore SQL database from Production to Stage, Application was unable to connect and I saw dbo as orphan user .


Fix:Changed the database owner to SA fixed.

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...