Solved

Can not connect to SQL Report Server interface

Posted on 2008-10-20
1
565 Views
Last Modified: 2012-05-05
I have an instance of SQL Report Server running on my main sql server. I deploy reports here for my company to use. To my knowledge, no changes have been made to this server in some time, however, as of today I am unable to get to the Report Server interface. I enter the same path into my webbrowser that I always do, but I can not get there. I just get a "cannot diplay webpage" error as though it was a bad address or something.  Has anybody run into this? I have checked and the site is running, IIS has been restarted as a "just in case" measure, and all services appear to be running. I just can't get to my report server over the internet. I am currently running IE7 for a browser, and all machines are running XP Pro SP2. The only exception is the server itself which is Server 2003. I am not even able to get to the Report Server interface from the actual server it's installed on either.
0
Comment
Question by:casper114
1 Comment
 

Accepted Solution

by:
casper114 earned 0 total points
ID: 22900453
I figured it out. The temp files were getting deleted when I would log off the server and then log back on to it. As a result, a temp directory that SQL Management Studio was looking for did not exist. I was able to manually recreate the folder and everything worked. We have since resolved the issue of the temp files being deleted.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

832 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