Skip to Content
0
Jul 18, 2013 at 11:44 AM

IDT MS SQL Server Trusted Connection - OLE DB

54 Views

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?