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 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.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to DB2	Microsoft Windows XP Professional	9.1 TS1M3
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.1 TS1M3
		Microsoft Windows XP 64-bit Edition	9.1 TS1M3
		Microsoft Windows Server 2003 Datacenter Edition	9.1 TS1M3
		Microsoft Windows Server 2003 Enterprise Edition	9.1 TS1M3
		Microsoft Windows Server 2003 Standard Edition	9.1 TS1M3
		Microsoft Windows 2000 Server	9.1 TS1M3
		Microsoft Windows 2000 Advanced Server	9.1 TS1M3
		Microsoft Windows 2000 Datacenter Server	9.1 TS1M3
		Microsoft Windows 2000 Professional	9.1 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Type:	Usage Note
Priority:
Topic:	SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> DB2

Date Modified:	2008-03-07 14:36:42
Date Created:	2007-06-05 09:50:49