Databases missing in Enterprise manager SQL 2000

Question

Databases missing in Enterprise manager SQL 2000

Ajay Deshpande

Old Hand

Points: 339
More actions
August 14, 2006 at 8:30 am

#61605

Hello,
We are having problem viewing databases for some users under enterprise manager. The databases are present on SQL Server. we can see those databases when connected as sa or system adminsitrator. please help. In past when I used to disconnect and connect as sa and then connect as that user those DBs used to reappear but this time its not working. This trouble is not related to client workstation as we tried it on different workstation.
Thanks a lot.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 1

It's a permissions issue with the other users. If you don't have access to the database it will not show up in enterprise manager for your user.

Thanks

Tom

Ajay Deshpande Old Hand Points: 339 More actions · Answer 2

Tom,

The users are having permissions. They can query those dbs in query analyzer.

Thanks

Ajay

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 3

Do they see any databases within enterprise manager?

Tom

Ram Ram Ten Centuries Points: 1079 More actions · Answer 4

Run this below query in query analyzer and get the output of query and run it again.

USE Master

GO

SELECT A.RunThisQuery

FROM

(

SELECT 1 AS ColId,'ALTER DATABASE '+[Name]+ ' SET ONLINE' AS RunThisQuery FROM SysDataBases

WHERE DatabasePropertyEx([Name],'Status') = 'OFFLINE'

UNION

SELECT 2 AS ColId,'ALTER DATABASE '+[Name]+ ' SET OFFLINE' AS RunThisQuery FROM SysDataBases

WHERE DatabasePropertyEx([Name],'Status') = 'OFFLINE'

) AS A

ORDER BY A.ColId

GO

Ram Ramamoorthy

Ajay Deshpande Old Hand Points: 339 More actions · Answer 5

Error: 0, Severity: 19, State: 0

SqlDumpExceptionHandler: Process 68 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

I was getting this error in eventlog. Looks like the problem caused due to restoration of some new dbs on this server from some other server. The problem went away when we dropped those new dbs. Now we are trying to figure out why this would cause a problem.

Thanks for your help

Sanki007 SSC Enthusiast Points: 178 More actions · Answer 6

Check how the SQL Server is registered in Enterprise manager. May it was registered with different user name than the actual user using it. Or Remove the SQL Server Registration in EM and re-register with current user name.

Ajay Deshpande Old Hand Points: 339 More actions · Answer 7

Alright guys found the problem. The problem was with missing guest user in the newly restored databases. Here is the kb article from Microsoft. The article also mentions on how to recreate the guest users where ever it is missing. Its not simple sql where you can go and say sp_adduser

Here is the link:

http://support.microsoft.com/kb/315523/

Thanks for all your help.