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).
- SQL Server 2000 Backup and Restore
- Copying Databases with Backup and Restore
- How to Configure logins and permissions to match the old server (data contained in the old server – like server level user accounts).
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
Right-click the name of the PAS server & select Properties.
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: Microsoft, BI, Setup, SQLServer, ProClarity, FUTURESULTS