Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pmak
Starting Member
41 Posts |
Posted - 2006-05-08 : 00:26:43
|
I have deployed The Adventureworks Sample Reports to 2005 Reporting Services, and attempted to open the reports. Any report that I open, I receive the message:Unable to connect to the remote server. The attempted operation is not supported for the type of object referencedThis message occurs with any report, including other ones that I build. These reports work properly if I browse to http://localhost/reportserver/..... ; but not when under the http://localhost/reports/.... path.These reports also work properly within the BI Studio.I have completely removed IIS, & all SQL Server 2005 components, and re-installed. I am still receiving the same error:Unable to connect to the remote server. The attempted operation is not supported for the type of object referencedAny help would be appreciated. |
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2006-05-11 : 02:15:34
|
I am having the exact same problem. Mine is a single unit test environment.Paul Tealpaul@partytilyoupop.com |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-05-11 : 09:04:15
|
We are having a heck of a time trying to remove ssrs. Our inital config had sql 2000 with reporting services and we decided to upgrade to ssrs 2005. It really threw a monkey wrench into the whole thing. We still need to keep our 2000 databases but we are unsuccessful in removing reporting services totally. |
|
|
pmak
Starting Member
41 Posts |
Posted - 2006-05-11 : 13:32:38
|
Just disable the Windows Firwall ICF and it will all work. I still have not figured out how to configure the Windows firewall yet to allow the Sql 2005 server remote connection. But one thing for sure it is the Windows firewall prevent the remote connection to the Sql 2005 server. Also make sure in IIS default web, not to assign any IP to it, just select "any unassigned" option. Hope this helppmak |
|
|
llong
Starting Member
1 Post |
Posted - 2006-05-11 : 15:57:05
|
I am having the same problem connecting to a remote sql server. If anyone figures out the solution, please post it. |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-05-11 : 16:09:41
|
Don't know if this applies or not but I'll be posting this to the msdn forums also. I'll repeat our problem. We are running 3 websites on our box with host headers. When installing we did the default install and planned on using the config tool to change settings. So we moved the virtual dirs to another web site on the same box and thats when everything stopped working.Solution can be found here [url]http://support.microsoft.com/?kbid=896861[/url]. We also needed to go into each config file (RSWebApplication.config and rsreportserver.config) and change the url to point to the new location. The config tool did not do this. - rsreportserver.config - <UrlRoot>http://xx.xx/reportserver</UrlRoot>
- RSWebApplication.config - <ReportServerUrl>http://xx.xx/reportserver</ReportServerUrl>
|
|
|
MattO
Starting Member
1 Post |
Posted - 2007-02-20 : 14:21:07
|
SQL Server 2005 does not take remote connections out of the box. You will need to go into the SQL Server Surface Area Configuration tool (http://msdn2.microsoft.com/en-us/library/ms173748.aspx) and allow remote connections. Once you turn this on you will need to restart the sql server service and your reports should work. |
|
|
wavesailor
Starting Member
2 Posts |
Posted - 2007-03-01 : 15:08:14
|
Also check the following tags in the RSWebApplication.config:<ReportServerVirtualDirectory></ReportServerVirtualDirectory> Took me a couple hours to figure this out :-) |
|
|
|
|
|