I have a fairly common problem that has been answer before here, but the answer does not work. The problem is that when I try to deploy a model from Visual Studio 2008 to our SQL Reporting Server, part of the model which is 13MB comes back with the error "...Maximum request length exceeded..." and will not transfer to the Reporting Server.
Now the common solution to this is to edit the httpRuntime maxRequestLength, and executionTimeout in either the we.config or the machine.config and change the limits to allow the files greater then 4MB to pass.
I changed the limits in both of them just to be sure. Did a restart on IIS. Tried to deploy the model again and came back with the same error. I also tried various sizes and am currently using 102400 (100MB) and 1200 seconds. Nothing seems to change anything.
My question would be, is there a work around for this problem if editing web.config and machine.config accomplish nothing?
Any help is appreciated and attached is the error code, cleaned up a little.
System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. --->
System.Web.HttpException: Maximum request length exceeded.
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, HttpContext context, HttpRequest request, HttpResponse response)
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
D:\Data\Sql\ReportServices\Kronos Model Project\Kronos Model Project\Kronos - Tkcsdb.smdl 0 0