Unable to open the specified server database

Question Status

MSQ asked a question on 9 May 2012 8:51 AM

I have a new SL 7.0 setup on a WIndows 2008 Server using MS SQl Server 2008 database. I also have setyp a Blank and a Demo compnay.

When I launch SL Database Maintenance and search for database (Application - > Open Company - > Find Database); I get the following error:

"Unable to open the specified server database MyServername"

What am I doing wrong?


Ruben Juarez responded on 9 May 2012 11:22 AM

Probably the best place to start is to check the ServerName in the Domain table of the System database.  If it is not correct use the following statement to correct it: Update Domain set ServerName = 'MyServerName' where DatabaseName = 'MyDatabaseName'