IBM Support

Startup of server fails after restoring database to a new machine

Technote (troubleshooting)


ANR0298S Authority is insufficient to access the database error and Server can fail to start after restoring the database to a new machine.


Perform a Tivoli Storage Manager database backup on one machine, install the same code level on new machine and restore the database. The server will fail to start.


The server instance name on the source server is different than the instance name on the target instance.

Resolving the problem

To fix this problem:

1) On the target server, create a new account for the instance name that was used on the source server.

2) Grant Admin, DB2USER, and DB2ADMN rights to this new account on the target machine.

Use the following commands to grant these rights to the new account on the target server.

C:\Program Files\Tivoli\TSM\db2\BIN>set db2instance=server1
C:\Program Files\Tivoli\TSM\db2\BIN>db2 connect to TSMDB1
C:\Program Files\Tivoli\TSM\db2\BIN>db2 "select grantee,securityadmauth from syscat.dbauth"
C:\Program Files\Tivoli\TSM\db2\BIN>db2 grant dbadm with dataaccess with accessctrl on database to user INSTANCENAME
C:\Program Files\Tivoli\TSM\db2\BIN>db2 grant secadm on database to user INSTANCENAME

The Tivoli Storage Manager server should now start.

For more information on resolving server startup issues, reference the following articles:

and, if the Tivoli Storage Manager server is started as domain user:

Related information

Resolving version 6 Startup problems
If version 6 server is started with Domain User

Product Alias/Synonym


Document information

More support for: Tivoli Storage Manager

Software version: All Versions

Operating system(s): Windows

Reference #: 1500760

Modified date: 10 March 2017

Translate this page: