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.
sql