Changing security fixes hang problem temporarily

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: code3_brent (code3_brent_at_discussions.microsoft.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 11:17:02 -0800

I created a DLL in VB6 that handles all the database access for some ASP
pages that I created. The application basically authenticates the user
against the database, does a search, reads a graphic file from the database,
writes it to a folder on the server, then displays it in a browser. All was
working great on my laptop with XP Pro. I now installed it on a 2003 server
with IIS. I am now getting intermittant problems.

Somtimes I get an internal error 500, but most times the page just hangs and
never comes back. If I change the permissions on the folder where the
graphics file gets written to give 'Everyone' full access, everything works
great. Once I reboot the server, it stops working again. If I then remove the
'Everyone' permission from the folder, it works again. Upon reboot, it
doesn't work again.

It appears that anytime I change the permissions, it starts to work, but it
doesn't matter what I change. Either adding the 'Everyone' group or removing
it makes it start to work.

Any idea wat else to try?

Relevant Pages

  • RE: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
    (microsoft.public.sqlserver.security)
  • Re: Effective Permissions Error with Domain User
    ... I set the database compatibility to 2005. ... server profile trace and found that it was calling the Execute As User. ... This leads me to believe it is some sort of permissions issue. ... Did you get these database from SQL Server 2000 by using a RESTORE command? ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent DELETEs in a table
    ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
    (microsoft.public.sqlserver.server)
  • Re: Disable Sysadmin to view metadata in SQL2005
    ... you are looking for a DRM solution for your database. ... Server does not provide such a solution. ... SQL Server Engine ... If the permissions are not granular ...
    (microsoft.public.sqlserver.security)
  • Re: Table permissions: No matter what I set all users have full access?
    ... I have created a new Windows user the ... logged on to another PC as that user and can still access the database with ... The new user does not have a login on the server and is ... I even created a login for the user and denied SELECT permissions on various ...
    (microsoft.public.access.adp.sqlserver)