How to Move a Systems Insight Manager SQL 2008 Database from Local to Remote

Introduction
This white paper describes how to move an HP Systems Insight Manager SQL Server 2008 R2
database from a local server to a remote server.
Enabling Remote Connection to SQL Server 2008 R2
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 authenticates SQL Server.
Figure 1: Connecting to the server