Post reply

IUSR Permissions

  • June 9, 2003 at 1:46 pm

    #58505

    I have been working on a SQL box for about a week or so. I am accessing a SQL box with an ASP page. I get an access denied error

    Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    /webserver.asp, line 8

    I ran the same script locally on the SQL box and it worked. That led me to believe that there is an issue with the IUSR account or another account. Can anyone help?

    Thanks,

    Tony

  • June 9, 2003 at 2:22 pm

    #460468

    If you are sure the IUSR account has to access SQL Server, run sp_grantlogin 'tordev01\iusr_tordev01' and assign proper permissions to it. (Change tordev01 to your server name).

  • June 9, 2003 at 2:27 pm

    #460469

    When using SQL Query Analyzer:

    What DB would I run that proc under...master

    Thanks

  • June 9, 2003 at 2:30 pm

    #460470

    Run it from QA from master database. You need 'sa' or 'security admin' right to run it. Ask your DBA to help.

  • June 9, 2003 at 3:01 pm

    #460475

    I ran the stored proc, set db permissions in SQL.

    Still got the same error. Do I have to set permissions to some folders, etc...

    thanks

    ps.We do not have an admin, just me the developer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply