Hi,
I have set-up a metadata object ODBC server that connects to a SQL Server in SAS Management Console with the following settings:
ODBC Data Source Information (Connection String):
"Driver=SQL Server;Server=MyServer\SRVR;Database=MYDB;"
Authentication Information:
Authentication Type: User/Password
Authentication Domain: mysa (SQL Server account only)
When I create a library in SMC and register tables, a prompt will appear to key in the login. I input the mysa account and password but fails. What account should I put in for this to work? Greatly appreciate any help.
Thanks in advance!
Ok, too many possibilities, so let's narrow it down:
Three step process:
libname MyTest ODBC dsn="My ODBC definition" user="domain\userid" password="mypassword";
%put &=SYSLIBRC; /* Should be 0 */
Hi,
what is the exact error message you are seeing, and, what user ID are you using to log on to SASMC?
Is it sasadm@saspw, or, your personal ID being admin?
Thanks
Anja
Thanks for all the responses. I've managed to solve it.
As per explanation by @Anand_V, when launching SMC cached credentials are not available yet, so when i go register tables, it asks for a two prompts, first is on the SASApp which is a domain account (Default Auth) that launces the workspace, followed by the prompt which asks for the username and password for the SQL Server (DB Auth).
I didn't notice that prompts initially so I was actually trying to key in the SQL server account when it as still asking for the domain account.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.