I am running Crystal Reports XI. I am trying to connect to a Microsoft SQL Server 2005 database via JDBC connection that is located in a named instance on another computer. I downloaded the Miscrosoft SQL Server JDBC Driver. I placed the sqljdbc.jar file in C:\Program Files\Common Files\Business Objects\3.0\java\lib\external. I added the following to the Classpath in CRConfig.xml :

C:\Program Files\Common Files\Business Objects\3.0\java\lib\external\sqljdbc.jar;

Then I tried to setup a new connection in Crystal Reports. I entered the following data:

Connection URL: jdbc:microsoft:sqlserver://LSFM90:1433
Database Classname: com.microsoft.jdbc.sqlserver.SQLServerDriver
User ID: xxxx
Password: xxxx

When I click Finish, I get the following error message:

Failed to open the connection. Details: JDBC driver not found.



What am I doing wrong?? Also, where do I enter the instance name of the SQL Server database??-- normally I connect to server LSFM90\SSLSFM90.


ANy help anyone has would be great

Thanks

Anyone have any help they can offer?? I really, really need to connect to a MSSQL 2005 db using Crystal Reports and it is not working.

Thanks