December 1, 2008 at 5:00 am
When i try to access the "Windows Integrated Security" tab under reporting services on SAC i get this error:
The underlying connection was closed: An unexpected error occurred on a received. (SQLSAC)
Additional information:
--> Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
--> An existing connection was forcibly closed by the remote host (system)
I cannot access locahost/reportserver either, i keep getting a logon prompt and no matter what i enter it doesn't work. Checked all reporting services configurations and all green ticks. mimic'd another server which does work fine.
any ideas?
Running: SQL 2005 SP2
Windows 2003 SP2
NB: not sure if this should be in administration or not.....admin, feel free to move if necessary!
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
December 2, 2008 at 4:56 am
Swirl80 (12/1/2008)
When i try to access the "Windows Integrated Security" tab under reporting services on SAC i get this error:The underlying connection was closed: An unexpected error occurred on a received. (SQLSAC)
Additional information:
--> Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
--> An existing connection was forcibly closed by the remote host (system)
I cannot access locahost/reportserver either, i keep getting a logon prompt and no matter what i enter it doesn't work. Checked all reporting services configurations and all green ticks. mimic'd another server which does work fine.
any ideas?
Running: SQL 2005 SP2
Windows 2003 SP2
NB: not sure if this should be in administration or not.....admin, feel free to move if necessary!
Link: http://msdn.microsoft.com/en-us/library/bb326419(SQL.90).aspx
follow the instructions in the above link.
Problem may be IIS, check once.
December 2, 2008 at 11:30 am
thanks for the link but still getting the SQLSAC error which i believe is the root of all my issues...
anyone???
getting pretty desperate now :crazy:
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
February 4, 2009 at 6:01 pm
Hi,
I am having the same issue. The services of SSRS is running, Reporting Services Configuring Manager looks all okay. But I am getting this error:
TITLE: Connect to Server
------------------------------
Cannot connect to localhost.
------------------------------
ADDITIONAL INFORMATION:
Unable to connect to the remote server (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
No connection could be made because the target machine actively refused it (System)
------------------------------
BUTTONS:
OK
------------------------------
Then I tried going to SQL Server Surface Area Configuration and I found the culprit: WINDOWS INTEGRATED SECURITY.
I will also appreciate if somebody can help us on this issue.
Thanks
February 17, 2009 at 9:45 am
Same Problem here. Anyone have it figured out?
February 17, 2009 at 9:59 am
This may not be related to SAC check configuration manager to make sure SSRS is installed with an account with enough permissions and turned on. Then you may need to remove IIS 6 and add it again this time click on details to enable all the features needed to run Asp.net. You may also need to run aspnet_regiis in your C drive to resolve permissions related issues, the reason IIS 6 comes locked down to render only static html.
Kind regards,
Gift Peddie
February 17, 2009 at 12:33 pm
I HAVE FOUND THE SOLUTION FOR THIS PROBLEM:
The solution is the download and install SQL Server 2005 SP2. Here is the link:
Hope this helps everybody on this forum topic because it helps me...
February 17, 2009 at 12:38 pm
I HAVE FOUND THE SOLUTION FOR THIS PROBLEM:
The solution is the download and install SQL Server 2005 SP2.
I actually assumed everybody knows SP2 for both Win2003 and SQL Server 2005 SP2 are required for production server installation of SSRS 2005.
Kind regards,
Gift Peddie
February 19, 2009 at 6:04 pm
Not quite sure what you mean about your suggestion to run aspnet_regiis in your C drive to resolve permissions related issues.
Can you please explain further how this would be done? We have SP2 for both server and SQL and have tried reinstalling IIS but no luck.
February 19, 2009 at 6:34 pm
I have seen SSRS users who have not made sure Windows authentication is enabled so check the basics then go to the location below to run aspnet_regiis with the -i switch check the first link for aspnet_regiis documentations. The second link are the default IIS 6 permissions and you know there is the option to try SQL Server SP3 and SAC should be in your SQL Server folder in programs.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
http://support.microsoft.com/kb/812614
Kind regards,
Gift Peddie
February 24, 2009 at 7:50 am
Ok I have reinstalled IIS and from what I can tell tell have set the permissions.
Now we are getting the following error when browsing report server in IIS and http://localhost/reports
'Service Unavailable'
and when we try to login to SQL server 2005 surface area configuration tools
for reporting services on the windows integrated security section we get.
'The request failed with HTTP status 503: Service Unavailable. (SQLSAC)'
However this is the error we first had when we first attempted to use report server.
We have been going round and round for weeks.
Anyone have any more suggestions?
February 24, 2009 at 8:52 am
"The identity of application pool "AppPoolRS" is invalid, so the World Wide Web Publishing Service can not create a worker process to serve the application Pool, Therefore, the application pool has been disabled."
Check your event viewer to see if you have the above message then add the network services account to IIS_WPG Windows group. This problem relates to SSRS application pool identity and IIS 6 permissions so check the thread below for some possible solutions. You also need to apply the IIS 6 folder permissions I posted in my previous post. The last thing to check make sure your network service account is being initialized.
http://www.sqlservercentral.com/Forums/Topic282764-149-1.aspx#bm356088
Kind regards,
Gift Peddie
February 24, 2009 at 9:28 am
Thanks for the reply, I'm seeing two errors and one warning in the eventlog coming from W3SVC and DCOM.
W3SVC ERROR- EVENTID 1002 user N/A
Application pool 'DefaultAppPool' is being automatically disabled due to a series of failures in the process(es) serving that application pool.
W3SVC Warning - EVENTID 1009
A process serving application pool 'DefaultAppPool' terminated unexpectedly. The process id was '3800'. The process exit code was '0xffffffff'.
DCOM - EVENTID 10016 user NT AUTHORITY\NETWORK SERVICE
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{A9E69610-B80D-11D0-B9B9-00A0C922E750}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.
For the DCOM error eventid 10016b If I give network services access to the IIS_ADMIN in DCOM components section the DCOM error clears up and I am right back where I started with the orginal errors posted on this thread And since I spent a week going in that direction I figured that troubleshooting the problem from this angle, Service unavailable that I might have better luck
We followed this doc Default permissions and user rights for IIS 6.0 and all our settings match the doc.
We have sp2 for server and sql installed.
Are you familar with and microsoft application called IIS Diagnostics 32 bit. (Authentication and access control diagnostics) We are attempting to use this to troubleshoot our problems.
when we use that app and attemp to check verification of http://localhost/reports we get the following data.
StatusResultDetails
NTAuthenticationProviders
No Negotiate or Kerberos in the list of providersPath:W3SVC
AuthType:Kerberos
NTAuthenticationProviders
No Negotiate or Kerberos in the list of providersPath:W3SVC/1/ROOT/reports
AuthType:Kerberos
Test Authentication
Path:W3SVC/1/ROOT/reports
AuthType:NTLM
Diagnostics complete
anymore suggests?
February 24, 2009 at 10:00 am
You need to take care of the application pool issue and I think your DCOM is disabled a known issue with Win2003 SP1 so check below to fix it.
http://www.mydatabasesupport.com/forums/ms-sqlserver/246336-ssrs-2005-deployment-issue.html
Kind regards,
Gift Peddie
February 27, 2009 at 8:27 am
Ok I think we are getting an error closer to a solution I think. Here's where we are at now.
Gift Peddie your responses are appreciated.
1.We reinstalled IIS again.
2. Reconfigured Report Server.
****Now we get http://localhost/reports
Error
==============================================================================
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
Home
It is running, so I guess it's an access issue.
****Also when we try to log into management studio report server we ge the following error:
TITLE: Connect to Server
------------------------------
Cannot connect to PDDDS
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
An internal error occurred on the report server. See the error log for more details.(rsInternalError)
Object reference not set to an instance of an object.
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply