Tuesday, March 27, 2012

Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.