1
Vote

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

description

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.
 
@cstripathi Note: Same I posted in the discussions. Also other users has some suggestions, you might consider doing those changes.
 
Regards,
 
Vankayala

comments