SAS can take a long time to connect when using SQL Server availability groups with SAS/ACCESS Interface to Microsoft SQL Server. The problem occurs if the primary server is down and SAS has to connect with the next member of the availability group. SAS eventually connects, but it takes several minutes. 

To work around the problem, install the latest DataDirect ODBC drivers found on the Hot Fix Downloads page. 

• If you are running SAS^® 9.4M4 (TS1M4), install the 9.41 version.
• If you are running SAS^® 9.4M5 (TS1M5), install the 9.42 version.
• If you are running SAS^® 9.4M6 (TS1M6), install the 9.43 version.

 

 

 

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to Microsoft SQL Server	64-bit Enabled AIX	9.4 TS1M4
		64-bit Enabled Solaris	9.4 TS1M4
		HP-UX IPF	9.4 TS1M4
		Linux for x64	9.4 TS1M4
		Solaris for x64	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.

---

When you use SAS/ACCESS Interface to Microsoft SQL Server, it can take a long time to connect when using SQL Server Availability groups. The problem is fixed with the latest version of the SAS/ACCESS Interface to Microsoft SQL Server driver.

Type:	Problem Note
Priority:	medium

Date Modified:	2019-11-11 12:47:55
Date Created:	2019-08-23 10:20:53