SQL connection error

deleted_user — Wed, 20 May 2009 06:27:54 GMT

Hi friends,
i am using SAS EG and submitting code on a remote SAS server.
I am trying to connect MS SQL Server through proc sql pass through query using my windows authentication.
here is my code.

connect to oledb as xyz (init_string="Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=True;
Initial Catalog=DB_TEST;
Data Source=SQLSERVER"
);

but some thing is wrong, i get this error.

Error trying to establish connection: Unable to Initialize: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

I checked on login into sql server , I am authenticated User.
I think the query is not able to send my username to sql server.

Please help..

thanks and regards
Avi

Re: SQL connection error

LinusH — Wed, 20 May 2009 08:57:40 GMT

This is a typically SAS Tech support issue.
Information missing in your post: your environment details, such as server(s), metadata setup etc.

/Linus

Re: SQL connection error

jklein271 — Wed, 23 Jun 2010 02:12:51 GMT

Avi:

Did you ever have any luck with this issue?

topic SQL connection error in SAS Enterprise Guide

SQL connection error

Re: SQL connection error

Re: SQL connection error