Unable to detect databases

Analyze, manage and fix database
index fragmentation

Moderators: StephenC, dlkj, Chris Lambrou

Unable to detect databases

Postby m_c_rose » Tue Feb 19, 2013 7: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.

Thanks
Mike R.
m_c_rose
 
Posts: 2
Joined: Tue Feb 19, 2013 7:08 pm

<Unable to detect databases>

Postby m_c_rose » Tue Feb 19, 2013 7: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.
m_c_rose
 
Posts: 2
Joined: Tue Feb 19, 2013 7:08 pm

Postby StephenC » Thu Feb 21, 2013 7: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.

Regards,

Stephen
StephenC
 
Posts: 306
Joined: Mon Oct 15, 2007 9:18 am
Location: Cambridge


Return to SQL Index Manager

Who is online

Users browsing this forum: No registered users and 0 guests