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

Posted on 2011-05-10
Last Modified: 2012-05-11
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.
Question by:thierry91
    LVL 22

    Accepted Solution

    You can run the following SP to change the DB owner in the local copy:
    EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    See image for more help image

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now