Usage Note 57842: The workspace server disconnects when you are using SAS/ACCESS® to Microsoft SQL Server
When using SAS® Enterprise Guide® or other clients with SAS/ACCESS Interface to Microsoft SQL Server, you might get the following error:
An error occurred executing the workspace job "Program" The server is disconnected
The problem occurs when you are using a LIBNAME statement with the SQLSVR engine and your password is more than 12 characters. This problem occurs because of a limitation with the Data Direct driver that SAS/ACCESS Interface to Microsoft SQL Server uses.
To circumvent the problem, shorten the password to 12 characters or less.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | 64-bit Enabled AIX | 9.4 | | 9.4 TS1M0 | |
| 64-bit Enabled Solaris | 9.4 | | 9.4 TS1M0 | |
| HP-UX IPF | 9.4 | | 9.4 TS1M0 | |
| Linux for x64 | 9.4 | | 9.4 TS1M0 | |
| Solaris for x64 | 9.4 | | 9.4 TS1M0 | |
*
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.
When you are using the SQLSVR engine in BI clients, the workspace server can disconnect. The problem occurs when the password used to connect is more than 12 characters. To resolve the problem, shorten the password to 12 characters.
| Date Modified: | 2016-03-25 11:13:24 |
| Date Created: | 2016-03-11 12:43:54 |
