Post reply

SQL2005 can''t modify existing databases all of a sudden as admin?

  • June 8, 2007 at 2:27 am

    #174550

    Hi, dunno when this went belly up, but our SQL Server refuses to allow me to modify existing databases, even logged in as administrator..  I think it is something like SQL has removed administrator rights or administrator has been restricted in some way?

    eg: connect to the instance, navigate to the databases folder.. I see all the databases.

    If I RMC on any database and go properties I get the following.

    "Microsoft SQL Server Management Studio

    Cannot show requested dialog.

    Additional information:

    Cannot show requested dialog. (SqlMgmt)

    Failed to connect to server VPAPPS2. (Microsoft.SqlServer.ConnectionInfo)

    Cannot open user default database. Login failed.

    Login failed for user 'VICPARK\Administrator'. (Microsoft SQL Server, Error: 4064)"

     

    Now from the same SSMS screen on this server I can use 'Connect Object Explorer' and connect to another SQL Server (VPLIB) and get properties on it's database objects fine!

    Anyway.. I know it was all happy 2 weeks back, one of our guys was messing around upsizing some Access databases since then, I would guess he's modified something to cause it, but dunno what?

    Anyone seen these symptoms before and can advise..  real suck now..

    thanks

    AJ

     

     

     

  • June 8, 2007 at 4:32 am

    #711614

    Hi,

    This might be of some use to you.  It' mentions how to start the server in single user mode to get in to it.

    http://sqlblogcasts.com/blogs/simons/archive/2007/05/22/How-to-access-SQL-Server-when-you-ve-forget-the-password.aspx

  • June 28, 2007 at 4:54 am

    #715800

    Check what is the default database for the user and check if he has permission on that database. I have seen this error when a user has been assigned a database as default but no permissions are given for him in the database.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 28, 2007 at 7:52 pm

    #716045

    Working now..  bit confusing but..

    I had to add /'domain'/administrator to the sql logins (like alongside 'sa' )

    woof just worked.. even though I'm logging in using windows authentication?

    hmmm, checked our library server and /'domain'/administrator isn't on that box yet it

    logs in fine there!..  dunno, works anyway so urgency now surpassed..

    thanks for those that replied, much appreciated

    AJ

Viewing 4 posts - 1 through 3 (of 3 total)

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