ODBC Login Fails Everytime with CR 2011

[Former Member]

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

[former_member11696]

Hello,

What is Database vendor code error 18? Search MS for help on the error and then fix the problem with the client or permissions etc.

Don

[Former Member]

I am not sure what Database vendor code error 18 is? It came up as one of the screen errors. I have not any luck on Google findig what it means. I do not think permissions are anissue as these reports worked under teh previous version. I have found that others are having similar issues with the program but no answers are posted.

[former_member11696]

Really... http://msdn.microsoft.com/en-us/library/aa937483(SQL.80).aspx

SECCreateCredentials() is Security, CR is simply passing the error from the Client to a pop up box showing your the message from the Client.

It's MS SQL Server so that's a starting place. When you search add ":msdn" ( without the double quotes and Google will only search MS's site.

Seems you have a critical error with the Client configuration...

Make sure the version of SQL Server Client is installed on your PC and supported, If you are using MS SQL 2008 you must use the Native 10 client driver, MS doesn't support the MDAC/WDAC version of the client.

Don

[Former Member]

So in a nut shell, because I have the SQL 2008 management studio installed on my workstation I need to use the SQL server native client 10 ODBC drivers to connect to my SQL 2005 Database. This seems to be the issue. Once I created the ODBC connector with this driver, the reports are opening and showing the correct data. Thank you for the help.