03-13-2018 12:20 PM
So I have a test table coming from a MS SQL machine. I can register it in Libraries in the SAS management console but when I try and load the table from the VA web page I get a "load failed"
ERROR: CLI error trying to establish connection: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLBox\useracct'. ERROR: Error in the LIBNAME statement. ERROR: Libref EXAMDATA is not assigned.
Have I missed something obvious?
I'm running VA 9.4...
03-13-2018 04:28 PM
Was SMC connecting to your SAS VA App server when you assigned and registered the SQL Server data source? If so then I suggest you test the data source in SAS Studio or EG connected to VA to see if it works there.