Solved

SSRS Reporting Service Error

Posted on 2011-09-08
8
354 Views
Last Modified: 2012-05-12
I wan to Transfer SSRS Reports from one server to another server.

Dev
Windows Server 2008, SQL Server 2008 R2

Prod
Windows Server 2008, SQL Server 2008 R2

In dev, when I connect to Service It will give me error "HTTP 500 Internal Server Error" however, same service working perfectly on production server.

Please help me to come from this its urgent.


Untitled.png
Untitled.png
0
Comment
Question by:Alpesh Patel
  • 5
  • 3
8 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36501910
Transferring the rdl's from one server to another is easily done, but there are several steps you need to take.  

This is a nice, step by step process:
http://ballyhoo4u.com/move-reporting-services-reports-from-one-sql-server-to-another/

Or you could take a look at the scripter:
http://www.sqldbatips.com/showarticle.asp?ID=62

Maybe a little overkill, but this is pretty much a gui to allow you to move reports from one server to another (drag and drop):
http://msftrsprodsamples.codeplex.com/wikipage?title=SS2005%21RSExplorer%20Sample%20Application&referringTitle=Home

0
 
LVL 21

Author Comment

by:Alpesh Patel
ID: 36502097
Hi dbaSQL,

Thanks for Prompt Reply.

I have the steps to move the Reports from one server to another. The problem is When I execute the SSRS web service as shown in Image goes fail and give me error HTTP 500.

Is it effect if I have changed the REportServer database name?

 
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36502278
Is //servername/reportserver available?
0
 
LVL 21

Author Comment

by:Alpesh Patel
ID: 36502476
Yes It is available only problem with 2005 service other than 2006 or 2010.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 17

Expert Comment

by:dbaSQL
ID: 36502582
Two things, go into Tools\Internet Options\Advanced and clear the Show Friendly HTTP error messages checkbox.
This should give you better output on the error, and help you to identify what is causing the problem.

Second, have you checked your SSRS logs?
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36502614
Also, here's a little more detail on the causes of the HTTP 500:
http://msdn.microsoft.com/en-us/library/ms159778.aspx
0
 
LVL 21

Author Closing Comment

by:Alpesh Patel
ID: 36502766
Silly mistake was there. Previous developer has changed the ServiceCode in asmx file.
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36502973
Good deal.  Glad you worked it out.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now