sql server reporting services: Why can't I connect to my data source? -- sql server reporting services

Why can't I connect to my data source?

Jeff Stroope
5/17/2007 9:32:01 AM

sql server reporting services:

Hi,

We have SSRS 2005 running on SQL Server 2000 SP4 Standard Edition. I have
SSRS 2005 running on SQL Server 2000 SP4 Personal Edition on my computer. I
have a copy of the database that is the data source for my reports on my
computer. I built a report and deployed it to the Report Manager. The
report uses a couple of stored procedures. I modified the report's data
source in Report Manager to point to the production database and it runs
fine. I then modified the data source in Report Manager to point back to my
computer on the network and the report errors out saying it can't make a
connection to the data source. SQL Server on my computer and on the
production server are using mixed authentication (Windows and SQL Server).
Both have the same server login and user with matching permissions. Does
anybody know what might be the problem here? Is it because I have Personal
Edition on my machine?

Thanks,

Jeff
--
Thanks,

RE: Why can't I connect to my data source?

aligaloo
7/13/2007 6:50:03 AM

I am having the same problem. Have you resolved this issue?

Thanks,
Ali

[quoted text, click to view]

RE: Why can't I connect to my data source?

Jeff Stroope
7/13/2007 8:32:08 AM

Yes, I have. It turns out that SSRS was not able to connect to SQL Server on
my computer because it was blocked by the Windows Firewall by default. I had
to add a port for SQL Server and then add that port to the Exceptions in
Windows Firewall as follows:

Go to Settings > Control Panel > Windows Firewall
Click "Add a Port"
Give the new port a name (I used "sql-port") and port number 1433 (which is
SQL Server's default port number) and click OK.
Then, make sure the check box for sql-port is checked and click OK.

That should do it.

--
Thanks,

Jeff

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.