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.

Error Connecting to SQL 2000 from 2005 SSMS

I can connect to all but one of my SQL 2000 SP 4 servers with SQL 2005 SP2 SSMS on my workstation. I get the following error for the one:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I can connect to this server with the SQL 2000 Enterprise Manager from the same workstation I'm running SQL 2005 SSMS. I've also verified that tcp and named pipes are set up on the 2000 server. Can also telnet to the box with the default port #.

I'd appreciate any help you could give..

Thanks,

Dan

check the sql server 2005 is enabled for remote connection. check for firewall

http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

Madhu