Author |
Topic |
Simon_L
Starting Member
32 Posts |
Posted - 2008-05-14 : 06:34:55
|
Using a box Ive got , sql 2000, mixed mode security , allow remote connections etc unless I grant a windows user sa rights it can connect to the server but cant see any databasesIf you give it public and datareader/writer to a db it still cant see it Im embarressed to ask as its bound to be simple but there you go !~si |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-14 : 07:02:04
|
What tool are the users connecting with? What service pack level is the SQL Server? |
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2008-05-14 : 07:10:55
|
SQL Server 2000 SP3 and trying to connect via EM |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-14 : 09:51:01
|
You might want to upgrade that to SP4 for a start, SP3 is no longer supported. |
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2008-05-14 : 09:55:50
|
I dont think thats related to the problem as both server and my local EM are at SP3 but its worth doing anyways thanks simon |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-14 : 10:17:42
|
Do you mean user databases, or the databases that SQL Server ships with (master, msdb, tempdb)? There is a setting in EM somewhere to hide system objects. Can the database(s) be used by the user within Query Analyzer? |
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2008-05-14 : 10:25:41
|
User databases, EM says no objects found under the databases tab, interestingly I can see the database and tables in query analyser in the tree view and by querying them |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-14 : 10:31:56
|
Since you can see them in Query Analyzer, that leads me to believe the problem is in EM itself. Problems with EM are pretty hard to troubleshoot, and generally end up with "remove and reinstall" as the solution. Is this the only workstation having this problem? |
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2008-05-14 : 11:34:09
|
well what is now really confuses me is whichever machine I access the server with (using different users in each case) and in each case EM fails and query analyser succedes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 23:35:50
|
Even on server itself? Tried reboot your pc? Tried reinstall sql tools on your pc? |
|
|
|