April 1, 2008 at 4:49 am
This is now the second time this has occurred on my reporting server, where the users suddenly start to get an error on screen stating "Unable to connect to the remote server". Once i had been notified i tried to execute some myself and got the same error, not just when executing a report, but when navigating around the main reporting services site (Reports).
now when i access reporting services via the ReportServerwebsitee i can navigate and execute all reports ok.
I checked the application event log and found an entry being generated for each error being shown to the user. The error explains that there is an issue with using a socket for more than oneuseagee, see below
[font="Courier New"]Event code: 3005
Event message: Anunhandledd exception has occurred.
Event time: 01/04/2008 11:02:45
Event time (UTC): 01/04/2008 10:02:45
Event ID: 5ff74cf32da24fe6b2a9787e1f66bbad
Event sequence: 1182
Event occurrence: 31
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/CompanyReports-1-128515051101221623
Trust level: RosettaMgr
Application Virtual Path: /CompanyReports
Application Path: C:\Program Files\Microsoft SQL Server Reporting Services\MSSQL.3\Reporting Services\ReportManager\
Machine name: OurServerName
Process information:
Process ID: 924
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SocketException
Exception message: Only one usage of each socket address (protocol/network address/port) is normally permitted [/font]
The only resolution we have at present is to reboot the server, which is ok, until this server becomes more widely used.
Can anyone help. hope this makes sense, and that someone else has hadtheh same issue and resolved without a reboot.
September 15, 2008 at 9:10 am
I have the exact same issue, but I can't figure it out.
September 15, 2008 at 12:04 pm
i have now found the resolution to the this and other issues i have been having my SSRS server.
It came down to anti virus software (FSecure) which was installed and had a memory leak which after around 20 days started to cause authentication failures in SSRS and if left unchecked @ 28days it caused all external authentication to fail.
Our temporary solutions were:
1st. Reboot before 28days was up.
2nd. restart the AV software services.
but we ultimately upgraded the av software to a newer version and this has solved this issue altogether.
I would wdvise checked the pool nonpaged counter for each av service/process and this should highlight any leaks from there..
what we found was that it was a very slow increase day on day and on restart of the av services it reset to normal.
Hope this helps you and anyone else with similar issues like RPC errors when connecting to sql server or unable to autheticate users, which can be other symptom of this issue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply