sessionState mode="SQLServer" causes an error

[Bernard]

Hello,

I would like to implement the SessionState mode = "SqlServer" (not the InProc).

<sessionState

      mode="SQLServer"

      allowCustomSqlDatabase = "true"

      sqlConnectionString="Data Source=mySource;Initial Catalog=MyDB ;Persist Security Info=True;User ID=Myuser;Password=MyPwd"

      cookieless="false"

      timeout="720"

      />

Everything works well behalf Telerik Reporting !!!

I join the complete message I receive in Report viewer:

Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.
   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at Telerik.Reporting.Service.SilverlightClient.RenderAndCacheEventArgs.get_RenderingResult()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnRenderAndCacheCompleted(Object sender, RenderAndCacheEventArgs e)

------------- InnerException: -------------

System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
   at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
   at proxy_4.EndRenderAndCache(IAsyncResult )
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndRenderAndCache(IAsyncResult result)
   at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)

------------- InnerException: -------------

System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
   at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)

------------- InnerException: -------------

System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
   at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
   at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)

Any ideas ?

[Steve]

Hi Bernard,

We have not been able to reproduce such a problem in our local tests and suspect there is something else wrong in your scenario, as the Not Found error is a generic one. In order to get more information about the actual problem try the following:

• show the Output window in Visual Studio and check whether there is an exception when you're running your application in debug mode.
• access the .svc file directly in your browser to see if it reports any problems.
• enable the CLR exceptions from Debug --> Exceptions menu in Visual Studio and run your project in debug.

Additionally, you already have a runnable sample at your disposal - the Visual Studio examples we install along with the product. You can use the Silverlight application and configure it to use Out-Proc session.

Greetings,
Steve
the Telerik team