sqllib error: sysdatabases in SQL server instance is empty

Question

sqllib error: sysdatabases in SQL server instance is empty

Viewing 4 posts - 16 through 18 (of 18 total)

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

grc1uk SSC Eights! Points: 849 More actions · Answer 1

The backup software is runing as domain\administrator, this user is added to SQL within the Security and looking at the server roles it is a member of Public and Sysadmin

I would have thought that this would be pretty much full control of the SQL Server?

Gareth

Carlton Leach SSCarpal Tunnel Points: 4202 More actions · Answer 2

yup your right. Have you run a trace on the server while its going?

it may not tell you but it may provide you with some info.

it screams permissions to me, a lot of 3rd party sttuff runs under odd accounts, I presume you found what it login it uses through the SQL logs?

cheers,

Carlton..

grc1uk SSC Eights! Points: 849 More actions · Answer 3

No i checked what it uses to run looking within services and checking what the service is running as.

Also i have not run the profiler as im not 100% sure how to but i am looking in to it.

thanks

Martin Gleeson Ten Centuries Points: 1096 More actions · Answer 4

Hi all,

You're best bet to understand what's happening is to read these two:

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

http://technet.microsoft.com/en-gb/library/cc966520.aspx

Cheers,

Martin