Posted on: 6/30/2014 3:18:09 PM | Views : 469

I am using sitefinity 6.3 application with .net 4.0 and sql server 2008 I am trying to configure application with sql server. I have setup ASPState db on my database server and in my connection string i have put following connection string
<sessionState mode="SQLServer" cookieless="false" timeout="20" sqlConnectionString="data source=myserverlocation;user id=YYYYYY;password=XXXXXX;" /> But when Trying to browse my site i am geting error Conversion failed when converting the varchar value '9105e526' to data type int.
When digged out problem in ASpState db via sql profiler i check @appName is passing as 9105e526
DECLARE @return_value int, @appId int EXEC @return_value = [dbo].[TempGetAppID] @appName = 9105e526, @appId = @appId OUTPUT SELECT @appId as N'@appId' SELECT 'Return Value' = ...

Go to the complete details ...