SQL Permission question

From: Drew (drew.laing_at_NOswvtc.dmhmrsas.virginia.SPMgov)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 09:29:21 -0500

I would like to know what the permissions should be for the following
directory on my SQL Server.

<Program Files>\Common Files\System\Ole DB folder

I am having a really annoying error message and found that this directory
needs Full Control permissions for everyone. My administrator is leery of
letting everyone have full contol of this folder.

Here is the error message that I am recieving.

"Unable to load SQL Server OLEDB provider dll. The application cannot
continue"

I have reapplied the service packs, and reinstalled MDAC.

This error rears it's ugly face on simple errors, like trying to SELECT a
column that isn't there, or making a typo in a statement.

Thanks,
Drew Laing

Relevant Pages

  • Failed to Start Monitoring Directory Changes
    ... You receive the first error message if the Aspnet_wp.exe process identity does not have permissions on at least one of the directories in the hierarchy of that file path. ... You receive the second error message if the impersonated account does not have permissions on at least one of the directories in the hierarchy of that file path. ... Right-click the folder, and then click Properties. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: HELP 911!!! i cant save to or delete from my D: drive
    ... get an error message, please quote it verbatim. ... Error deleteing file or folder ... Cannot delete aol: Access denied ... It could be an issue of ownership and permissions. ...
    (microsoft.public.windowsxp.general)
  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Location for shared Access database
    ... Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network? ... I don't think that the "Programs" folder is the right place. ... For a network-shared database, use SQL Server instead: ... This will work on Vista as well, although you'll need to adjust the local folder permissions since users don't have write permissions on c:\ by default. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: error: "Failed to generate a user instance of SQL Server due to a failure in starting the proces
    ... time the user creates a User Instance connection, ... Files\Microsoft SQL Server] directory. ... folder to the Microsoft supposed "default" folder, ... I've checked the permissions and found that the ASPNET user not listed on ...
    (microsoft.public.sqlserver.connect)