Solved

Fix the report server has detected a possible denial of service attack. For SQL Reporting services

Posted on 2011-03-14
3
3,745 Views
Last Modified: 2012-06-27
One of my developers is trying to run multiple threads against one of our SQL server reporting services instances and it generates a Error 112 possible denial of service attack and blocks IP. I assume this is something you can configure in the web.config file can someone please help me get this setup? I am familar with IIS but this is the first time i have worked with the Reporting Services Web Server.
0
Comment
Question by:amwinsit
  • 2
3 Comments
 
LVL 18

Expert Comment

by:x-men
ID: 35128828
0
 
LVL 2

Author Comment

by:amwinsit
ID: 35130039
I read through the article but i don't see how that applies to my situation. Maybe i need to clarify more. I believe the problem is the number of connections to the box in a short about of time is tripping the DOS threshold. In IIS this would be setup via DIPR but i don't know where to look for the setting is Reporting Services web Server. If the job only failes if it is run on the local lan if it runs across even a 5-10 ms link it will run successfully but the whole point of the multiple threads is to get the job done faster.
0
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 35138540

In web.config:

connection string for SQL Server:
"Data Source=(local);Initial Catalog=pubs;User ID=sa;Password=;Max Pool Size=100;Min Pool Size=5;"

0

Featured Post

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.

Join & Write a Comment

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

758 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

23 Experts available now in Live!

Get 1:1 Help Now