How to move HP SIM SQL 2005 SP2 database (492087-002, January 2009)

2
Introduction
This document details how to move an HP SIM SQL
Server
2005
SP2
d
atabase from a local
machine
to a remote machine.
Enabling Remote Connection to SQL Server 2005 SP2
Allowi
ng
both SQL Server and Windows Authentication mode.
1.
Login to SQL Server using SQL Server Management Studio Express on local SQL Server with
Windows Authentication user. This will use Windows account to authenticate to SQL Server.
Figure 1
Connect to Serve
r
2.
In
Object Explorer
, right click on the instance name and select
Properties
.