how to create microsoft server library .

[MG18]

What are neccessary step to create a SAS library for microsoft server ?

I have created one but it is giving following error :-

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

What does it mean or what are the possible reason for above error?

Many thanks in advance 

[LinusH]

There are many examples in the documentation/papers on how to do this.

What have you tried? The error alone is not enough to understand your situation.

[MG18]

i have created first data connection through SAS SMC and then created new library using SAS SMC .

Is this working or not ? 

Can you suggest how should i proceed ?

[LinusH]

First step: make it work from outside SAS first (but from the same host), i.e. using Excel.

[SASKiwi]

I find it easiest to get a LIBNAME statement working successfully first and then use that as my basis to create an SMC data library. Please post the LIBNAME statement that is giving you the error.

[MG18]

I have tried to run  below libname :-

LIBNAME SAS_MS SQLSVR datasrc="172.31.15.3:1433/JXX_XXX_EXT" SCHEMA=DBO user='misXXX' password='XXXXX';

and i have added entry for sqlsvr in odbc.ini and then tried below libname:-

LIBNAME SAS_MS SQLSVR  Datasrc=MSDATA_PROD  SCHEMA=DBO  AUTHDOMAIN="AUTH_MSSQL" ;

Am i doing right or not ?

[MG18 · Accepted solution]

I have followed below link and able to create library.

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/64205/PDF/default/config.pdf