Desktop productivity for business analysts and programmers

SQL connection error

Not applicable
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
Super User
Posts: 5,916

Re: SQL connection error

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

Data never sleeps
Posts: 28

Re: SQL connection error


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