Help in ASP.NET membership DB

[Mike]

Hi guys,

After successfully creating all objects of my ASP.NET membership db to my hosted server, I tried to run a from that registers a user.

I got following error:

EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'fancy_CollMembers', owner 'dbo'

Is there anything I miss when I set up the DB? How to solve this problem?

Many thanks,

 

[Nick Malik [Microsoft]]

I know so little about your app or your installation, that this is hard to
answer. However, normally, when we see this error, it is because the
ASP.Net app is running using credentials that are not enabled in the
database. One common way to handle this is to have your web site
impersonate a user that is on the server, and use that user's credentials to
access the database. Of course, you'd have to keep these credentials
secure. This is described here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;329290

If you are talking about an ASP.Net 2.0 credentials store, then these
articles may help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000014.asp http://www.code-magazine.com/Article.aspx?quickid=0511031----- Nick Malik [Microsoft] MCSD, CFPS, Certified Scrummaster http://blogs.msdn.com/nickmalikDisclaimer: Opinions expressed in this forum are my own, and notrepresentative of my employer. I do not answer questions on behalf of my employer. I'm just aprogrammer helping programmers.--"Mike" <[email protected]> wrote in messageguys,After successfully creating all objects of my ASP.NET membership db to myhosted server, I tried to run a from that registers a user.I got following error:EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database'fancy_CollMembers', owner 'dbo'Is there anything I miss when I set up the DB? How to solve this problem?Many thanks,

 

[Mike]

Thanks Nick,

I just found out, that the error mess caused by the lack of DBO permission
to exec the sproc. After giving the DBO permission to the DB it works fine.

Anyway, many thanks for the valueable resources you gave.

Regards,
Andy