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.
LVL 1
thierry91Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.