Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Can't see database on ...
Microsoft Dynamics SL (Archived)

Can't see database on new server

(0) ShareShare
ReportReport
Posted on by Bev Kaufman 280

We currently have SQL 2008 R2 loaded on a small business server.  The Dynamics SL application is on a VM server, which is Windows 2008.  The goal is to move the database to Windows 2012.

I have installed Sql 2008 R2 SP3 on Windows 2012.  I restored a test SL application and system database to the new installation.  I made the appropriate changes to the Company and Domain tables.  I ran updates on views and procedures in DB Maint.

But when I try to load the test database, the application can't see it.  At first it couldn't see the server, but I found a line in the user's Solomon.ini where the available servers are listed.  I can now select the correct server, but it can't see any databases on that server.

What am I missing?

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Can't see database on new server

    Hi Bev,

    We have faced the same problem during our SL 2011 FP1 upgrade. But we found out the workaround for that.

    Workaround:

    Delete the solomon.ini file in the following path "C:\Users\UserID\AppData\Roaming\Microsoft Dynamics SL"

    Let me know the above workaround will resolve your issue.

    Thanks

    D.Santhosh

  • Mark McClelland Profile Picture
    Mark McClelland 245 on at
    Re: Can't see database on new server

    Bev, if you are using SL 2011, be sure to run the "Synchronize All Ownership & Security" scenario as well.

  • Suggested answer
    Blaine Bryant Profile Picture
    Blaine Bryant on at
    Re: Can't see database on new server

    Bev,

    Did you complete all of the steps in this article?

    KB 846350

    Steps to take to move the Microsoft Dynamics SL databases to another computer that is running SQL Server 2000, SQL Server 2005, or SQL Server 2008

    mbs.microsoft.com/.../KBDisplay.aspx

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans