Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. The user account must have the db_owner permission to store information about the ASP.NET session state in the SQL Server database

The user account must have the db_owner permission to store information about the ASP.NET session state in the SQL Server database

View products that this article applies to.

Introduction

In a shared user environment, the user account must have the db_owner permission to store information about the ASP.NET session state in the Microsoft SQL Server database.

↑ Back to the top

More information

To store information about ASP.NET session state in the SQL Server database, you have to run one of the following SQL script files:
  • %WINDIR%\Microsoft.NET\Framework\v2.0.50727\InstallSqlState.sql
  • %WINDIR%\Microsoft.NET\Framework\v2.0.50727\InstallPersistSqlState.sql
However, the user account must have the db_owner permission for the scripts to run successfully.

These script files are included with the Microsoft .NET Framework.

↑ Back to the top

References

For more information about how to store session state information by using SQL Server, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/87069683(vs.71).aspx

↑ Back to the top

Keywords: KB954838, kbexpertiseinter, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 954838
Revision : 1
Created on : 7/3/2008
Published on : 7/3/2008
Exists online : False
Views : 420