• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

how solve problem with not same SID of owner when I import database

hello
after big problem with serveur I have make new serveur MSsql 2005 and imported in the backup of database.

My probleme is when I run the software that uses this database, I have this message:

The owner SID of the database stored in the master database differs from that recorded in the database CHARP"

I'm not really good with mssql so if you could provide a solution sufficiently clear.

thank you very much in advance.
0
thierry91
Asked:
thierry91
2 Solutions
 
Om PrakashCommented:
You can run the following SP to change the DB owner in the local copy:
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
0
 
Alpesh PatelAssistant ConsultantCommented:
See image for more help image
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now