SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Failed to connect to server

Frequent Learner
Posts: 1

Failed to connect to server

X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation


NOTE: SAS initialization used:

real time 5.30 seconds

cpu time 1.40 seconds



2 proc import out=analysis.ABDSDxCodes Datatable = DiagNames_T DBMS = accesscs replace;

3 database="N:\ABDData\ABD001T.accdb";

4 run;


ERROR: Failed to connect to the Server: .

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.31 seconds

cpu time 0.04 seconds



System Info:

Windows 7 64-bit

SAS 9.4 64-bit (TS Level 1M3, X64_7PRO, Win v6.1.7601))

Office 2010 32-bit (version 14.0.7177.5000)

installed SAS® Add-In 7.1 for Microsoft Office

Super User
Posts: 3,499

Re: Failed to connect to server

[ Edited ]

The error suggests there is a problem with the SAS PC File Server. As a first step you need to confirm if it is running or not.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation