Error message trying to log into Report Manager

I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
Standard or whatever comes with SBS Premium.
I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
Reporting Services in this instance using the default config during the
installation.
When I try to connect to Reporting Services with SSMS on the local
machine using Windows Authentication logged in as Administrator I get
the following error:
Cannot connect to SERVER\MSGPSBM
Additional Information:
Unable to connect to the remote server (System)
No connection could be made because the target machine actively refused
it (System)
When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
Error Unable to connect to the remote server. message
I can log into the database engine just fine.
What am I doing wrong?
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/20/2007 10:45:44 AMHello,
When you use SQL Server Reporting Services Configuration Manager can you log
to SSRS service?
If so check which of the points are marked on red. All of them should be
green or blue (if no active).
This is the first step to recognize where is the problem.
I suppose it could be a problem with accounts (Windows Services Account or
IIS Application Pool Account)
Best Regards,
Radoslaw Lebkowski
Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal w
wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
>I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> Standard or whatever comes with SBS Premium.
> I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
> Reporting Services in this instance using the default config during the
> installation.
> When I try to connect to Reporting Services with SSMS on the local
> machine using Windows Authentication logged in as Administrator I get
> the following error:
> Cannot connect to SERVER\MSGPSBM
> Additional Information:
> Unable to connect to the remote server (System)
> No connection could be made because the target machine actively refused
> it (System)
> When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> Error Unable to connect to the remote server. message
> I can log into the database engine just fine.
> What am I doing wrong?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 12/20/2007 10:45:44 AM|||All are green except:
Encryption Keys - Blue
Initialization - gray
Email Settings - yellow
Execution Account - yellow
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 8:37:59 AM
Radoslaw Lebkowski wrote:
> Hello,
> When you use SQL Server Reporting Services Configuration Manager can
> you log to SSRS service?
> If so check which of the points are marked on red. All of them should
> be green or blue (if no active).
> This is the first step to recognize where is the problem.
> I suppose it could be a problem with accounts (Windows Services
> Account or IIS Application Pool Account)
> Best Regards,
> Radoslaw Lebkowski
>
>
> Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal
> w wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
> > I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> > Standard or whatever comes with SBS Premium.
> >
> > I installed SQL as a named instance (SERVER\MSGPSBM) and also
> > installed Reporting Services in this instance using the default
> > config during the installation.
> >
> > When I try to connect to Reporting Services with SSMS on the local
> > machine using Windows Authentication logged in as Administrator I
> > get the following error:
> >
> > Cannot connect to SERVER\MSGPSBM
> > Additional Information:
> > Unable to connect to the remote server (System)
> > No connection could be made because the target machine actively
> > refused it (System)
> >
> > When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> > Error Unable to connect to the remote server. message
> >
> > I can log into the database engine just fine.
> >
> > What am I doing wrong?
> > -- Japheth Nolt
> > Microsoft SBF Specialist
> > Landis Computer
> > www.landiscomputer.com
> > 12/20/2007 10:45:44 AM|||I'm still learning.
My Report Server had been configured to use SSL. I turned that off and
now it works.
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 9:17:34 AM
Japheth Nolt wrote:
> All are green except:
> Encryption Keys - Blue
> Initialization - gray
> Email Settings - yellow
> Execution Account - yellow