Friday, February 24, 2012

enterprise manager can't see databases

Hi everyone,
Happy New Year ! Another year of fun ahead, solving sql server problems. I c
an hardly wait !
We have Sql Server 2000 installed on a server called taggart. On the client
p.c. we have Enterprise Manager and Query Analyser installed.
Using query analyser I can connect to taggart and can see all it's databases
no problem.
Using enterprise manager I can connect to taggart ok but can't see it's data
base. It says 'no items' ! I tried to delete the sql server registration an
d re-created it but it still can't see them. I can connect to other servers
using enterprise manager an
d can see their databases ok, just not this server.
We tried re-booting the server but that had no effect.
Eileen.Can you connect using Query Analyser and run the folllowing query?
select * from master..sysdatabases
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||yes i can|||I get an entry for each database in the following
d:\MSSQL\data\msdbdata.mdf
d:\MSSQL\data\northwnd.mdf
d:\MSSQL\data\pubs.mdf
d:\MSSQL\data\tempdb.mdf|||log-files on two of the databases had filled up their log partitions. shrink
ing this allowed us to see the databases.

No comments:

Post a Comment