cancel
Showing results for 
Search instead for 
Did you mean: 

IDT MS SQL Server Trusted Connection - OLE DB

amrsalem1983
Active Contributor
0 Kudos

Hi All,

i have a scenario where i need to create an OLE DB connection to SQL Server Database 2008 R2

the connection using Windows Authentication, so it has to go with Trusted Connection.

i can create an ODBC easily, but not able to fix it using OLE DB. it gives an error that the user cannot login

i use the user name and password as below

user: domain\username

pass: the domain password

server: sql server db server,port

database: database name

any one faced this issue?

Accepted Solutions (1)

Accepted Solutions (1)

amrsalem1983
Active Contributor
0 Kudos

you need to configure SSO with AD

Answers (0)