Red Gate forums :: View topic - Unable to detect databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Index Manager
SQL Index Manager forum

Unable to detect databases

Search in SQL Index Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
m_c_rose



Joined: 19 Feb 2013
Posts: 2

PostPosted: Tue Feb 19, 2013 7:27 pm    Post subject: Unable to detect databases Reply with quote

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.
Back to top
View user's profile Send private message
m_c_rose



Joined: 19 Feb 2013
Posts: 2

PostPosted: Tue Feb 19, 2013 7:44 pm    Post subject: <Unable to detect databases> Reply with quote

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.
Back to top
View user's profile Send private message
StephenC



Joined: 15 Oct 2007
Posts: 315
Location: Cambridge

PostPosted: Thu Feb 21, 2013 7:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group