Extended Windows Security feature

SQL5005C system error pop-up window when logging into a Windows system due to the logon userid not having permission to run db2systray

Error SQL5005C on Windows Vista, Windows 7

 and Windows 2008

Technote (troubleshooting)

Problem(Abstract)

When I try to run any DB2 command in Windows Vista, Windows 7 and Windows 2008 I get the following error:

C:\Program Files\IBM\SQLLIB\BIN>db2 list db directory
SQL5005C System Error.

Resolving the problem

The cause of this error is because you may not have picked "Run as Administrator" when installing DB2.

If you right click on any icon you will have an option to "Run as Administrator":

You can either do this every time you want to open a DB2 Command Window or 

you can uninstall and reinstall DB2. Before installing DB2 right click on db2setup.exe

 and select "Run as Administrator", see screen shot above.Technote (troubleshooting)

Problem(Abstract)

SQL5005C system error pop-up window when logging into a Windows system due to the logon userid 

not having permission to run db2systray

Symptom

When logging into a Windows system with a userid that is not part of either the DB2ADMNS or

 DB2USERS Extended Windows Security groups, a pop-up that displays an error "SQL5005C system error" will be displayed on the screen if the db2systray is enabled.

Cause

The error is caused by db2systray.exe trying to launch, but the userid that is logging into the system 

does not have the appropriate permission to run db2systray.exe

Resolving the problem

To avoid this error message, please take one of the following steps:

• This error will not be displayed if the Extended Windows Security feature is not enabled
• . When installing DB2 for the first time, you may disable the Extended Windows Security 
• feature in the install wizard when installing DB2 and the error will not occur in this configuration.
• If Extended Windows Security is enabled, this error message will not be displayed if the
•  userid that is logging into the system belongs to the DB2USERS or DB2ADMNS group.
• If Extended Windows Security is enabled, but there are userids on the box that you
•  do not wish to add to either the DB2USERS or DB2ADMNS group, the error can be avoided by disabling the db2systray feature. To do this, log in as a local administrator and run "db2systray -clean" from a DB2 Command Window with administrative privileges.

Related information

Extended Windows Security