topic Re: how to create a libname odbc with windows authentication in SAS Enterprise Guide

how to create a libname odbc with windows authentication

deleted_user — Mon, 09 Nov 2009 21:37:34 GMT

I would like to create a libname to a SQL db with windows authentication, like this one:

libname lib_name odbc dsn=dsn_name user=xxxx password=xxxx schema="";

but instead of using user and password, I'd like to use my windows authentication.

The goal of my procedure is: using a procedure without using a user and password pre-defined.

any help?

Tks

Re: how to create a libname odbc with windows authentication

Doc_Duke — Tue, 10 Nov 2009 16:24:10 GMT

What you are talking about is called a "trust relationship" between the SQL database and the other OS uses. Microsoft SQL/Server supports it, I'm not sure about other products. That has to be set up by the SQL database administrators. Many DBAs consider it a security risk and are unwilling to support it, so "good luck."

Re: how to create a libname odbc with windows authentication

deleted_user — Tue, 10 Nov 2009 19:59:31 GMT

tks for the help, but I've fixed it.

I've created a DSN with "log in with windows NT authentication" and in my libname I've put something like this:

libname mylib odbc dsn='dsn_name' schema=dbo;

that means, I didnot need to put user and pass if the DSN has that configuration.

Tks anyway

Re: how to create a libname odbc with windows authentication

deleted_user — Thu, 19 Nov 2009 10:16:34 GMT

Hi, there is also a nice solution using OLEDB access:

LIBNAME name OLEDB INIT_STRING="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Data Source=***;Initial Catalog=***" PROMPT=NO PROVIDER=SQLOLEDB.1 DATASOURCE=*** SCHEMA=*** ;

No need for registering system dependnt DSN.