topic Re: login failed for user ''. the user is not associated with a trusted sql s.. in SAS Web Report Studio

login failed for user ''. the user is not associated with a trusted sql s..

RSB — Mon, 26 Jul 2010 09:41:20 GMT

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

Re: login failed for user ''. the user is not associated with a trusted sql s..

Cynthia_sas — Mon, 26 Jul 2010 14:13:21 GMT

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

Re: login failed for user ''. the user is not associated with a trusted sql s..

AngelaHall — Mon, 26 Jul 2010 15:27:55 GMT

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/en/bisecag/61133/HTML/default/a003263450.htm

~ Angela Hall
http://sas-bi.blogspot.com

Re: login failed for user ''. the user is not associated with a trusted sql s..

RSB — Tue, 27 Jul 2010 10:20:26 GMT

It worked Like a charm..Thank You Anjela!! Message was edited by: RSB