topic Re: Register Tables is ok, load tables login failure!? in SAS Visual Analytics

Register Tables is ok, load tables login failure!?

Tommp — Tue, 13 Mar 2018 16:20:23 GMT

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

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

SASKiwi — Tue, 13 Mar 2018 20:28:47 GMT

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.

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

RSM1 — Thu, 19 Mar 2020 19:38:11 GMT

Was this problem ever solved? I am experiencing the same problem. Additionally, it seems to only be a problem on some tables from my SQL database, not all of them.

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

Madelyn_SAS — Thu, 19 Mar 2020 19:41:29 GMT

If you are seeing a "Load failed" in Visual Analytics Administrator, can you right-click and see an option for a Last Action Log?

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

SASKiwi — Fri, 20 Mar 2020 22:59:42 GMT

@RSM1 - I doubt you have the same problem. This problem is about login failure of a LIBNAME and that would affect all tables for your database, not some. Please describe your problem in more detail as suggested by @Madelyn_SAS .