Can't see database on new server

(0) Share

Report

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

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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 245 on at

Like (0)

Report

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 on at

Like (0)

Report

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