Captain
Captain
319 views

DB Proxy

Dears,

Please note I am trying to configure Microsoft SQL Server inside PAM.

The below steps were done:

1, Created Database connector with default proxy 11521
2. Created rule inside cmdctrl for DBMSSQLAccess.

When trying to access in the SQL, I receive the attached error.

Any help is appreciated.
Best regards,
Georgio

 

 

0 Likes
4 Replies
Micro Focus Expert
Micro Focus Expert

It looks like the server syntax for the client there is invalid:
10.13.1.227,11521
When I think it should look like:
10.13.1.227:11521
Otherwise, it would be good to verify network & port connectivity from the client to the pam manager db connector using telnet.
0 Likes
Captain
Captain

Dear,

Thank you for your reply.

Please note I tested both syntaxes, and same results as attached.

As for telnet, I was able to telnet between the servers.

Best regards,
Georgio

Tags (1)
0 Likes
Micro Focus Expert
Micro Focus Expert

Ah gotchya, well it does look like the syntax for specifying a non-default port is using the "," (sorry for misdirecting you there).
I see with the latest screenshot you posted, you also updated the port from "11521" (default for Oracle) to "1433," so it'd be useful to try the comma syntax as well using that updated port "1433" :
10.13.1.227,1433
or maybe 10.13.1.227,11433

Please verify the db connector details configured in PAM to ensure the DB Proxy Port is correct (the default is usually 11433 in this case). Would you please also provide a screenshot if possible?

or if DB Proxy Port is indeed "1433," then just not specifying port would be good to try as well, since it is the default client port:
10.13.1.227
0 Likes
Captain
Captain

Dear,

I initially did the testing on port 11433 with the "," separator; then I tried the 11521.

as for the connector setup, please find it attached.

Best regards,

Georgio

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.