Friday, March 9, 2012

Error connection to SSRS via SSMS; SQL Server 2005

I am trying to connect to SQL Server Reporting Services through the
SQL Server Management Studio, however I get an error; "Cannot connect
to <<Server>>". In addition there is an HTTP status 404 error.
I am running this in a VPC with Windows 2003 Standard and SQL Server
Enterprise.
Within the VPC, I can connect to the Report Manager and view my
reports, I can access the report through web services and Visual
Studio and the ReportServer database exists in the SQL Server; I just
cannot connect to SSRS via SSMS.
Any Thoughts?
PaulWhen you connect to Report Manager via MSIE, what is the server name within
the URL?
http://servername/reports
Are you using that same name when you try to connect to SSRS via SSMS? Did
you try localhost?
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Paul" <blackwell_paul@.hotmail.com> wrote in message
news:3fbe13c7-b839-45e7-8785-2657f2081c96@.e25g2000prg.googlegroups.com...
>I am trying to connect to SQL Server Reporting Services through the
> SQL Server Management Studio, however I get an error; "Cannot connect
> to <<Server>>". In addition there is an HTTP status 404 error.
> I am running this in a VPC with Windows 2003 Standard and SQL Server
> Enterprise.
> Within the VPC, I can connect to the Report Manager and view my
> reports, I can access the report through web services and Visual
> Studio and the ReportServer database exists in the SQL Server; I just
> cannot connect to SSRS via SSMS.
> Any Thoughts?
> Paul|||On Nov 19, 9:25 am, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> When you connect to Report Manager via MSIE, what is the server name within
> the URL?http://servername/reports
> Are you using that same name when you try to connect to SSRS via SSMS? Did
> you try localhost?
> --
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
> "Paul" <blackwell_p...@.hotmail.com> wrote in message
> news:3fbe13c7-b839-45e7-8785-2657f2081c96@.e25g2000prg.googlegroups.com...
>
> >I am trying to connect to SQL Server Reporting Services through the
> > SQL Server Management Studio, however I get an error; "Cannot connect
> > to <<Server>>". In addition there is an HTTP status 404 error.
> > I am running this in a VPC with Windows 2003 Standard and SQL Server
> > Enterprise.
> > Within the VPC, I can connect to the Report Manager and view my
> > reports, I can access the report through web services and Visual
> > Studio and the ReportServer database exists in the SQL Server; I just
> > cannot connect to SSRS via SSMS.
> > Any Thoughts?
> > Paul- Hide quoted text -
> - Show quoted text -
I am using http://labs:81/reports/... I am using W2K3 Standard and
have a second website (not localhost). It uses portal 81. The server
name is LABS. Even when I use LABS:81 in the Connect to Server dialog
box of the SSMS, I get the same error.|||Can you switch to port 80 (momentarily) and try again?
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Paul" <blackwell_paul@.hotmail.com> wrote in message
news:32c86d58-1ff2-4b7f-9b36-635bf7868a69@.d4g2000prg.googlegroups.com...
> On Nov 19, 9:25 am, "Alain Quesnel" <alainsanss...@.logiquel.com>
> wrote:
>> When you connect to Report Manager via MSIE, what is the server name
>> within
>> the URL?http://servername/reports
>> Are you using that same name when you try to connect to SSRS via SSMS?
>> Did
>> you try localhost?
>> --
>> Alain Quesnel
>> alainsanss...@.logiquel.com
>> www.logiquel.com
>> "Paul" <blackwell_p...@.hotmail.com> wrote in message
>> news:3fbe13c7-b839-45e7-8785-2657f2081c96@.e25g2000prg.googlegroups.com...
>>
>> >I am trying to connect to SQL Server Reporting Services through the
>> > SQL Server Management Studio, however I get an error; "Cannot connect
>> > to <<Server>>". In addition there is an HTTP status 404 error.
>> > I am running this in a VPC with Windows 2003 Standard and SQL Server
>> > Enterprise.
>> > Within the VPC, I can connect to the Report Manager and view my
>> > reports, I can access the report through web services and Visual
>> > Studio and the ReportServer database exists in the SQL Server; I just
>> > cannot connect to SSRS via SSMS.
>> > Any Thoughts?
>> > Paul- Hide quoted text -
>> - Show quoted text -
> I am using http://labs:81/reports/... I am using W2K3 Standard and
> have a second website (not localhost). It uses portal 81. The server
> name is LABS. Even when I use LABS:81 in the Connect to Server dialog
> box of the SSMS, I get the same error.
>|||On Nov 19, 1:44 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> Can you switch to port 80 (momentarily) and try again?
> --
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
> "Paul" <blackwell_p...@.hotmail.com> wrote in message
> news:32c86d58-1ff2-4b7f-9b36-635bf7868a69@.d4g2000prg.googlegroups.com...
>
> > On Nov 19, 9:25 am, "Alain Quesnel" <alainsanss...@.logiquel.com>
> > wrote:
> >> When you connect to Report Manager via MSIE, what is the server name
> >> within
> >> the URL?http://servername/reports
> >> Are you using that same name when you try to connect to SSRS via SSMS?
> >> Did
> >> you try localhost?
> >> --
> >> Alain Quesnel
> >> alainsanss...@.logiquel.com
> >>www.logiquel.com
> >> "Paul" <blackwell_p...@.hotmail.com> wrote in message
> >>news:3fbe13c7-b839-45e7-8785-2657f2081c96@.e25g2000prg.googlegroups.com...
> >> >I am trying to connect to SQL Server Reporting Services through the
> >> > SQL Server Management Studio, however I get an error; "Cannot connect
> >> > to <<Server>>". In addition there is an HTTP status 404 error.
> >> > I am running this in a VPC with Windows 2003 Standard and SQL Server
> >> > Enterprise.
> >> > Within the VPC, I can connect to the Report Manager and view my
> >> > reports, I can access the report through web services and Visual
> >> > Studio and the ReportServer database exists in the SQL Server; I just
> >> > cannot connect to SSRS via SSMS.
> >> > Any Thoughts?
> >> > Paul- Hide quoted text -
> >> - Show quoted text -
> > I am usinghttp://labs:81/reports/... I am using W2K3 Standard and
> > have a second website (not localhost). It uses portal 81. The server
> > name is LABS. Even when I use LABS:81 in the Connect to Server dialog
> > box of the SSMS, I get the same error.- Hide quoted text -
> - Show quoted text -
Problem solved!
The account that ReportServer was running under did not have the
appropriate access. In addition, the url in the config file was
incorrect; Alain, you nailed it or at least would have if I hand not
already discovered it, thanks for your expertise anyways.
Unfortunately both items I noticed early on, but "didn't think" they
were issues. I just wonder if this is the answer to many blogs that I
have seen regarding this, all resulting with no solution.

No comments:

Post a Comment