Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Never mind :)


"Brad Coble" <bcoble@xxxxxxxxxxxxxxxxx> wrote in message
news:%23ou5%23kvYGHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
Hy!

I have an IIS 6 (asp.net 2) website on a win2003 server. It also has
SQL2005. I am trying to use the membership controls to create a user. I
have the aspnetdb database created. I have added the 'NT AUTHORITY\NETWORK
SERVICE' account to the db and placed it in the dbo role.The web.config
file is below. Integrated security is checked in IIS. SQL is set to use
both SQL and windows security.

What am i missing?

Thanks!!

<?xml version="1.0" encoding="utf-8"?>

<configuration
xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0";>

<connectionStrings>

<add name="aspnetdb"
connectionString="Server=localhost;Database=aspnetdb;Trusted_Connection=True"
/>

</connectionStrings>

<system.web>

<compilation debug="true" />

<membership defaultProvider="CustomSQLMembershipProvider">

<providers>

<add connectionStringName="aspnetdb" name="CustomizedProvider"

type="System.Web.Security.SqlMembershipProvider" />

<add applicationName="/" connectionStringName="aspnetdb"
name="CustomSQLMembershipProvider" type="CustomSQLMembershipProvider" />

</providers>

</membership>

<roleManager enabled="true"

defaultProvider="CustomizedRoleProvider">

<providers>

<add name="CustomizedRoleProvider"

type="System.Web.Security.SqlRoleProvider"

connectionStringName="aspnetdb" />

</providers>

</roleManager>

<pages theme="default" />

<authentication mode="Forms" />

</system.web>

</configuration>




.

Relevant Pages

  • Login failed for user NT AUTHORITYNETWORK SERVICE.
    ... SERVICE' account to the db and placed it in the dbo role.The web.config file ... Integrated security is checked in IIS. ... SQL is set to use both SQL ...
    (microsoft.public.sqlserver.security)
  • Re: ado vs oledb
    ... Most mainstream SQL databases have "native" .NET providers using managed ... attempting to use a generic OLEDB provider--if you care about performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • using Integrated Security SSPI with User ID
    ... I'm trying to use integrated security with a User Id and password to ... The SQL Server administrators insist that I ... use the intergrated security option in the connection string, ...
    (microsoft.public.dotnet.framework.adonet)
  • Using Integrated Security for Accessing SQL on Remote Server
    ... I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet). ... I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ASP.net hosting?
    ... manager access to the SQL databases - you must go through their interface. ... problem for writing in database on web. ... writing data back to database. ... The one I have seen are poor and also alot of providers ...
    (microsoft.public.dotnet.framework.aspnet)