Post reply

URGENT HELP: Please HElp

  • December 3, 2010 at 9:58 pm

    #388365

    Unable to connect sql 2008 after applying sp2. The install says successfully upgraded, but can't connect to studio management when I connect using my account getting this error.

    Login failed for user '<Domain Name>\<user name>'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

    //please help or provide the site to resolve this issue. Thanks:crying:

  • December 3, 2010 at 10:22 pm

    #1258718

    If it's a named instance, you may need to connect by ServerName\InstanceName

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • December 3, 2010 at 11:04 pm

    #1258727

    @hydbadrose,

    Please start SQL Server instance from the command prompt (sqlservr.exe). Wait for a few minutes until the master database is upgraded. Then try connecting to the instance using SSMS

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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