OLEDB SQL Server Authentication Error ?

Tue, 17 Jun 2014 13:40:07 GMT

Hi All

I'm trying to connect using OLEDB to a SQL Server using SQL Server Native Client 10.0 using SQL Server Authentication. I enter all the details in the Connection dialog, I can even test the connection and receive the message "Connection Succeeded", however, when I click OK to insert the connection string I receive an error:

"ErrorSource: Microsoft SQL Server Native Client 10.0, ErrorMsg: Login failed for user 'my domain\ local user'

What I don't understand is why is it trying to connect using my local credentials when I specified a SQL Server Authentication user in the set up - is this a bug? Am I missing something?

Appreciate the advice.

Thanks

Dominic

Re: OLEDB SQL Server Authentication Error ?

maxgro — Tue, 17 Jun 2014 19:14:54 GMT

me too I have the same problem: SQL Server Native Client 10.0 didn't work

First I tried with Microsoft OLE DB Provider for Sql Server and it worked

(1)

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=........................

Then I did another change: in the connection (1)

I replaced the Provider from SQLOLEDB.1 (Microsoft OLE DB Provider for Sql Server) to SQLNCLI10 (SQL Server Native Client 10.0) and it worked.

topic Re: OLEDB SQL Server Authentication Error ? in QlikView

OLEDB SQL Server Authentication Error ?

Re: OLEDB SQL Server Authentication Error ?