asp.net会话状态模式"SQLServer" [英] asp.net session state mode "SQLServer"

问题描述

我的网站是LIVE.并且此问题与在LIVE服务器上而不是在localhost中配置会话超时有关."

"My website is LIVE. And this problem is related to configure session timeout on LIVE server and not in localhost."

我有一个会话过期时间过快的问题.仅在2-5分钟内链接.我尝试了很多事情，最后决定以"SQL Server"模式存储会话

I have a problem with session expiring too soon. link in 2-5 minutes only. I tried lot of things and at last decided to store the session in "SQL Server" mode

在我的web.config文件中，我具有以下代码:

in my web.config file i have following coding:

<sessionState mode="SQLServer" cookieless="false" timeout="45"
sqlConnectionString="data source=xxx.xx.xx.xxx;uid=xxxxxxx;pwd=xxxxxxxx"/>

，我在服务器上的ASPState表中具有所需的所有表.您可以从下面的图片中看到它.

and i have all the tables required in ASPState table on server. You can see it from the image below.

但是，当我运行我的应用程序时，它会引发以下错误:

But i when i run my application, its throws the below error:

无法使用SQL Server，因为SQL Server上未安装ASP.NET 2.0会话状态，或者ASP.NET没有运行dbo.TempGetVersion存储过程的权限.如果ASP.NET会话状态尚未安装架构，请安装ASP.NET会话状态SQL Server 2.0或更高版本；如果已安装架构，请授予dbo.TempGetVersion存储过程的执行权限给ASP.NET应用程序池标识或在sqlConnectionString属性中指定的Sql Server用户."

"Unable to use SQL Server because either ASP.NET version 2.0 Session State is not installed on the SQL server, or ASP.NET does not have permission to run the dbo.TempGetVersion stored procedure. If the ASP.NET Session State schema has not been installed, please install ASP.NET Session State SQL Server version 2.0 or above. If the schema has been installed, please grant execute permission on the dbo.TempGetVersion stored procedure to either the ASP.NET application pool identity, or the Sql Server user specified in the sqlConnectionString attribute."

错误图片:

我无法理解确切的问题以及如何解决.任何帮助将不胜感激.

I am not able to understand the exact problem and how i can solve it. Any help will be appreciated.

谢谢

推荐答案

在树中打开可编程性"，然后首先检查dbo.TempGetVersion是否存在.可能您尚未安装正确的架构.

Open "Programmability" in your tree and check first if dbo.TempGetVersion exists. Probably you have not installed the proper schema.

这篇关于asp.net会话状态模式"SQLServer"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！