aspnet_CheckSchemaVersion

[Dimitrie1]

I am getting the above error when attempting to use roles on an asp.net application.

We connect using an application user with dbo rights. it works locally (C drive) but not when loaded to our joint developement environment on the network.

EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'BusPass', owner 'dbo'.

Is it possible that SQL is looking at the network user instead of the database user?

 

[NoCoolHandle]

You are suffering from a permission error.

The key will be to grant permission to the account you are using to execute the proc.

To find out who the user is, do a trace (sql profiler) and try to execute the proc.

Then grant execute on the proc to that account.

Rob

 

[NoCoolHandle]

The account is probably the aspnet account, but it might also be the inetusr_computername account

Bottom line, if you don't know, run a trace on the server.

 

[Dimitrie1]

thanks I'll try the trace