The server returned an unknown status code (1226)

[glazej]

Users are experiencing the following status code:

The server returned an unknown status code (1226)

Vault 5.0
Server 2008
SQL Server 2008

Database seems to be in single user mode, don't know why or if it should be. I am not an experienced SQL db admin.

[lbauer]

If the database is in Single User mode, only one user can log in; others are locked out.

Were there any recent updates/backups/maintenance involving SQL Server or Vault? These could have put the database in Single Use mode so no changes could be made during those actions.

[glazej]

Yes, I ran a backup from within Vault admin tool, and it seemed to run forever.
I eventually had to refresh the browser window (the next day).

From your response I might assume that the backup did not complete? ... or did not reset the database to multiuser after completing backup?

[lbauer]

It might have completed, and not reset the database user to multiuser mode.

I would suggest restoring a copy of the database on a test machine to make sure that it's good. We've had other reports of the backup hanging, but still completing the operation.

To put the database in multiuser mode with SQL Server 2008 Management Studio, right click on the sgvault database and select Properties. In the Properties window, look for Options->State->Restrict Access. Change from Single_User to Multi_User.

[glazej]

When I right click on sgvault in the Mamagement Studio, and select properties, I get an error:
"Cannot Show Requested Dialog"
Database 'sgvault' is already open and can only have one user at a time. (.Net SqlClient Data Provider)


Now also getting following error when I try to log in to Vault admin tool on the server itself:
The Vault Server could not establish a connection to the database. Please check the server's log for detailed information. (FailDBConn)

[glazej]

OK, here is what I did:

I restarted the www service, then was able to access Vault admin again.
Then I accessed SQL management studio and I tried resetting the sgvault to multi-user following your instructions, and was able to reset it and sgmaster to multi user.

Dare I attempt a back-up to see if it completes without leaving it in single user mode?? If I do I should wait till after hours when users are expected to be out of Vault.

[lbauer]

I'd wait until after hours. If it hangs again, check the Vault Server log to see if there are any errors. It's called sgvault.log and is in %windir%\temp\sgvault on the server machine. Let us know if anything is logged as a result of the hang.

You might also consider setting up automated backups through SQL Server itself.

For instance if your right-click on the database in SQL Server Management Studio and select Tasks->Backup, you can setup a backup.

For regular backups you can create a maintenance plan. This is in SSMS under Management->Maintenance Plan.

More info here:
http://msdn.microsoft.com/en-us/library/ms187510.aspx
http://msdn.microsoft.com/en-us/library/ms189036.aspx


BTW -- another option for changing the mode is by script:

*ALTER DATABASE [<database_name>] SET MULTI_USER