SUPPORT / SAMPLES & SAS NOTES
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>
<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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||||