Can''t connect to SQL Reporting Services through IIS and SQL Server Management Studio

Hi,

I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does. IIS is up and running.

I'm running SQL 2005 Enterprise 64bit with Service Pack 2.

===================================

Cannot connect to ctbbcysql02.

===================================

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Any help will be greatly appreciated.

Regards,

Ruaan

RuaanD79 wrote:

I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. The http://localhost/reportserver also is down.

That would be why you can't connect to it. What indicates to you that the report server is down? Is it really down or you just can't connect to it?

What, if anything, is not checked on the Reporting Services Configuration Tool?

Can''t connect to SQL Express or SQL 2005 from C# web app and IIS

Hi all,

I'm new to this forum and haven't worked with SQL Server for a couple of years. Now it seems I'm getting back into it. I have SQL Express and SQL 2005 installed on an XP sp2 machine with IIS 5.1. I have a C#/ASP.NET web app in Visual Studio 2005 that keeps getting an error on attempting to connect (SqlConnection object). It's a generic error saying a probable cause is SQL Express default setup not allowing remote connections. Remote connections are turned on for both TCP and UDP. I can connect from within a small C# windows application using the same uid and pwd, so I suspect it's something related to IIS talking to SQLExpress. I would appreciate any help on other things to check. I am also fairly new to using IIS in the development environment.

Thanks

It could be because you didn't specify the instance name when you tried to connect from the C# app? It could also be that SQLBrowser isn't running.

Hope that helps,

John

|||

This is because SQL Server 2005 Express Edition does not accepts remote connections by default:

How to: Enable Network Access During Installation of SQL Server 2005 Express Edition

|||

Thanks John,

Yes, I specified the instance name and verified SQLBrowser is running. COnnection string = "Server=BUTTERFLY\SQLExpress; Initial Catalog=catalog; uid=username; pwd=password;

|||

Ronald,

Thanks for pointing me to this information. It didn't actually solve my dilemma, but it did get the juices flowing. This is related to a project I inherited and upgraded from .NET 1.1 to 2.0. The sql connection string referenced a property for "server=", changing this to "data source=" allowed the connection to open properly. I am reading the links you pointed and they are very helpful. Thanks

Can''t connect to SQL Express or SQL 2005 from C# web app and IIS

Hi all,

I'm new to this forum and haven't worked with SQL Server for a couple of years. Now it seems I'm getting back into it. I have SQL Express and SQL 2005 installed on an XP sp2 machine with IIS 5.1. I have a C#/ASP.NET web app in Visual Studio 2005 that keeps getting an error on attempting to connect (SqlConnection object). It's a generic error saying a probable cause is SQL Express default setup not allowing remote connections. Remote connections are turned on for both TCP and UDP. I can connect from within a small C# windows application using the same uid and pwd, so I suspect it's something related to IIS talking to SQLExpress. I would appreciate any help on other things to check. I am also fairly new to using IIS in the development environment.

Thanks

It could be because you didn't specify the instance name when you tried to connect from the C# app? It could also be that SQLBrowser isn't running.

Hope that helps,

John

|||

This is because SQL Server 2005 Express Edition does not accepts remote connections by default:

How to: Enable Network Access During Installation of SQL Server 2005 Express Edition

|||

Thanks John,

Yes, I specified the instance name and verified SQLBrowser is running. COnnection string = "Server=BUTTERFLY\SQLExpress; Initial Catalog=catalog; uid=username; pwd=password;

|||

Ronald,

Thanks for pointing me to this information. It didn't actually solve my dilemma, but it did get the juices flowing. This is related to a project I inherited and upgraded from .NET 1.1 to 2.0. The sql connection string referenced a property for "server=", changing this to "data source=" allowed the connection to open properly. I am reading the links you pointed and they are very helpful. Thanks

Can''t connect to SQL Express or SQL 2005 from C# web app and IIS

Hi all,

I'm new to this forum and haven't worked with SQL Server for a couple of years. Now it seems I'm getting back into it. I have SQL Express and SQL 2005 installed on an XP sp2 machine with IIS 5.1. I have a C#/ASP.NET web app in Visual Studio 2005 that keeps getting an error on attempting to connect (SqlConnection object). It's a generic error saying a probable cause is SQL Express default setup not allowing remote connections. Remote connections are turned on for both TCP and UDP. I can connect from within a small C# windows application using the same uid and pwd, so I suspect it's something related to IIS talking to SQLExpress. I would appreciate any help on other things to check. I am also fairly new to using IIS in the development environment.

Thanks

It could be because you didn't specify the instance name when you tried to connect from the C# app? It could also be that SQLBrowser isn't running.

Hope that helps,

John

|||

This is because SQL Server 2005 Express Edition does not accepts remote connections by default:

How to: Enable Network Access During Installation of SQL Server 2005 Express Edition

|||

Thanks John,

Yes, I specified the instance name and verified SQLBrowser is running. COnnection string = "Server=BUTTERFLY\SQLExpress; Initial Catalog=catalog; uid=username; pwd=password;

|||

Ronald,

Thanks for pointing me to this information. It didn't actually solve my dilemma, but it did get the juices flowing. This is related to a project I inherited and upgraded from .NET 1.1 to 2.0. The sql connection string referenced a property for "server=", changing this to "data source=" allowed the connection to open properly. I am reading the links you pointed and they are very helpful. Thanks

Can''t connect to SQL Express or SQL 2005 from C# web app and IIS

Hi all,

I'm new to this forum and haven't worked with SQL Server for a couple of years. Now it seems I'm getting back into it. I have SQL Express and SQL 2005 installed on an XP sp2 machine with IIS 5.1. I have a C#/ASP.NET web app in Visual Studio 2005 that keeps getting an error on attempting to connect (SqlConnection object). It's a generic error saying a probable cause is SQL Express default setup not allowing remote connections. Remote connections are turned on for both TCP and UDP. I can connect from within a small C# windows application using the same uid and pwd, so I suspect it's something related to IIS talking to SQLExpress. I would appreciate any help on other things to check. I am also fairly new to using IIS in the development environment.

Thanks

It could be because you didn't specify the instance name when you tried to connect from the C# app? It could also be that SQLBrowser isn't running.

Hope that helps,

John

|||

This is because SQL Server 2005 Express Edition does not accepts remote connections by default:

How to: Enable Network Access During Installation of SQL Server 2005 Express Edition

|||

Thanks John,

Yes, I specified the instance name and verified SQLBrowser is running. COnnection string = "Server=BUTTERFLY\SQLExpress; Initial Catalog=catalog; uid=username; pwd=password;

|||

Ronald,

Thanks for pointing me to this information. It didn't actually solve my dilemma, but it did get the juices flowing. This is related to a project I inherited and upgraded from .NET 1.1 to 2.0. The sql connection string referenced a property for "server=", changing this to "data source=" allowed the connection to open properly. I am reading the links you pointed and they are very helpful. Thanks

Cant connect to server !

My project work ok with Asp.net development server, but when i use IIS :

I'm sure i can connect to SQL server by SQL Server Enterprise Manager and my project debug with Asp.net development server ok.

Anyone please help me.

This article should help:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

and if that doesn't then take a look here:

http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

Can't connect Report server at management studio and report manager at Explorer

I am using 2003 Server standard Edition (5.2.3790), SQL SERVER 2005 (9.00.1399) and IIS 6.0

When I tried to open the report manger at Explorer as typed http://servername/reports, http://localhost/reports, http://127.0.0.1/reports

I got an error : HTTP 404 : file not found

At testing connection on SQL server management studio, got an error -> the request failed with HTTP 404 status (Microsoft.sqlserver.management.UI.RSClient)

My configuration details as belows;

1. IIS 6.0 configuration

I made reports and reportserver virtual directory on Default web sites.

<<Default web site>>

Web site > Port 80, IP address : all unassigned

Directory security > checked Enable anonymous access

<< Report manager>>

Virtual directory >C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

ASP.net -> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config

(enable default content pages : home.aspx)

Directory Security > checked at Integrated Windows Authentication

<<Report server>>

Virtual directory > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

ASP.net -> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config

(enable default content pages : default.aspx, default.htm.default.asp, index.htm,iisstart.htm)

Directory Security > checked at Integrated Windows Authentication

2. Report server configuration

<<RSWebApplication.config>> file

<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>Reportserver</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

<<rsreportserver.config>> file

<Service>
<UrlRoot>http://<servername>/reportserver</UrlRoot>
<UserName></UserName>
<Password></Password>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
</Service>

3. SQL Server Management studio configuration

Authentication : Window Authentication

Please help me out. Should I reinstalled reporting service into SQL SERVER 2005?

thanks,

Eunsu

The URL you want to connect to is http://servername/reportserver.

|||Sure, I also tried to connect reportserver by url http://servername/reportserver, but got the same error.|||

Have you tried running the configuration tool? It should walk you through making sure that the server is properly configured.

Start->Microsoft SQL Server 2005->Configuration Tools->Reporting Services Configuration

|||

In advance, thanks for your concern

I've already done by reporting service configuration tool and checked every condition that was OK. But the result was same error messages.

Do I reinstall reporting service ?