Moving HP SIM 5.x to a new Windows system (441289-003, January 2009)

4
Migrating HP SIM 5.x with local MSDE/SQL Server 2005
Express database to another HP SIM system with remote
MS SQL 2000/SQL 2005 database
NOTE
: HP does not recommend migrating the HP SIM local database to a new HP
SIM system with a
local database.
This section assumes you have already configured the following:

Source central management server (CMS)
-
The system where HP SIM 5.x is installed with
MSDE/SQL Server 2005 Express.

Target CMS
-
The system to which HP SIM
5.x is going to migrate. It assumes that this machine
meets the prerequisites for the installation of HP SIM 5.x using remote database.

Database System
-
A system where MS SQL Server 2000/2005 is installed for the remote
connection.
For more details about
HP SIM 5.x prerequisites, refer to the
HP SIM User Guide
and
HP SIM
Release
Notes
located on the HP Management CD. This section consists of three migration stages:

Pre
-
Migration
–
Preparing the existing HP SIM 5.x system for migration.

Migrating from one
system to another
–
Installing HP SIM 5.x on the target CMS and migrating the
database from the source CMS to the target CMS.

Post Migration
–
Replicating the HP SIM 5.x configuration from the source CMS to the target CMS.
Providing MSDE database access fo
r the remote system
To verify that TCP/IP protocol is enabled in SQL Server Network Utility:
1.
Go to
<MSDE Install folder>
\
Microsoft SQL Server
\
80
\
Tools
\
Binn
.
2.
Execute the SQL Server Network Utility EXE from this directory using the following command:
svrnet
cn
Verify that TCP/IP is listed in the
Enabled Protocols
list. If
Enabled Protocols
is not listed,
select
TCP/IP
from the
Disabled Protocols
list and click
Enable
. TCP/IP
is moved to the
Enabled Protocols
list, which enables it. Click
OK
to apply the chang
es.
3.
Go to
Control Panel

Administrative Tools

Services
and restart the service named
MSSQLSERVER
for this change to take effect.
Enabling mixed mode authentication in MSDE
Warning:
If the Registry Editor is used incorrectly, it can cause serious problems th
at require you to
reinstall the operating system.