Professional Web Applications Themes

SQL Access issue - ASP Database

In my app I am uploading a text file to the IIS server. I then use a stored procedure on the SQL server to import the text file into SQL. IIS and SQL run on seperate computers. Currently they are in a workgroup configuration. The problem I am having is the SQL server does not have access to the IIS server. Someone has recommended that we create a d omain and grant the SQL server rights on the IIS server. Is this the only way to fix this or could we create a user account on the IIS server that ...

  1. #1

    Default SQL Access issue

    In my app I am uploading a text file to the IIS server. I then use a stored
    procedure on the SQL server to import the text file into SQL. IIS and SQL
    run on seperate computers. Currently they are in a workgroup configuration.
    The problem I am having is the SQL server does not have access to the IIS
    server. Someone has recommended that we create a d omain and grant the SQL
    server rights on the IIS server. Is this the only way to fix this or could
    we create a user account on the IIS server that would fix this. I am not
    sure what account is being used by the SQL server when the request for data
    on the IIS server is made. Would it be the account that SQL runs under?

    Thanks for your help!


    Tim Kelley Guest

  2. #2

    Default Re: SQL Access issue

    On Thu, 5 Aug 2004 08:28:47 -0500, "Tim Kelley"
    <tim.kelleyiddonline.com> wrote:
    >In my app I am uploading a text file to the IIS server. I then use a stored
    >procedure on the SQL server to import the text file into SQL. IIS and SQL
    >run on seperate computers. Currently they are in a workgroup configuration.
    >The problem I am having is the SQL server does not have access to the IIS
    >server. Someone has recommended that we create a d omain and grant the SQL
    >server rights on the IIS server. Is this the only way to fix this or could
    >we create a user account on the IIS server that would fix this. I am not
    >sure what account is being used by the SQL server when the request for data
    >on the IIS server is made. Would it be the account that SQL runs under?
    The process is reversed, but this may help:

    HOWTO: IIS and SQL Server on Separate Machines with Trusted
    Connection:
    [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379[/url]

    Jeff
    Jeff Cochran Guest

Similar Threads

  1. AS400 access issue
    By kfoss in forum Coldfusion Database Access
    Replies: 3
    Last Post: November 3rd, 05:24 PM
  2. web service access issue
    By androger in forum ASP.NET Web Services
    Replies: 2
    Last Post: June 14th, 02:10 PM
  3. access database issue
    By dwd1 in forum Coldfusion Database Access
    Replies: 5
    Last Post: May 27th, 09:29 PM
  4. ASP.NET Access Update Issue
    By Matthew David in forum Dreamweaver AppDev
    Replies: 11
    Last Post: April 8th, 05:33 PM
  5. Access Level Issue
    By Eric8000 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: March 1st, 07:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139