Problems deploying membership on a hosted environment

[Iván Sainz]

I ran the aspnet_regsql.exe tool with the -sqlexportonly option to create the
script. I searched and replace the string [dbo] by [mySchema] and had the
dba's run the script. When I do anything like Membership.CreateUser or click
on the 'security' tab in the website admin tool I get... Could not find
stored procedure 'dbo.aspnet_CheckSchemaVersion'.
I think this is because "dbo" is harcoded in the framework. The hosting
company won't let us use the dbo user of course. Do I have yo rewrite the
provider? Is there any other and easyer workaround for getting this to work?
Thank you very much

 

[Dominick Baier]

you can download the provider source here:

http://weblogs.asp.net/scottgu/archive/2006/04/13/442772.aspx

this allows you to change the schema/owner name...

 

[Iván Sainz]

I will try it. Thank you Dominick.