Upgrading MSSQL

  • 3405730
  • 04-Jul-2007
  • 26-Apr-2012

Environment


Microsoft SQL 2000
Microsoft SQL 2005
Sentinel 5.1.xx Sentinel Server

Situation

To upgrade an existing Sentinel 5.1.1.0 (with Microsoft SQL Server 2000) installation to Microsoft SQL Server 2005 (Yukon) Database:
1. Shutdown the Sentinel Server and all Database connections
2. Run the Microsoft SQL Server 2005 installer in the Sentinel Database host and choose upgrade existing Database. Please follow the steps provided by Microsoft.
3. Execute the following commands on the machine with DAS installed:
Open a Command Prompt.
cd /d %ESEC_HOME%\sentinel\config
.\dbconfig.bat -a . -s mssql2005 -ws mssql2005
4. Restart Sentinel Server.