locked
Execute permissions denied on object 'aspnet_starterkits_GetAllProjects', Database 'TimeTracker', schema 'dbo' RRS feed

  • Question

  • User-504484440 posted
    I've downloaded the kit and I've changed the web.config and the dataconnection object to point to the default SQL 2005 instance on my server. I've had all kinds of problems trying to get this to work but I've finally gotten to the part. But I've finally gotten it to let me create a user but I get this error when trying to login. What I've done in just trying to get this to work is given the NT Authority\NETWORK Service account full permissions to everything. Still no luck, any ideas?
    Saturday, November 12, 2005 3:47 PM

All replies

  • User217889999 posted
    Which account to grant permissions may depend on which OS you are hosting the app on. If you are using Windows 2003 Server with IIS 6.0, then the account above should be OK. But normally, <machinename>\ASPNET is the account to grant db_owner permission to your database.

    Try this:

    Enter Sql Manager
    Connect to your DB Instance
    Choose (root) Security and then Users (if the <machinename>\ASPNET account is not present, add it!)
    Choose the TT Db and the then the ASPNET account
    Check the 'db_owner' role, and you should be good to use integrated security
    Saturday, November 12, 2005 4:21 PM
  • User-504484440 posted
    Problem was I had to go grant Execute to one of the schema roles and now it works. Thanks
    Saturday, November 12, 2005 5:16 PM
  • User-848625358 posted

    please disregard, I found my answer here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2121431&SiteID=1.

    Thursday, October 23, 2008 2:34 PM
  • User555306248 posted

    You should check the EXECUTE permissions associated with your object in your database. The user you are running that object as should have EXECUTE permissions or it should be a member of a group with EXECUTE permissions. I hope this helps.

    Thursday, October 23, 2008 11:41 PM
  • User555306248 posted

    Thats nice [:)]

    Thursday, November 6, 2008 10:52 PM