Could not deploy the reports on the report server

Question

Could not deploy the reports on the report server

Jay Pete

SSCommitted

Points: 1945
More actions
June 5, 2012 at 9:43 pm

#275200

Hi,
I need help to deploy the reports on report server.
I have the following below given error.
TITLE: Microsoft SQL Server Report Designer
------------------------------
Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.
------------------------------
System.Web.Services.Protocols.SoapException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.
at Microsoft.ReportingServices.WebServer.WebServiceHelper.EnsureModeFromCatalog()
at Microsoft.ReportingServices.WebServer.RsSoapBase.Init(String itemPath, Boolean checkAccessToSharePoint)
at Microsoft.ReportingServices.WebServer.ReportingService2010.Initialize(String itemPath, Boolean checkAccessToSharePoint)
at Microsoft.ReportingServices.WebServer.ReportingService2010.IsSSLRequired() (Microsoft.ReportingServices.Designer)
------------------------------
Thanks in advance,
Jay

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Rock from VbCity Hall of Fame Points: 3991 More actions · Answer 1

Jay Pete (6/5/2012)
Hi,
I need help to deploy the reports on report server.
I have the following below given error.
TITLE: Microsoft SQL Server Report Designer
------------------------------
Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.

Hi Jay,

Please take a look at this discussion about a similar issue as the one you are experiencing: http://www.sqlservercentral.com/Forums/Topic1302539-1632-1.aspx

Cheers,

Hope this helps,
Rock from VbCity

Jay Pete SSCommitted Points: 1945 More actions · Answer 2

Hi ,

Scratching my head 🙁

That article doesn't help me.

TITLE: Microsoft SQL Server Report Designer

------------------------------

Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.

------------------------------

ADDITIONAL INFORMATION:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.ReportingServices.Designer)

------------------------------

Then i have checked the reporting service configuration manager.

Service Account: Local System

URLs: http://Jay-HP/ReportServer

After then i give the same URLs in the internate explroer,but i couldn't connect to report server.

Please share your thoughts

Thanks,

Jay

Rock from VbCity Hall of Fame Points: 3991 More actions · Answer 3

Hi Jay,

I will take you step by step.

Step 1: Check Reporting Services Configuration

1. Click on Start -> All Programs -> navigate to your Microsoft Sql Server XXXX program group -> open it -> Configuration Tools -> Reporting Services Configuration Manager

2. Login to your local configuration server instance in your workstation (the screen should looks like the one below)

3. Verify the following parameters: Your workstation name as known by reporting services, and the Web Services virtual directory as shown below (write down those names)

Please post back when you complete the 3 sections of the Step number 1.

Hope this helps,
Rock from VbCity

Jay Pete SSCommitted Points: 1945 More actions · Answer 4

Rock from VbCity (6/7/2012)
Hi Jay,
I will take you step by step.
Step 1: Check Reporting Services Configuration
1. Click on Start -> All Programs -> navigate to your Microsoft Sql Server XXXX program group -> open it -> Configuration Tools -> Reporting Services Configuration Manager
2. Login to your local configuration server instance in your workstation (the screen should looks like the one below)
3. Verify the following parameters: Your workstation name as known by reporting services, and the Web Services virtual directory as shown below (write down those names)
Please post back when you complete the 3 sections of the Step number 1.

Hi Rock,

I follow your given screen shots then i go to the internet explorer.:

my web URLs is: http://JAY-HP/reports

then new screen appears and it needs user name and password however reporting service run on local system account.

Let me know, at what point i am doing wrong.

Thanks,

Jay

Rock from VbCity Hall of Fame Points: 3991 More actions · Answer 5

Hi Jay,

That's correct, Report Manager ask your credentials, you should be able to reach it after login, its screen looks like the one below:

If you can't get the Report Manager let us know (NOTE: you should be able to see the Properties and Site Settings; if you can't see them, we have to focus into Roles assignments.

Once you are able to see the Report Manager you can also login to the Report Server Services by entering http://JAY-HP/ReportServer, its screen is similar to the one below.

You have to enter the Report Server Services url at BIDS by right-clicking on the Solution name and selecting properties, the properties form looks like the one below:

You should make sure the Target URL is the one corresponding with the Report Server Services.

Let us know how it goes.

Hope this helps,
Rock from VbCity