How to fix error: ... Please check, all system services running or not.

Aug 17, 2011 at 10:31 PM
Edited Aug 17, 2011 at 10:32 PM

Hi,

For your login, If your default database is not Master, the you will see the error:

   Error loading database-tables into list: User does not able to connect with server instance (@ServerName) . Please check, all system services running or not.

Change: (File: Resources\DALResources.resx in the sourcecode tree)

SELECT name AS DATABASE_NAME, dbid AS DATABASE_ID, crdate AS DATABASE_CREATEDATE FROM SysDatabases ORDER BY DATABASE_ID

To:

SELECT     name AS DATABASE_NAME, DATABASE_ID, create_date AS DATABASE_CREATEDATE FROM sys.databases ORDER BY DATABASE_ID

Recompile the project and it should work.

Regards,

Vankayala

Coordinator
Sep 29, 2011 at 7:18 AM

Hi Vankayala,

Thanks for the code, will include this change in next release.

-Chandra Shekhar Tripathi