Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL serve

最新推荐文章于 2021-01-12 10:36:53 发布

转载最新推荐文章于 2021-01-12 10:36:53 发布 · 2k 阅读

收录于

ASP.Net

当前文章被收录于：

ASP.Net

29 篇文章 0 人学习

订阅专栏查看详情

Web

当前文章被收录于：

Web

21 篇文章 0 人学习

订阅专栏查看详情

Windows

当前文章被收录于：

Windows

14 篇文章 0 人学习

订阅专栏查看详情

当前文章被以下社区和专栏收录：

本文介绍了解决ASP.NET 2.0 Session State未安装导致无法使用SQL Server的问题。作者详细记录了安装过程及遇到的错误，并分享了通过调整数据库权限成功解决问题的方法。

原帖地址：http://www.power-programming.co.uk/post/2010/11/12/Unable-to-use-SQL-Server-because-ASPNET-version-20-Session-State-is-not-installed-on-the-SQL-server-Please-install-ASPNET-Session-State-SQL-Server-version-20-or-above.aspx

I installed a new aspstate database on a virgin server, and we kept getting the following error

"Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above. "

I'd installed it from the Version 2 framework, and got successful response

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -ssadd -sstype c -d ASPState -S eduat1sql1 -E

Start adding session state.

....

Finished.

To use this custom session state database in your web application, please specify it in the configuration file by using the 'allowCustomSqlDatabase' and 'sqlConnectionString' attributes in the <system.web>\<sessionState> section.

You will note, that I have used the integrated switch, this is because I don't want the ultimate ASPNET user to have database creation permissions. Initially, I have the ASPNET database user db_datareader and db_datawriter roles and I think this is where the issue arose. I removed this permissions and allocated db_owner role and all is working!