ProClarity Analytics Server Migration to a New Database Server


What would you do if you needed to change your ProClarity Analytics Server database instance name?  Let’s take a step back and start with some background.  Microsoft BI product installations have a separate data tier option.  In other words, the database is on a different machine than the actual product (like ProClarity).  Occasionally, you may have a need to change your database server or move your data to a new database instance on the same machine.  Perhaps you have a leased server and the lease expired.  Maybe you have outgrown your current hardware and need a larger SQL Server machine.  In all of these cases, you are going to have to backup and restore the database, ensure that you have the correct logins and permissions, and change any application configurations to use the new database instance.  Let’s look into these items and see how to make the changes for ProClarity Analytics Server.

Preparing the Database Machine

There is only one database for ProClarity Analytics Server.

I posted previously about Database Migrations – Configure Logins and Permissions.  This post gives you information about:

Backup and Restoration of the SQL Database (Data contained in each database).

After you complete the work above, your new database machine is ready and the data and access to the configuration data is ready.

Configuring ProClarity Analytics Server

Open the ProClarity Analytics Server Administration Tool

clip_image001[1]

Right-click the name of the PAS server & select Properties.

clip_image002[1]

In the “SQL server” box enter the name of the new SQL Server.  For example, change the SQL server name from “BI-VPC” to “NewDB“.  Better yet, create a SQL Alias so you will have an easier way to make this change in the future.  ProClarity Analytics Server will restart after selecting OK.

While not always required, I have found it beneficial to Reboot the ProClarity Analytics Server.  I suggest doing this as part of your process.

Navigate to the ProClarity Analytics Server web site to insure that the applications still renders all of your Briefing Books. FUTURESULTS, LLC Blog and FUTURESULTS, LLC Web Site are both created by Robert Lambrecht.

del.icio.us Tags: , , , , ,
Advertisements
This entry was posted in Microsoft BI, ProClarity, Setup, SQL Server and tagged , , , , , , . Bookmark the permalink.

One Response to ProClarity Analytics Server Migration to a New Database Server

  1. Pingback: 2010 in review | FUTURESULTS, LLC Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s