mixed authentication

Jeg har husket at tilføje asp.net under security

Hvis du indstiller MS SQL til kun windows aut., kan du ikke logge ind med user og psw. Du skal være godkendt som windows bruger. Hvis du indstiller den til både og, kan du både komme på som windows bruger og (helt udefra) med user og psw.

Men har du oprettet den bruger, som du bruger, når du bruger forbindelsen?

You are on the right path...Windows authentication is the network konto and password and mixed uses SQL login.

NT AUTHORITY\NETWORK SERVICE is one of the members of local group IIS_WPG.

The error message just means the account you are using does not have database access.  You could 1) create the account in SQL Server, 2) give it the same access as the "windows konto" had when the system worked. OR reinstall.


ASP.net makes certain assumptions, and gives access to databases based on the identity that the DefaultAppPool is using....usually ASPNET user has these certain access rights, however some applications (.NET Server (RC2)) the IIS DefaultAppPool runs under NETWORK SERVICE instead, so just install the user NETWORK SERVICE and give him the access rights.

OBS: It is called mixed because you use network authority to have access to the server and then can use SQL server authority to get to the database.