topic Re: Error Connecting SAS EG to SQL server in Azure Server in SAS Programming

Error Connecting SAS EG to SQL server in Azure Server

sasuser1031 — Mon, 27 Jul 2020 17:54:31 GMT

I am getting error when I try yo connect to SSMS in server. I have successful ODBC connection. However, I get the following error. It looks like error is coming from two words in user. How to fix it?

libname mydblib odbc user=apple orange password=XXXXXXXXXXXX dsn=sqlserver;
______
22
ERROR: Libref MYDBLIB is not assigned.
ERROR: Error in the LIBNAME statement.
ERROR 22-7: Invalid option name orange.

Re: Error Connecting SAS EG to SQL server in Azure Server

LeonidBatkhan — Mon, 27 Jul 2020 19:58:39 GMT

Hi sasuser1031,

Try putting the user value in quotes: user="apple orange" .

Re: Error Connecting SAS EG to SQL server in Azure Server

sasuser1031 — Mon, 27 Jul 2020 20:16:30 GMT

Hi Leonid,

Thanks for the suggestion. I tried using quotes, but It gives this error now.

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver
specified
ERROR: Error in the LIBNAME statement.

Re: Error Connecting SAS EG to SQL server in Azure Server

SASKiwi — Mon, 27 Jul 2020 20:31:04 GMT

The error suggests that the DSN sqlserver is not defined on your SAS server. Is your SAS session running locally on your PC or on a remote SAS server? If you use a remote SAS server what OS is it using?

If you are running SAS locally on your PC then you can use the Windows ODBC Administrator to define the DSN with the appropriate SQL Server ODBC driver.

Re: Error Connecting SAS EG to SQL server in Azure Server

sasuser1031 — Mon, 27 Jul 2020 21:00:00 GMT

Hi SASKiwi,

This SAS EG is installed in my machine and connected to the server. I am not sure what OS it is using.

How do you fix if it is connected to server?

Re: Error Connecting SAS EG to SQL server in Azure Server

SASKiwi — Mon, 27 Jul 2020 21:15:56 GMT

You will need to work with your SAS administrator who will hopefully know what is required.