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_CheckSc hemaVersion', database 'fancy_CollMemb ers', owner 'dbo'

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

Many thanks,

[Nick Malik [Microsoft]]

Re: Help in ASP.NET membership DB

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/de...AGHT000014.asp http://www.code-magazine.com/Article...d=0511031----- Nick Malik [Microsoft] MCSD, CFPS, Certified Scrummaster http://blogs.msdn.com/nickmalikDisclaimer: Opinions expressed in this forum are my own, and notrepresentati ve of my employer. I do not answer questions on behalf of my employer. I'm just aprogrammer helping programmers.--"Mike" <net.preneur@ho tmail.com> wrote in messagenews:eEV XabGYGHA.4120@T K2MSFTNGP03.phx .gbl...Hi guys,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_CheckSc hemaVersion', database'fancy_ CollMembers', owner 'dbo'Is there anything I miss when I set up the DB? How to solve this problem?Many thanks,

[Mike]

Re: Help in ASP.NET membership DB

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

"Nick Malik [Microsoft]" <nickmalik@hotm ail.nospam.com> wrote in message
news:StadnXWlxb 8iwtzZRVn-qg@comcast.com. ..[color=blue]
>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...b;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/de...AGHT000014.asp
> http://www.code-magazine.com/Article...d=0511031----- Nick Malik
> [Microsoft] MCSD, CFPS, Certified Scrummaster
> http://blogs.msdn.com/nickmalikDisclaimer: Opinions expressed in this
> forum are my own, and notrepresentati ve of my employer. I do not answer
> questions on behalf of my employer. I'm just aprogrammer helping
> programmers.--"Mike" <net.preneur@ho tmail.com> wrote in
> messagenews:eEV XabGYGHA.4120@T K2MSFTNGP03.phx .gbl...Hi guys,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_CheckSc hemaVersion',
> database'fancy_ CollMembers', owner 'dbo'Is there anything I miss when I
> set up the DB? How to solve this problem?Many thanks,
>[/color]