Desktop productivity for business analysts and programmers

SQL connection error

Reply
N/A
Posts: 0

SQL connection error

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
Esteemed Advisor
Posts: 5,202

Re: SQL connection error

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

/Linus
Data never sleeps
Contributor
Posts: 28

Re: SQL connection error

Avi:

Did you ever have any luck with this issue?
Ask a Question
Discussion stats
  • 2 replies
  • 310 views
  • 0 likes
  • 3 in conversation