join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
Suspect SQL Server 2000 Database - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Suspect SQL Server 2000 Database

Last post 11-10-2008 2:22 PM by Dominique. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-19-2007 12:00 AM

    Suspect SQL Server 2000 Database

    This post is related to this tip: Suspect SQL Server 2000 Database

    http://www.mssqltips.com/tip.asp?tip=1204

  • 11-10-2008 2:22 PM In reply to

    Re: Suspect SQL Server 2000 Database

    Hello,

    These articles are great as they solved my issues..

    But as a local administrator I was not able to see any databases in SQL Enterprise Manager having a login failed for any account I was using.

    Only a Domain Administrator was able to access it and let me correct the issue... which permissions was missing for me to be able to do the same correction on SQL without being a domain administrator?

    I am dbo on several databases and also sysadmin role on them.

    Should I be dbo on master? will it be enough?

    Thank you,
    Dominique

Page 1 of 1 (2 items)