Can Access a database on one client but not another

[knerve1]

Anyone,

One PC has SQL Server Enterprise Manager MMC 1.2 version 5.0 sp.4 Windows 2000. I can access all databases.


The other PC has Enterprise Manager 8.0 and MMC 2.0 v5.1 sp2.0 on a windows XP machine. Cannot access all databases.


Has anyone ever encountered a problem like this? Any help would be greatly appreciated.

Thank you.

 

[fuzzyocelot]

Are the databases located on a server or locally on each computer? Can you access the databases through Query Analyzer? Also, what version of SQL are you connecting to? (i.e. 6.5, 7, 2000...)

 

[knerve1]

The database is on a server. Cannot access through Analyzer or EM on the XP machine but can on the 2000. Connecting to sql 2000 sp3.

Thanks for the reply.

 

[fuzzyocelot]

When you say you can't access them, are you getting any error messages? Are you connecting but not seeing databases?