Connecting to SQL Server

[Former Member]

I'm trying to connect to SQL Server using OLEDB (ADO).  I keep getting a ADO error. Server does not exist or access denied.  SQL State: 08001

(Attached is the error)

Any ideas? I had the admin check and thinks I need maybe a native connection. My access privs should be ok according to him.

I'm on Crystal Report 2008

[Former Member]

Hi Julian,

On MS SQL there is also an option to allow remote connections check that this is on.

Similar to the odbc test listed above I would confirm you can ping the server and you can create a text file on your desktop then change the extention from txt to udl and confirm you can connect to the server.

[DellSC]

OLE DB is the closest you'll get to a "native" connection to MS SQL Server in Crystal.  Which version of the SQL Server client do you have installed and what version of SQL Server are you trying to connect to?  I would NOT use the default SQL Server client that is installed on most machines - it is an older version and may not work unless you're on an earlier version of SQL Server.

Also, just for testing, I would try to create a 32-bit ODBC connection to the database (Crystal is 32-bit software and cannot use 64-bit connections...)  As a final step in creating this, you'll have the option to test the connection.  This will let you know whether you can actually connect to the database or if there are other issues.

-Dell