tag:blogger.com,1999:blog-4291664034828038593.post3854983797049435943..comments2024-03-10T04:57:49.447+00:00Comments on Strictly Software: The database owner SID recorded in the master database differs from the database owner SID recorded in databaseRob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-4291664034828038593.post-62325738464324631222016-06-30T04:53:46.698+01:002016-06-30T04:53:46.698+01:00Glad to hear it!
This is such an annoying problem...Glad to hear it!<br /><br />This is such an annoying problem to get, and one I keep getting due to our tech guy backing up databases and restoring them when they move servers that cannot see each other.<br /><br />This and re-linking orphaned users with logins that happens with a DB backup / restore are very common problems to get with this kind of DB move (backup and restore) see this article Rob Reidhttps://www.blogger.com/profile/05430306492065347012noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-19695444726439151852016-06-29T17:04:20.045+01:002016-06-29T17:04:20.045+01:00Fixed my issue! thanksFixed my issue! thanksErikhttps://www.blogger.com/profile/16800670020971365553noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-63927330352250951742015-12-15T08:25:58.149+00:002015-12-15T08:25:58.149+00:00Excellent Article, Thanks! it helped me.
Excellent Article, Thanks! it helped me.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-17845634511774863642015-09-23T16:31:59.590+01:002015-09-23T16:31:59.590+01:00thanksthanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-59098206971774115152015-09-16T22:10:12.663+01:002015-09-16T22:10:12.663+01:00Oh are my life saver right now.I have to create a ...Oh are my life saver right now.I have to create a job to send email for data compare and I was not able to run EXEC msdb.dbo.sp_send_dbmail because of those errors.Now ........ Hurray!!!!!!!!!!Anonymoushttps://www.blogger.com/profile/07719223304936184592noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-80444235216052550242014-09-19T11:51:46.202+01:002014-09-19T11:51:46.202+01:00Thanks a lot. It help us to resolved the issue ASA...Thanks a lot. It help us to resolved the issue ASAP.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-4095582296597339022014-08-08T15:58:33.108+01:002014-08-08T15:58:33.108+01:00The thing with SA as owner is that hackers know it...The thing with SA as owner is that hackers know it is commonly used as the main user so they will probe for it. <br /><br />Changing your user from SA to something else is a good practise for security sake I think.<br /><br />Thanks<br /><br />RonRob Reidhttps://www.blogger.com/profile/05430306492065347012noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-20103408996671648992014-08-08T08:38:28.069+01:002014-08-08T08:38:28.069+01:00Great article thanks! It really saved me.Great article thanks! It really saved me.Jonas2400noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-29586011347466209042013-08-16T11:56:01.104+01:002013-08-16T11:56:01.104+01:00This article help me to fetch the reports.Learning...This article help me to fetch the reports.Learning few commands on MSSQL.Great help<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-65885007222324451532012-04-09T17:55:41.791+01:002012-04-09T17:55:41.791+01:00THANKS!!!THANKS!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-19867043118002459592011-11-29T22:10:31.606+00:002011-11-29T22:10:31.606+00:00Solved my issue when upgrading from sql 2005 to sq...Solved my issue when upgrading from sql 2005 to sql 2008. I had to run the following command to fix msdb ownership issue:<br /><br />ALTER AUTHORIZATION ON Database::msdb TO sa<br /><br />Thank you very very much. This is a great post!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-70990125634465024322011-09-28T20:35:56.510+01:002011-09-28T20:35:56.510+01:00thank you very much. I really appreciate your help...thank you very much. I really appreciate your help and effort putting this article.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-12210821024875543072011-09-15T21:51:38.652+01:002011-09-15T21:51:38.652+01:00Perfect solution for that problem.
Thanks a lot, G...Perfect solution for that problem.<br />Thanks a lot, Great jobAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-61189345610250460262011-06-15T09:55:41.285+01:002011-06-15T09:55:41.285+01:00Thank you, this solved my problemThank you, this solved my problemAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-91177034773416952452011-03-19T03:36:09.533+00:002011-03-19T03:36:09.533+00:00It would be too bad, if I use the solution and not...It would be too bad, if I use the solution and not say thank you. This is great article and it helped me big time.<br /><br />THANK YOU VERY MUCH!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-75209399994406661242010-12-16T21:16:22.398+00:002010-12-16T21:16:22.398+00:00After a restore, I like make sa the owner of the d...After a restore, I like make sa the owner of the database. That way I will never have this issue.<br /><br />EXEC sp_changedbowner 'sa'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-63705564753732512572010-06-04T18:02:29.689+01:002010-06-04T18:02:29.689+01:00Good job.. nice write up.Good job.. nice write up.Unknownhttps://www.blogger.com/profile/08746584540851577490noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-26191594441684323662010-02-17T16:47:24.249+00:002010-02-17T16:47:24.249+00:00I had a database created by user sa on one server ...I had a database created by user sa on one server (2005), then backed up, and then restored on new server (2008) by DOMAIN\Administator.<br />Changing the dbo account from DOMAIN\Administrator to user sa on new server solved my problem. :-)Kilted Vikingnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-13307449418332191312009-12-03T20:31:47.460+00:002009-12-03T20:31:47.460+00:00Great article. It saved my life
Thanks
Thanks
Tha...Great article. It saved my life<br />Thanks<br />Thanks<br />Thanks again.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-53367195682412758842009-10-26T05:35:34.967+00:002009-10-26T05:35:34.967+00:00Deepest thanks and profound gratitude for posting ...Deepest thanks and profound gratitude for posting this article. I couldn't figure out how to resolve those pesky SQL USER SIDs after migrating a database from SQL 2003 server to SQL 2008 server.<br /><br />you are awesome!!!!!Anonymousnoreply@blogger.com