connection via ip address

[tjw2006]

Hi, I've need to connect to a remote SQL Server instance that is not currently on our network. I've managed to get all the relevant ports open (1433) and can ping and telnet to the server. Is there any way to connect to this SQL Server instance via ip address in Crystal Reports?

Thanks.

CR XI R2
SQL Server 2008 (SQL Express version)

 

[jmd0252]

it is my understanding, that you use the connections you have defined via odbc. So,, can you define and connect via odbc?

 

[tjw2006]

Hi, the report is running fine from the designer with an ODBC connection successfully, but when I upload it to Infoview, it's giving me an error. I've set up a identical ODBC connection on the machine that the Crystal Enterprise Server is on and when I test the connection, it comes back with connection successful - would you know why this is not working in Infoview?

Thanks

CR XI R2
Windows XP SP3
SQL Server 2008 SQLExpress

 

[jmd0252]

What is the error???

 

[tjw2006]

Just coming back with "failed to open the connection" and it's an error from the reportjobserver.