Connecting to a remote data source.

Hi all,

I have deployed a report onto the Report Server on a remote machine.

When i call the report an error is displayed as follows:

An error has occurred during report processing.

An error has occurred during report processing.

Cannot create a connection to data source 'MydataSource'.

For more information about this error navigate to the report server on the local server

machine,

or enable remote errors. Yet when i refresh the browser the report will be displayed. Has anyone any idea why the report will not be displayed every time a request is made ? Any help would be much appreciated! Ivan

Are you using integrated security for your data source? Most likely the issue is double-hop.

http://blogs.msdn.com/jgalla/archive/2006/03/16/553314.aspx

Connecting SQL server 2000 from different domain.

Please help to connect SQL server 2000 on different domain.

Please correct if I m wrong.

System details as follows

Client

Domain : DomainA

System: System1

IP Address : 10.10.225.19

SQL server 2000 installed

SQL Server

Domain : DomainB

System: System2

IP Address : 10.108.22.19

SQl Server : System2\inst2 ( My database is under inst2 instance)

SQL login : TestUser1

Password : Users123

I have Opened firewall port to access 10.108.22.19 from 10.10.225.19

While connecting the SQL server “System2\inst2” from the client machine enterprise manager with the SQL authentication, I am getting error Login failed for user “TestUser1”

And I have noticed in the SQL server log the login attempt shows under System2 default instance ( no instance). Actually I want to connect system2\inst2.

Please let me know the steps to connect.

Thanks in advance.

For named instance, you also need to open UDP port 1434 for firewall on 10.108.22.19(the server). This is requried to find named instances. You said "default instance (no instance)", which errorlog were you checking?|||

Thanks for your reply,

I got solution and i am able to connect all my SQL servers from my domain.

It is a firewall issue , buy default they opened for 1433 it is goes to Default instance , but i need to connect a different SQL server instance.

then i opened firewall for that port it is connecting .

Thanks