SQL connection error

[deleted_user]

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

[LinusH]

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

/Linus

[jklein271]

Avi:

Did you ever have any luck with this issue?