Post reply

SQL on Win2003 server

  • February 5, 2004 at 5:02 pm

    #107622

    I'm having troubles connecting thru Dot Net (C#) Application to the SQl 2000 MSDE on Win2003 Storage Server. I did add the NT Authority\Network Service account as recommended, but that did not help. I use SQL mixed security.

    Any ideas what could be wrong?

    Thanks a lot.

    MJ

  • February 5, 2004 at 5:36 pm

    #492976

    What errors are you getting?

    K. Brian Kelley
    @kbriankelley

  • February 5, 2004 at 9:20 pm

    #492985

    The error message is :"Login fails for user Nt Autority". In win2000 I use ASPNET login for IIS services localy on the SQL Server. In Win2003 suppose to be NTAutority\Network service...but it did not work...

    Thanks a lot,

    MJ

  • February 5, 2004 at 9:25 pm

    #492986

    IIS is on the same system as SQL Server or different systems?

     

    K. Brian Kelley
    @kbriankelley

  • February 5, 2004 at 9:37 pm

    #492988

    Our developers are still running the app from their local machines - SQL server is separated from the application. When I point the app to  win2000 server with "local machine\ASPNET", the app works, but when pointed to win2003 - does not connect with the error "Login failure". It finds the server and the DB, but on the user name and password - crashes...

    Thanks,

    MJ

  • February 5, 2004 at 9:52 pm

    #492989

    Does any of this help?

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;317012

    The Win2000 server doesn't happen to have an ASPNET account locally, does it?

     

    K. Brian Kelley
    @kbriankelley

  • February 5, 2004 at 9:56 pm

    #492990

    Yes, it does.

    I'm trying to run this -

    exec sp_grantdbaccess 'NT AUTHORITY\NETWORK SERVICE'

    exec sp_addsrvrolemember 'NT AUTHORITY\NETWORK SERVICE', 'securityadmin'

    exec sp_addsrvrolemember 'NT AUTHORITY\NETWORK SERVICE', 'processadmin'

    exec sp_addsrvrolemember 'NT AUTHORITY\NETWORK SERVICE', 'dbcreator'

    exec sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'

    go

    We'll see if it works... and I"ll post the result.

    Thanks,

    MJ

  • February 5, 2004 at 10:29 pm

    #492994

    Hi everybody - it does work!

    The problem is that win2003 uses IIS6 new security model. Run the code against the database.

    Works!

    Thanks a lot.

    MJ

Viewing 8 posts - 1 through 8 (of 8 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy