Windows 2003, SQL Server 2000 and Webservice

Discussion in 'ASP .Net Web Services' started by Adnan Hebibovic, Jan 26, 2005.

  1. Ok this is scenario:

    I have installed Win2k3 with all patches, SQL Server 2000 Ent with SP3a. On
    my home machine I have WinXP SP2 and there I created webservice to access to
    the SQL Server to read some data, create DataSet and return that DataSet to
    the client. I connected to SQL Server using Windows Authentification.
    Everything was working properly until I have deployeed that webservice to
    the Win2k3.

    As I realized there wasn't ASPNET account on Win2k3. Error message: SQL
    Server doesn't exists or access deined.

    How to create ASPNET account with all privileges (but restricted as
    possible) on Win2k3? As I heard that service must access Microsft .NET
    directory, modify some xml and so on.

    Help needed.

    Adnan
    Adnan Hebibovic, Jan 26, 2005
    #1
    1. Advertising

  2. Adnan Hebibovic

    [MSFT] Guest

    Hello Adnan,

    Within Windows server 2003 and .NET framework 1.1, ASP .NET will use the
    account "network service" instead of "ASPNET". You may add this acount to
    local administrator group so that it can have enough permission to access
    local resource and the SQL server.

    Luke
    [MSFT], Jan 27, 2005
    #2
    1. Advertising

  3. Thanks

    "[MSFT]" <> wrote in message
    news:D...
    > Hello Adnan,
    >
    > Within Windows server 2003 and .NET framework 1.1, ASP .NET will use the
    > account "network service" instead of "ASPNET". You may add this acount to
    > local administrator group so that it can have enough permission to access
    > local resource and the SQL server.
    >
    > Luke
    >
    >
    Adnan Hebibovic, Jan 27, 2005
    #3
  4. Adnan Hebibovic

    [MSFT] Guest

    You are welcome!

    Luke
    [MSFT], Jan 28, 2005
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Z2F1cmF2?=

    Uploading Data From MS Acess 2000 ti SQL server 2000

    =?Utf-8?B?Z2F1cmF2?=, Jan 9, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    788
    Mary Chipman [MSFT]
    Jan 9, 2006
  2. Vaap
    Replies:
    2
    Views:
    1,143
  3. Daves
    Replies:
    1
    Views:
    361
  4. C Did
    Replies:
    3
    Views:
    3,925
    Chris Lithgow
    Jun 20, 2006
  5. Denis

    Access 2000 or SQL Server 2000

    Denis, Jan 25, 2004, in forum: ASP General
    Replies:
    1
    Views:
    181
    Nicole Calinoiu
    Jan 25, 2004
Loading...

Share This Page