Unable to detect databases

Analyze, manage and fix database
index fragmentation

Unable to detect databases

Postby m_c_rose » Tue Feb 19, 2013 6:27 pm

I am trying to connect to a remote database, when I enter the server and authentication info in the database drop down it shows
<Unable to detect databases>
From the same client I have validated i can connect with OSQL and can retrieve the databases with EXEC sp_databases, and SELECT name FROM master..sysdatabases.

Mike R.
Posts: 2
Joined: Tue Feb 19, 2013 6:08 pm

<Unable to detect databases>

Postby m_c_rose » Tue Feb 19, 2013 6:44 pm

Some additional information, if run Index manager on the server and enter the same information I get "Error: Invalid object name 'master.sys.databases'."
The servr I'm trying to diagnose is SQL 2000, I can't find anything statiing this product is not compatible with SQL 2000.
Posts: 2
Joined: Tue Feb 19, 2013 6:08 pm

Postby StephenC » Thu Feb 21, 2013 6:21 pm

Hi Mike,

I'm afraid that Index Manager doesn't support SQL 2000.

Very sorry this information wasn't included and I'll update the product page to reflect this.

Apologies for the inconvenience.


Posts: 305
Joined: Mon Oct 15, 2007 8:18 am
Location: Cambridge

Return to SQL Index Manager

Who is online

Users browsing this forum: No registered users and 0 guests