Skip to Content
0
Former Member
Oct 19, 2011 at 09:25 PM

ODBC Login Fails Everytime with CR 2011

1467 Views

I am running a brand new install of CR 2011 SP2 on a Windows 7 Pro workstation. I am able to open the very first report I try to open sucessfully. Each report after I have closed and reopened the program fails with 4 errors starting with the following:

Login Failed then

Database Connector Error: 'IM006:[ODBC Driver Manager] Drivers SQLSetConnectAttr failed [Database Vendor Code 18]' then

Database Connector Error: '01000:[Microsoft][ODBC SQL Server Driver][ConnectionOpen (SECCreateCredentials()). [Database Vendor Code 18]' then

Login failed. Details 08001:[Microsoft][ODBC SQL Server][TCP/IP Sockets]SSL Security error [Database Vendor Code 18] then

I get prompted for credentials for my ODBC connetcion. I am using the correct credentials and all ODBC test for this connection are sucessfull. The ODBC connection is a System DSN connecting to a SQL Server 2005. These reports have worked in the past under my previous PC install. Windows XP Pro.

Any and all help would be appreciated!

Thanks