permissions are getting lost

Discussion in 'Classic ASP' started by steurm, Oct 18, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. steurm

    steurm

    I have a timesheet webapplication, build with classic asp (not hosted on discountAsp.net). The database is SQL server. Every now and then (even not weekly), the application looses its permissions on SQL-server, meaning that the sql-server account used for this webapplication looses its permissions on the timesheet-database. We can't figure out why this happens. Anyone with a clue ?



    --
    Steurm
    www.steurm.net/steurm
    [​IMG]

    Post Edited (steurm) : 10/19/2004 8:56:01 AM GMT
     
    steurm, Oct 18, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    What do you mean by loosing permission?

    SQL permission or your web application's NTFS permission?

    Any error?


    quote:Originally posted by steurm

    I have a timesheet webapplication, build with classic asp (not hosted on discountAsp.net). The database is SQL server. Every now and then (even not weekly), the application looses its permissions on SQL-server, meaning that the sql-server account used for this webapplication looses its permissions on the timesheet-database. We can't figure out why this happens. Anyone with a clue ?

    --
    Steurm
    www.steurm.net/steurm
    </blockquote id="quote"></font id="quote">

    B.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Bruce, Oct 18, 2004
    #2
  3. steurm

    steurm

    the database permissions are checked of for the database on the "permissions" tab of the user accounts properties. It's very strange and inconvenient, cause we can't explain to the customer what is happening. An email is sent when it happens, so we can set the permissions again right away, but they get the error, which is not very nice.

    --
    Steurm
    www.steurm.net/steurm
     
    steurm, Oct 19, 2004
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    This is very strange!!!

    The only thing I can think of is that the database has some sort of maintainence plan or scheduled job that changed the permission.

    I would check with the SQL server administrator.

    BTW, how you like our new forum?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Oct 19, 2004
    #4
  5. steurm

    steurm

    yep, it is very strange (almost lost all my hair) [​IMG]
    I'll get to the database administrator right away

    The new forum is nice, but it will take some time to get used to the new look and feel. It seamsto be considerably faster as well.

    --
    Steurm
    www.steurm.net/steurm
     
    steurm, Oct 19, 2004
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page