how to create a libname odbc with windows authentication

[deleted_user]

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

[Doc_Duke]

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."

[deleted_user]

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

[deleted_user]

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.