Chat now with support
Chat with Support

MessageStats 7.8.1 - Upgrade Guide

About SQL Security Permissions for Upgrading the Database

Generally, it is recommended that you upgrade MessageStats using the MessageStats service account. In most cases, if the account used to upgrade the MessageStats database is the database owner, you can upgrade the database without any issues.

However, for environments in which security is locked down in the SQL deployment, use the following information to determine which SQL security role assignments are required by the account used to upgrade the database:

Is the account the database owner?

Required SQL security role assignments

Yes

The account must be a member of MessageStats Admin local user group.

No

The account must be a member of MessageStats Admin local user group.

Upgrading a Complete (Single Server) MessageStats Installation

The simplest type of upgrade is for a complete installation where all the MessageStats components are installed on a single computer.

Before you start the upgrade process, ensure that you are logged onto the MessageStats server with the MessageStats service account.

4
Run the setup.exe installer.
5
Click Continue.
6
Click Next, accept the license agreement and click Next.
7
Select Complete.
9
Click Next.
10
Ensure that the Share the Application Log folder option is selected and click Next.
14
Click Install.
15
Click Next.
17
Click Start.
19
Click Next.

Upgrading a Distributed Installation with a Separate Database Server

When you upgrade a distributed MessageStats installation in which the components are installed on different computers, you must upgrade the components in the following order:

In the following sample procedures, the MessageStats database is installed on one server. The MessageStats reports and the MessageStats server (scheduler service, task processors, and console) are installed together on a second server.

In most installations, you use the MessageStats installer to perform the upgrades. The process consists of the following procedures:

However in some situations, you might have to manually upgrade the database but still use the installer to upgrade the reports and server (scheduler service). The process consists of the following procedures:

1a. Upgrading the MessageStats Database on aSeparate Server

First you must upgrade the MessageStats database by running the MessageStats installer. It is recommended that you log on with the MessageStats service account to perform the upgrade.

4
Click Install.
5
Click Continue.
6
Click Next, accept the license agreement and click Next.
7
Select Custom.
8
Click Next.
you are using SQL Express (MyServer/SQLEXPRESS)
10
Click Next.
12
Click Next.
13
Ensure that the Migrate Previous Build check box is selected and click Next.
16
Click Done and click Finish.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating