Post reply

sqlserver 2008R2 installation - Service account error in Error log

  • August 15, 2013 at 12:44 pm

    #297710

    Hello,

    I have installed sqlserver 2008R2 on new m/c as a part of migrating from sql 2005 to sql 2008.

    Next day I was looking the log and found the error message:

    Login failed for user 'MSSqlDB2K8\sqlsrvAcct'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

    I have created this account during installation but didn't add account int oadministrator group.

    I have also tried to login using same credential in SSMS and I can't connect.

    When tried to sto pand start the service i can do it.

    I have added user into Administer group but still not working.

    I have also assigned account in Sysadmin server Role into Security.

    Thank you!

  • August 16, 2013 at 6:43 am

    #1642130

    What is the default database for the login?

    SELECT default_database_name

    FROM sys.server_principals

    WHERE name = 'MSSqlDB2K8\sqlsrvAcct';

    GO

    Is the database online and in multi user mode?

    Cheers

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

  • August 16, 2013 at 9:28 am

    #1642224

    Thanks for your resposne.

    Default DB is MASTER.

    DB is ONLINE

    it's in MULTI_USER Mode

    I don't have any User DBs, only System DB

    Thanks.

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

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