ASP.NET application having sysadmin privileges

Hi,

I have a following server configuration:
Windows 2003 Web Edition SP2
MS SQL Server Express 2005 SP2
SQL is running as NT AUTHORITY/NETWORK SERVICE
The only authentication method is Windows Authentication
Following logins are created on the SQL server:
BUILITIN\Administrators
NT AUTHORITY\SYSTEM
SERVNAME\SQLServer 2005MSSQLUser$SERVERNAME$MSSQLSERVER
Sa

I have an ASP.NET 2.0 application running on the same machine. The
application pool is configured to use same account as MS SQL (NT
AUTHORITY/NETWORK SERVICE). This account is not a login on the MS SQL
Server but the Web application have sysadmin access to the database! I
use following connection string in the web.config:
Data Source=.;Initial Catalog=DbName;Integrated Security=SSPI;Min Pool
Size=5;
I have also a backup server with almost identical configuration
(Windows 2003 Standard instead of Web Edition) and I must explicitly
configure login for NT AUTHORITY/NETWORK SERVICE to give the web app
access to the database.

Does anybody have a clue what is wrong with my server?

Cheers,

kuba
.

Relevant Pages

  • Re: Sharepoint on 2003 Web Edition
    ... Are you using it in plain vanilla Remote SQL Deployment? ... I already know that Web Edition does not support any db stuff. ... you can use Web Edition as a Front-end server. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Installation Problems WSS
    ... I missed the part about only on SQL if on 2003 web edition! ... I do have SQL 2000 running on a separate server. ... I had tried briefly to install WSS to the SQL server and got a permissions ...
    (microsoft.public.sharepoint.windowsservices)
  • SQL 2005 Express - WS2003 Web Edition
    ... ich hätte eine Frage bzgl. der Lizenzbedingungen der Windows Server 2003 ... Web Edition: die Installation eines SQL Servers auf der Web Edition ist ...
    (microsoft.public.de.german.windows.server.general)
  • ASP.NET application having sysadmin privileges
    ... MS SQL Server Express 2005 SP2 ... SQL is running as NT AUTHORITY/NETWORK SERVICE ... (Windows 2003 Standard instead of Web Edition) ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)