Windows 2003 Identity issue.

Discussion in 'ASP .Net Security' started by MikeH, Aug 4, 2003.

  1. MikeH

    MikeH Guest

    I have a small ASP.NET app that maintains a SQL Server
    database. When I delpoy to a Windows 2003 Enterprize
    Server I get the following error on connecting to the
    RDBMS...

    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

    To overcome this problem I have modified the logins on
    SQL Server as follows...

    exec sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'
    exec sp_grantdbaccess 'NT AUTHORITY\NETWORK SERVICE'

    This works fine thus far but I am concerned as to whether
    or not this is the "correct" way of doing things. In
    particular, does it open up any security holes?

    Thank you
     
    MikeH, Aug 4, 2003
    #1
    1. Advertisements

  2. | I have a small ASP.NET app that maintains a SQL Server
    | database. When I delpoy to a Windows 2003 Enterprize
    | Server I get the following error on connecting to the
    | RDBMS...
    |
    | Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

    You can do two things:

    1. Use SQL server, not Windows authentication.
    2. Impersonate the web application to be running under specific user
    account.
     
    Michal A. Valasek, Aug 4, 2003
    #2
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.