Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Error Creating ASP.NET Membership

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-09-30 : 20:40:45
Hello,

I got the full script to create the ASP.NET Membership tables.
When I run the scripts on my table I get the following:

---------------------------------------
Starting execution of InstallCommon.SQL
---------------------------------------

(310 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
----------------------------------------
Completed execution of InstallCommon.SQL
----------------------------------------
-------------------------------------------
Starting execution of InstallMembership.SQL
-------------------------------------------
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
--------------------------------------------
Completed execution of InstallMembership.SQL
--------------------------------------------
------------------------------------------------
Starting execution of InstallProfile.SQL
------------------------------------------------
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
-------------------------------------------------
Completed execution of InstallProfile.SQL
-------------------------------------------------
--------------------------------------
Starting execution of InstallRoles.SQL
--------------------------------------
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
---------------------------------------
Completed execution of InstallRoles.SQL
---------------------------------------
------------------------------------------------
Starting execution of InstallPersonalization.SQL
------------------------------------------------
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
-------------------------------------------------
Completed execution of InstallPersonalization.SQL
-------------------------------------------------
----------------------------------------------------
Starting execution of InstallWebEventSqlProvider.SQL
----------------------------------------------------
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
-----------------------------------------------------
Completed execution of InstallWebEventSqlProvider.SQL
-----------------------------------------------------

If I run the scripts on aspnetdb table it works fine.

Does anyone knows what is wrong?

Thanks,
Miguel

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-10-01 : 05:14:39
Could someone please, help me out?

I tried to change the permissions following this article:
http://blog.techdreams.org/2007/11/create-database-permission-denied-sql.html

I tried everything I could think of but still not able to run the script without errors on my database.

Thank You,
Miguel
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-01 : 05:19:22
sounds like a permissions issue, what version of MS SQL are you using ?

And do you have the permissions assigned to that account ?
Go to Top of Page
   

- Advertisement -