When connecting to DB2 from SAS on windows, you might get similar to the following error.

ERROR: CLI error trying to establish connection: [IBM][CLI Driver] SQL1092N "SASDEMO" does not have the authority to perform the requested command. ERROR: Error in the LIBNAME statement.

The error is coming from the DB2 client installed on the SAS server due to user 'SASDEMO' attempted to execute a command or operation without having the proper authority.

To resolve this permission problem, make sure users have read and execute access to all DB2 objects through the operating system which can be done as following:

Start Settings > Control Panel > Administrative Tools > Computer Management > System Tools > Local Users and Groups > Groups

Right Click on 'DB2USERS' group and select properties Select Add Enter user 'SASDEMO' and select Check Names Select Ok Select Apply.

Above problem will occur when running SAS as services such as SAS Connect or BI Client such as Eguide, DI Studio etc.