Overview

This article describes the error and its resolution, which occurs when attempting to upgrade the database schema for a Archiver SQL database using the Archiver Bulk Schema Upgrader. The following error message is displayed in the Archiver Bulk Schema Upgrader:
The credentials supplied are incorrect.

Environment

Archiver using Microsoft SQL server as a backend for the Archive Stores.

Root Cause

The error message mentioned above is displayed when the credentials supplied during the Archiver Bulk Schema Upgrade do not have the appropriate privileges to upgrade the database schema.

The credentials supplied need to be of a user who has the sysadmin server role on the Microsoft SQL Server hosting the GFI Archiver database(s).

Resolution

When the GFI Archiver Bulk Schema Upgrader shows the dialog to enter username and password, ensure to enter those of a SQL Server authentication type login which is a member of the sysadmin role within the Microsoft SQL server instance (normally SA).

To find login details of account(s) with sysadmin server roles in Microsoft SQL server:

1. Open the Microsoft SQL Server Management Studio.
2. Expand Security > Server Roles.
3. Right-click on the sysadmin server role and select Properties.
4. You can find the Role Members in the right pane.

To find the of login account in Microsoft SQL server:

1. Open the Microsoft SQL Server Management Studio.
2. Expand Security > Logins.
3. Right-click on the login in question and select Properties.
4. In the General tab a radio button indicates the type of the login. (It is either Windows authentication or SQL Server authentication)