08-10-2015 04:55 PM
Anyone out there using stored processes to create tables/reports and surfacing them in SAS VA? I am having trouble surfacing it. I tried using both stored process server and sasapp server. I have a windows desktop and MS SQL server for database. I am not exactly sure how the SAS is setup (if it is on a different unix server or on a windows nt server).
ERROR: CLI error trying to establish connection: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MYCLIENT-INC\svc_sassrv'. : [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
ERROR: Error in the LIBNAME statement.