Wednesday, March 21, 2012

RS2005 Access Error Using Report Manager Via DNS

PROBLEM:
Created a DNS entry (reportsdev) to access reporting services.
I can NOT ACCESS the report manager and receive an error
http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
I CAN ACCESS the report server with out a problem via IE and VS2005.
http://reportsdev/ReportServer$SQLServer2005
ERROR:
â'The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.â'
This is a reporting services error with the reporting services UI wrapped
around the error and the link to Home. Clicking the link to Home generates
the same error.
NOTES & Tentative Solution:
I CAN ACCESS the report manager by configuring the report site with a port
rather then host header.
http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
If I restart IIS and then access the report manager using the DNS an error
is logged in the Application Log â'Report Manager cannot connect to the
ReportServer service.â'
Configuration:
Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
install of 2005). RS2000 was on the machine until a restore but after the
restore was not reinstalled the RS2000 databases have been removed from
SQL2000 after the restore.
Any help is appreciated,
TedTed,
Did you update the entry in RSWebApplication.config to match your
report server DNS entry?
Andy Potter|||the same problem persists to me although i have modified the entry in
RSWebApplication.config
when I first installed the reporting services 2005, I wanted to use as
server the older one (sql + reporting 2000). I couldn't figure out what's the
problem and I thought that may be an incompatibility beteen sql 200 and
RS2005 and RS 2000 all toghther on the same server. After this I have
installed a new instance of SQL 2005 and the RS 2005...but I had the same
error (The attempt to connect to the report server failed. Check your
connection
information and that the report server is a compatible version)
...until I droped the ideea of using host header (right now I use a simple
asp page to redirect...but this is not the final solution that I want).
still, I want to use a host header...anyone figure it out how to?
"Potter" wrote:
> Ted,
> Did you update the entry in RSWebApplication.config to match your
> report server DNS entry?
> Andy Potter
>|||I am havin the same problem!
I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
are using Windows Server 2003 SP1. I get the following error:
Microsoft Report Designer
A connection could not be made to the report server
Check your connection information and that the report server is a compatible
version.
nickpup
"tbarton" wrote:
> PROBLEM:
> Created a DNS entry (reportsdev) to access reporting services.
> I can NOT ACCESS the report manager and receive an error
> http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> I CAN ACCESS the report server with out a problem via IE and VS2005.
> http://reportsdev/ReportServer$SQLServer2005
>
> ERROR:
> â'The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.â'
> This is a reporting services error with the reporting services UI wrapped
> around the error and the link to Home. Clicking the link to Home generates
> the same error.
>
> NOTES & Tentative Solution:
> I CAN ACCESS the report manager by configuring the report site with a port
> rather then host header.
> http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> If I restart IIS and then access the report manager using the DNS an error
> is logged in the Application Log â'Report Manager cannot connect to the
> ReportServer service.â'
>
> Configuration:
> Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> install of 2005). RS2000 was on the machine until a restore but after the
> restore was not reinstalled the RS2000 databases have been removed from
> SQL2000 after the restore.
> Any help is appreciated,
> Ted
>|||I finally managed to solve this problem
open SQl Books Online at this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
and check the explanations about ReportServerVirtualDirectory and
ReportServerUrl
"ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
you specify ReportServerUrl, you must delete the entry for
ReportServerVirtualDirectory"
"nickpup" wrote:
> I am havin the same problem!
> I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> are using Windows Server 2003 SP1. I get the following error:
> Microsoft Report Designer
> A connection could not be made to the report server
> Check your connection information and that the report server is a compatible
> version.
> nickpup
>
> "tbarton" wrote:
> > PROBLEM:
> > Created a DNS entry (reportsdev) to access reporting services.
> > I can NOT ACCESS the report manager and receive an error
> > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > http://reportsdev/ReportServer$SQLServer2005
> >
> >
> > ERROR:
> > â'The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.â'
> >
> > This is a reporting services error with the reporting services UI wrapped
> > around the error and the link to Home. Clicking the link to Home generates
> > the same error.
> >
> >
> > NOTES & Tentative Solution:
> > I CAN ACCESS the report manager by configuring the report site with a port
> > rather then host header.
> > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > If I restart IIS and then access the report manager using the DNS an error
> > is logged in the Application Log â'Report Manager cannot connect to the
> > ReportServer service.â'
> >
> >
> > Configuration:
> > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > install of 2005). RS2000 was on the machine until a restore but after the
> > restore was not reinstalled the RS2000 databases have been removed from
> > SQL2000 after the restore.
> >
> > Any help is appreciated,
> >
> > Ted
> >|||also check this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/1571c3fb-53a1-4bdd-bde6-0b8d490bf823.htm
"dragoon" wrote:
> I finally managed to solve this problem
> open SQl Books Online at this page:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
> and check the explanations about ReportServerVirtualDirectory and
> ReportServerUrl
> "ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
> you specify ReportServerUrl, you must delete the entry for
> ReportServerVirtualDirectory"
> "nickpup" wrote:
> > I am havin the same problem!
> >
> > I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> > are using Windows Server 2003 SP1. I get the following error:
> >
> > Microsoft Report Designer
> >
> > A connection could not be made to the report server
> >
> > Check your connection information and that the report server is a compatible
> > version.
> >
> > nickpup
> >
> >
> > "tbarton" wrote:
> >
> > > PROBLEM:
> > > Created a DNS entry (reportsdev) to access reporting services.
> > > I can NOT ACCESS the report manager and receive an error
> > > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > > http://reportsdev/ReportServer$SQLServer2005
> > >
> > >
> > > ERROR:
> > > â'The attempt to connect to the report server failed. Check your connection
> > > information and that the report server is a compatible version.â'
> > >
> > > This is a reporting services error with the reporting services UI wrapped
> > > around the error and the link to Home. Clicking the link to Home generates
> > > the same error.
> > >
> > >
> > > NOTES & Tentative Solution:
> > > I CAN ACCESS the report manager by configuring the report site with a port
> > > rather then host header.
> > > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > If I restart IIS and then access the report manager using the DNS an error
> > > is logged in the Application Log â'Report Manager cannot connect to the
> > > ReportServer service.â'
> > >
> > >
> > > Configuration:
> > > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > > install of 2005). RS2000 was on the machine until a restore but after the
> > > restore was not reinstalled the RS2000 databases have been removed from
> > > SQL2000 after the restore.
> > >
> > > Any help is appreciated,
> > >
> > > Ted
> > >

No comments:

Post a Comment