web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / New Server Installatio...
Microsoft Dynamics SL (Archived)

New Server Installation - conversion from old

(0) ShareShare
ReportReport
Posted on by Community Member

I was wondering if anyone can help me.  We have a new server with server 2012, SQL 2014.  I have installed Dynamics SL 2015 on it.  So far so good.  I backed up the databases on the old server and imported/restored them on the new server/new sql.   But when I go to SL database maintenance to begin the conversion the database is not in the box.   I know I am missing a step but I don't see anything in the installation manual regarding this particular scenario.

I appreciate any advice.

Thank you

*This post is locked for comments

I have the same question (0)
  • William Dietrich Profile Picture
    William Dietrich 566 on at
    RE: New Server Installation - conversion from old

    I am having the exact same issue.  Trying to migrate and upgrade from SL 6.5 SQL 2000. I've created a staging system with SVR 2008R2 / SQL 2008. Once I bring the DB backups from the 2008 environment into the 2012/2014 and run the DB Maintenance, no databases show up?  I have already used sql to update the server name in the domain table. Any suggestions?

    Thank You

  • Community Member Profile Picture
    Community Member on at
    RE: New Server Installation - conversion from old

    I think it has something to do with the fact that the new server name is not the same as the old server name.  Also, The original server is a domain controller and the new server is just a server.   Not a domain controller.  I am looking in the system database data tables to find the name of the server so I can change it now.

  • Community Member Profile Picture
    Community Member on at
    RE: New Server Installation - conversion from old

    I change the domain table ServerName to the new server and now I see all the databases.   The Query I used:   Update domain set ServerName = 'Newserver' where ServerName = 'Oldserver'

  • Community Member Profile Picture
    Community Member on at
    RE: New Server Installation - conversion from old

    Also, there will be some work that needs to be done with users as well.  I haven't gotten there yet but I am sure that the users on the new system are not in the old data tables.

  • Community Member Profile Picture
    Community Member on at
    RE: New Server Installation - conversion from old

    If you are unable to see the database from the Find Database screen you need to make sure it is set to Trustworthy in SQL.

    • Check properties of System DB and look under Options

    • Make sure “Trustworthy” is set to “TRUE”

    • If not, then run following script against System DB:

      Alter Database “DBNAME”

      Set Trustworthy ON


  • Community Member Profile Picture
    Community Member on at
    RE: New Server Installation - conversion from old

    I was able to convert the database.  But now When I try to log in to do the registration I do NOT see the SQL server or database.  Weird.   I checked the Trustworthy settings - it is set to Yes for the system database and the application database.   In an older version I recall I was not able to log into Dynamics from the server.  Is that still the case?  Should I set up a workstation?

  • John_Joyce Profile Picture
    John_Joyce 1,042 on at
    RE: New Server Installation - conversion from old

    After you changed the Domain.ServerName, did you run DB Maintenance to update Views and Synchronize Security? I would recommend doing that.

    And you should have no problem connecting to SL from the server, after taking the steps noted above.

  • Community Member Profile Picture
    Community Member on at
    RE: New Server Installation - conversion from old

    I tried to do the update of views and synchronize security but it keeps failing.  NEWSERVERNAME\Administrator has insufficient Rights to update Report Rights

    Error Code 0 (zero)

    So the Servername is not the same as the old servername.  Not sure what I am missing.

  • RayD Profile Picture
    RayD 239 on at
    RE: New Server Installation - conversion from old

    Have you updated servername  to your new server in table domain in your sys database

    Ray

  • William Dietrich Profile Picture
    William Dietrich 566 on at
    RE: New Server Installation - conversion from old

    Jeremy,  my setting for Trustworthy is set to False and is grayed out. When I try to Alter DB I get this message:

    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near 'SLSYSTEM'.
    Msg 195, Level 15, State 5, Line 3
    'Trustworthy' is not a recognized SET option.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans