Issue
The reconfiguration of the log database (run from TAC Vista Server Setup) times out. Configuring the settings, for the first time after upgrading Vista, on the SQL server tab of TAC Vista Server Setup an then clicking on apply makes the following message appear: "Log database found but needs to be reconfigured. Reconfigure Log database?". After clicking yes the reconfiguring process starts, but times out. The message states the following:
Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
Environment
TAC Vista 5.1.X
SQL server
Cause
The SQL server is busy. When a reconfigure of the database layout (or schema) is done, all connections to the database must be stopped to prevent corruption of data. If a number of applications/clients are trying to write data to the database, the request to lock the database will time out.
Resolution
Close the open connections to the database and try again. Generally speaking this shouldn't occur with just Vista running. It is when 3rd party clients access the SQL data directly that this problem can occur. To help identify the problem, the Activity monitor in SQL server management studio can be used.
