SqlMembership Provider without dbo owner

  • Thread starter Thread starter Mike Endys
  • Start date Start date
M

Mike Endys

Hello guys,

I have this problem:

My webhosting provider does not allow to set dob owner to the tables, views
and stored procedures that are used by SQLMembership Provider.
I tried create script by aspnet_regsql utility and change there all dbo. to
the myown. owner. Then I applied the script to the webhosting sql server.
All tables, views and stored procedures has been created but the
SqlMemebrship provider asking me still for dbo.aspnet_CheckSchemaVersion

Is there any way to configure the SqlMembership Provider to use another
owner than dbo. ???

Thanks for help

Mike
 
Hi Mike,

The SqlMembershipProvider internally uses dbo.SP_Name. Here's the code
snippet from the source code of SqlMembershipProvider:

SqlCommand command = new
SqlCommand("dbo.aspnet_Membership_CreateUser", connection.Connection);

You can see it's hard coded so I think dbo schema is required for the
stored procedure.
To solve this problem I think you have two options.

" Persuade your web hosting provider to allow this.
" Implement a custom Membership provider (It's a little complicated)
http://msdn.microsoft.com/en-us/library/f1kyba5e.aspx

Regards,
Allen Chen
Microsoft Online Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
"Persuade" your host ... OR Drop That Hosting provider.

That is a very limiting factor for them to implement. Too limiting in my
opinion.


Allen is correct that a custom provider is the other option, but to
reiterate, it is NOT trivial.


Get a different hosting provider.
 
There are certain things that are hard coded, as Allen has stated. There is
a way around the mess, however, and it is to set up your own custom
provider. With Reflector you can examine the default SQL Provider and mimic
it with your own namespace. There are plenty of Google hits on custom
membership provider out there.

The default implementation, however, does not allow what you desire.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Blog:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
 
They are the easiest methods, as you simply move on. You can also code a
custom membership provider.

Perhaps by the next iteration, these will be exposed in config, but they are
not now.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Blog:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
 
Hi Mike,

Have you got the expected answer? If you have additional questions please
feel free to ask.

Regards,
Allen Chen
Microsoft Online Community Support
 
Back
Top