Installation Note 61108: The "Could not open a connection to SQL Server..." error occurs during the compute tier post-configuration step in SAS® Anti-Money Laundering
When you install and configure SAS Anti-Money Laundering, you might receive the ant script error below:
Named Pipes Provider: Could not open a connection to SQL Server [2].
The error occurs when you run the ant hotfix -logfile hotfix.log script during the computer tier post-configuration step. The error occurs because the server name is not passed to the script, so it tries to connect to localhost instead.
To work around this problem, add the properties -S and ${dbms.host} to all of the SQLServer <exec> lines in the script and then rerun the script.
Here is an example:
<exec executable="${sqlcmd.exe}">
<arg value="-U" />
<arg value="${dbms.system.userid}" />
<arg value="-P" />
<arg value="${dbms.system.passwd}" />
<arg value="-i" />
<arg value="${sqlserver_users.dir}" />
<arg value="-S" />
<arg value="${dbms.host}" />
</exec>
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Anti-Money Laundering | Linux for x64 | 7.1 | | 9.4 TS1M4 | |
64-bit Enabled Solaris | 7.1 | | 9.4 TS1M4 | |
64-bit Enabled AIX | 7.1 | | 9.4 TS1M4 | |
Microsoft® Windows® for x64 | 7.1 | | 9.4 TS1M4 | |
*
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: | Installation Note |
Priority: | high |
Date Modified: | 2018-04-25 14:06:36 |
Date Created: | 2017-09-18 11:29:40 |