07-09-2017 04:57 AM
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):
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!
07-09-2017 11:26 PM
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 */
07-09-2017 11:41 PM
07-10-2017 08:38 AM - edited 07-10-2017 08:39 AM
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?
07-14-2017 10:55 AM
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.