BookmarkSubscribeRSS Feed
RSB
Calcite | Level 5 RSB
Calcite | Level 5
I am trying to access a Information Map created on the SQL Server 2005 database tables from the SAS Web Report Studio 4.2 M1.

I am getting the below error message.

Error while submitting SAS code
1 options Locale=en_US;
2 options VALIDVARNAME=ANY;
3 LIBNAME ETLAUDIT ODBC DAATASRC=ETL_AUDIT_CTRL SCHEMA=dbo;
ERROR:CLI error trying to establish connection:{Microsoft][ODBC SQL Server Driver] Login failed for user ''. The user is not associated with a trusted SQL Server connection.
ERROR:Error in the LIBNAME statement.

Every time I have to use the manage credentials to enter the user name and the pwd and refresh the report to view the data for the sqldomain that I have created in the SMC.

I am not able to use the default authentication to access the database since the AD user name has spaces in it. If I assign default authentication to the library I get the message similar to this.

1 LIBNAME ETLAUDIT ODBC DATASRC=ETL_AUDIT_CTRL SCHEMA=dbo USER=Rajasaketh Behata
______
22
1 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
ERROR: Libname ETLAUDIT is not assigned.
ERROR: Error in the LIBNAME statement.
ERROR 22-7: Invalid option name BEHATA.

Please suggest of there is any alternate way to use the default authentication. Message was edited by: RSB
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
You might want to check with Tech Support to see whether either of these notes might be relevant to your issue with SQL Server 2005.
http://support.sas.com/kb/15/096.html
http://support.sas.com/kb/12/262.html

cynthia

To open a track with Tech Support, fill out the form at this link:
http://support.sas.com/ctx/supportform/createForm
AngelaHall
SAS Employee
It appears that user credentials are not available to pass into the Library SQL Definition.

An example of a shared acct accessing an ODBC Library is available here: http://support.sas.com/techsup/technote/ts714.pdf

Also - there is specific information on how identities are passed. Check out this reference:
http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/viewer.htm#/documentation/cdl...

~ Angela Hall
http://sas-bi.blogspot.com
RSB
Calcite | Level 5 RSB
Calcite | Level 5
It worked Like a charm..Thank You Anjela!! Message was edited by: RSB

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2613 views
  • 0 likes
  • 3 in conversation