Traditional web-based reporting with SAS BI tools

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

Reply
Contributor RSB
Contributor
Posts: 72

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

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
SAS Super FREQ
Posts: 8,818

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

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
SAS Employee
Posts: 238

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

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
Contributor RSB
Contributor
Posts: 72

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

It worked Like a charm..Thank You Anjela!! Message was edited by: RSB
Ask a Question
Discussion stats
  • 3 replies
  • 753 views
  • 0 likes
  • 3 in conversation