Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Register Tables is ok, load tables login failure!?

Reply
Highlighted
New Contributor
Posts: 4

Register Tables is ok, load tables login failure!?

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...

Super User
Posts: 3,918

Re: Register Tables is ok, load tables login failure!?

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.

Ask a Question
Discussion stats
  • 1 reply
  • 80 views
  • 0 likes
  • 2 in conversation