Issues trying to connect to DB2 via PHP
| From: | McCallister, Jason | Date: | Tue, 08 Jan 2008 19:54:54 +0000 |
| Subject: | Issues trying to connect to DB2 via PHP | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-28694@lists.php.net to get a copy of this message | ||
I found the solution.
This is from a DB2 UDB security document:
"Beginning in DB2 UDB Version 8.2, additional security was added to DB2
UDB in the Windows environment. A new option exists as part of the DB2
UDB installation to create two additional groups in the operating
system, DB2USERS and DB2ADMNS. Once these groups are created, only user
accounts that are members of these groups will have access to the DB2
UDB files on the system (including commands as well as user data files
created by DB2 UDB)."
The fix:
On your Windows server, go to >Control Panel >Administrative Tools
>Computer Management
On the tree view, go to >Computer Management (Local) >System Tools
>Local Users and Groups >Groups
Right-click on DB2USERS and select Properties
Add the users that will be accessing the DB2 Drivers. This will most
likely be the ID that is running the IIS server.
Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not
responsible for errors or omissions in this e-mail message. Any personal comments made in this
e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc. The information
contained in this document may be confidential and intended solely for the use of the individual or
entity to whom it is addressed. This document may contain material that is privileged or protected
from disclosure under applicable law. If you are not the intended recipient or the individual
responsible for delivering to the intended recipient, please (1) be advised that any use,
dissemination, forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2) notify sender
immediately by telephone and destroy the document. THANK YOU.