How to move an HP SIM SQL 2005 SP3 database from local to remote machine

2
Introduction
This
white paper
describes
how to move an HP
S
ystems Insight Manager
SQL Server 2005 SP3
database from a local
server
to a remote
server
.
Enablin
g Remote Connection to SQL Server 2005 SP3
Enabling
SQL Server and Windows Authentication mode
1.
Log
in to SQL Server using SQL Server Management Studio on local SQL Server with Windows
®
Authentication user.
The
Windows account authenticate
s
SQL Server.
Fig
ure 1
:
Connect
ing
to
s
erver
2.
In
Object Explorer
, right
-
click the instance name
,
and select
Properties
.