Desktop productivity for business analysts and programmers

how to create a libname odbc with windows authentication

Reply
N/A
Posts: 0

how to create a libname odbc with windows authentication

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
Trusted Advisor
Posts: 2,114

Re: how to create a libname odbc with windows authentication

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."
N/A
Posts: 0

Re: how to create a libname odbc with windows authentication

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
N/A
Posts: 0

Re: how to create a libname odbc with windows authentication

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.
Ask a Question
Discussion stats
  • 3 replies
  • 1386 views
  • 0 likes
  • 2 in conversation