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
pass: the domain password
server: sql server db server,port
database: database name
any one faced this issue?