SQL on Win2003 server

  • mjschwenger

    SSCarpal Tunnel

    Points: 4019

    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

  • K. Brian Kelley

    SSC Guru

    Points: 114465

    What errors are you getting?

    K. Brian Kelley
    @kbriankelley

  • mjschwenger

    SSCarpal Tunnel

    Points: 4019

    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

  • K. Brian Kelley

    SSC Guru

    Points: 114465

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

     

    K. Brian Kelley
    @kbriankelley

  • mjschwenger

    SSCarpal Tunnel

    Points: 4019

    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

  • K. Brian Kelley

    SSC Guru

    Points: 114465

    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

  • mjschwenger

    SSCarpal Tunnel

    Points: 4019

    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

  • mjschwenger

    SSCarpal Tunnel

    Points: 4019

    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