Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: Unable to connect to SQL server - Crystal Report Integration


    I am using SQL server 2000, Crystal Reports 8.5. I dont see any problem with accessing thro' VB Coding(ADODB).

    Crystal Report connection thro ODBC also working fine.

    But when i try to connect to database thro "More data sources" -> SQL server , i was thrown out with an error "Unable to connect to SQL server servernam"

    I have uninstalled & Reinstalled both SQL server and Crystal Report. Still not working.

    I have been struggling with this problem for quite a long time.

    Can any one give me the solution for this ??



  2. #2
    Join Date
    Mar 2009
    I know that this is very old but I had this issue and was Googleing around and found it. so for anyone else with this issue.

    I had to the exact same issue and the solution is to install the SQL 2000 Client Tools. Only place I found them was on the SQL 2000 server install CD, select server install then custom then you can just choose the tools and not the entire server install.
    I just selected the SQL Client Connectivity piece but that resolved my issue.
    I had tried SQL 2005 and SQL 2008 but they did not work. FYI SQL 2008 server is installed on the machine that crystal 8.5 is on and it did not work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts