ASP.Net Role Management problem

microsoft.public.sqlserver.tools

6 Apr 2006 9:56 AM

SteveUKdev

I'm trying to implement ASP.NET 2.0 Role Management on an SQL Server 2000 DB.
It worked fine on my development server, but when deploying to my test server
my login dialog (using ASP.Net Login Control) fails with the following
exception:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

I have checked the that this SP has been created and although it is called
'aspnet_CheckSchemaVersion' it states that it's owner is [dbo].

Please can anyone help as I'm losing my hair on this one!

--
Steve