Skip to content

Server is in script upgrade mode. Only administrator can connect at this time.

While connecting to SQL Server instance you may get error message like ‘Server is in script upgrade mode. Only administrator can connect at this time’. Exact error message will be like:-

TITLE: Connect to Server

——————————

Cannot connect to TESTINSTANCE

——————————

ADDITIONAL INFORMATION:

Login failed for user ‘ad\username’. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18401&LinkId=20476

What causes this error?

One of the most possible cause is that some one is in the middle to install or uninstall some components of SQL Server like applying service patch, upgrade or service pack uninstall in SQL Server 2008 or 2008 R2, etc on this instance. Always check back with your database administrator if they are doing any of these tasks.