sqllib error: sysdatabases in SQL server instance is empty

  • 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

  • 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..

  • 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

  • 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

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

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