April 12th, 2004, 08:30 AM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL User has no access via Enterprise Manager
I have a SQL Server 2000 instance running sp3 (in a cluster).
When I create a NEW SQL user, and give that user access to ONE database (public and DBO) I cannot list ANY databases from Enterprise Manager when I login with that user. If I refresh the Enterprise Manager Databases View, eventually it will display the Databases - but only after about 10 minutes and I get access violation errors in my SQL and NT logs. Even if I create a 'dummy SQL login' and give it access to Northwind, the same results - I cannot list databases in Enterprise Manager. I tried changing the users default DB to Master - but I got the same results.
I tried to recreate this problem on another Clustered SQL Server 2000 Instance - this one running sp3a, and I am NOT able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does anyone have any suggestions?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
