Table of Contents

Unable to establish connection error configuring server instance

First change security policy

http://www-01.ibm.com/support/docview.wss?uid=swg21417773

Windows 2008
1. Open Control Panel
2. Click on View Network status and tasks
3. On the left side, click Change Advanced sharing settings
4. Scroll down and under Password Protected sharing, select the radio button to Turn off password protected sharing
5. Click on Save Changing and close the Control Panel
6. Go to Start->Run and type in secpol.msc
7. Expand Local Policies and click on Security Options
8. Double-click on User Account Control: Run all administrators in Admin Approval Mode and select disable.
9. Reboot the box.

Note: in order to use a user other than administrator User Account Control must be disabled. If it is enabled, only the Administrator is the one allowed to perform administrator duties. This is true on Windows 2008 and Windows Vista.

Note: if Windows is part of a domain, the Password Protected Sharing option will not be available. In this case, follow steps 6-9.

Second disable the firewall

Be careful, you have to reboot your server, the firewall won't be off even if you stop the service.

ANR0298S Authority is insufficient to access the database

You are not able to start the Windows service for TSM server, or not able to start the GUI dsmicfgx.exe:

Problem

On a Windows system, a Tivoli Storage Manager server instance is installed with one user ID, but is started with a different user ID. When started with the different user ID, the ANR0298S message is logged.

The user ID that is being used to start the server instance does not have sufficient authority to the DB2 database.

Diagnosing the problem

Open a DB2 command window by selecting Start > All Programs > IBM DB2 > Command Line Tools > Command Window - Administrator

From the Command Window, run the following commands:

set db2instance=server1
db2 connect to TSMDB1
db2 "select grantee,securityadmauth from syscat.dbauth"

The output from the select command returns the user ID that is authorized to the database.

Resolving the problem

Log on with the user ID that created the Tivoli Storage Manager server instance. Open a DB2 command window by selecting Start > All Programs > IBM DB2 > Command Line Tools > Command Window - Administrator From the command window, enter the following commands:

set db2instance=server1
db2 connect to TSMDB1
db2 grant dbadm with dataaccess with accessctrl on database to user XXX
db2 grant secadm on database to user XXX

In the two grant commands, XXX is the user ID from which the Tivoli Storage Manager server is to be run (different from the user ID that was used to create the server instance). When special characters such as “.” and “\” are used in the user id, the user id must be quoted with the quotation marks escaped. For example, the following command :

db2 grant dbadm with dataaccess with accessctrl on database to user "my.user"
  fails with the following error :

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token “.” was found following “database to user svc”. Expected tokens may include: “,”. SQLSTATE=42601 The correct syntax for the command is:

db2 grant dbadm with dataaccess with accessctrl on database to user \"my.user\"