ASPState

tema enviado por Iester en ASP.NET
tema iniciado el 05/08/2008

Mi programa usa sessiones y esta configurado asi:

<sessionState mode="SQLServer" sqlConnectionString="Data Source=diseno1;User ID=req1;Password=sql" timeout="360"/>

cuando esta en sql 2005 no hay problemas, sin embargo en sql 2000 se presenta este problema:

SELECT permission denied on object 'ASPStateTempApplications', database
'tempdb', owner 'dbo'.
SELECT permission denied on object 'ASPStateTempApplications', database
'tempdb', owner 'dbo'.
INSERT permission denied on object 'ASPStateTempApplications', database
'tempdb', owner 'dbo'.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SELECT permission
denied on object 'ASPStateTempApplications', database 'tempdb', owner
'dbo'.
SELECT permission denied on object 'ASPStateTempApplications', database
'tempdb', owner 'dbo'.
INSERT permission denied on object 'ASPStateTempApplications', database
'tempdb', owner 'dbo'.

Source Error:

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

 

Ya le he puesto al usuario req que es el que uso los permisos a la tabla ASPState lo he puesto como owner, sin embargo sale el error.

Alguna ayuda por favor. Gracias