Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SQL 2005
Microsoft Dynamics SL (Archived)

SQL 2005

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are trying to migrate a customer froma sql 2000 server to a new server with sql sever 2008.

The customer is on Solomon 6 and we are planning the migration to SL2011.

After we installed the new sql server and restore a backup of the Dynamics SL databases to the new server, we tried to conect the database manitenance screen to the new server to synchronize the databses  before the migration to Dynamics SL 2011. When we try to connect to the new server we get the message:

Error -2147165949: [Microsoft][ODBC SQL Server Driver][SQL Server] To connect to this server you must use SQL Server Management Studio or SQL Management Objects (SMO)

How can I connect the Database Maintenance to the new SQL server

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL 2005

    One problem that occurs when you move DB's from one server to another is the SQL Server name is different.  Solomon stores the server name in your System Database table called "Domain".  You need to update the domain table and change the server name for all the records.  Another problem when you restore databases is that the SA account SID doesn't match between the database and the new server.   You need to run  

    EXEC sp_changedbowner 'sa'  

    on each database you restored to the new server.  

    After that, try again.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: SQL 2005

    Are you coming from SQL 2000 or 2005? What is the compatibility level of the DB in 2008 when you go to properties -> Options?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans