SQL Server Connectivity

[Former Member]

I am in the process of upgrading to a Windows 7 Pro machine. I have installed a trial version of CR8. I am having difficulty connecting to an SQL database running Windows Server 2008 Standard. I am receiving the follwoing error.

******

Failed to open the connection.

Details: ADO Error Code: 0x

Source: Microsoft OLE DB Provider for SQL server

Description: [DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied.

SQL State: 08001

Native Error: [Database Vendor Code:17]

******

I have turned off UAC and the windows firewall on the Win 7 machine to no avail. There is no fire wall running on the server.

Any help would be appreciated, Thanks.

[former_member11696]

Hello,

This doesn't make sense: "I am having difficulty connecting to an SQL database running Windows Server 2008 Standard"

SQL doesn't run an OS. I assume you mean you have SQL Server running on Windows Server 2008?

What version of SQL Server are you using?

Try installing the Client Tools ( and if you are using MS SQL Server 2008 you must install the Client on Windows 7 and use the SQL Server 10 drivers ), and see if you can connect.

Also, Windows 7 is not supported until CR 2008 Service Pack 2, CR Designer will show you version 12.2.x.x. YOu can get the Service Packs from by clicking on Businessobjects tab above and then downloads...

Also, be aware that Date/time fields generate wrong SQL in CR when using OLE DB drvier, ODBC works, you need Fix Pack 2.3 to resolve I believe.

Thank you

Don