I'm having a hard time configureing a web site that I've had running for a couple of years now.
I recently added SQL Express 2008 to the server so I can use the ASP.Net 2.0 login controls, so I had to change from Windows Authentication to Forms Authentication (?) and from there the confusion started.
I'm sure there's a "standard" set of settings that work.
My current settings are giving me a "Login failed for user NT AUTHORITY\NETWORK SERVICE outside our network and Login failed for user "DOMAIN\WEBSERVER$" where DOMAIN is our domain name and WEBSSERVER is our web server name.
I've got these settings now:
IIS:
Directory Security:
Authentication Methods: Enable anonymous access - Checked (IUSR name and password entered)
Authentication Methods: Integrated Windows authentication - Checked
ASP.NET tab:
ASP.NET version: 2.0.50727
ASP.NET Configuration Settings:
General Tab (Connection Parameters):
Data Source=.\SQLExpress;Integr
ated Security=True;User Instance=True;AttachDBFile
name=|Data
Directory|
aspnetdb.m
df
Data Source=INTRASERVE\SQLEXPRE
SS;Databas
e=ASPNETDB
.MDF; Integrated Security=SSPI;
Data Source=INTRASERVE\SQLEXPRE
SS;Initial
Catalog=aspnetdb;Integrate
d Security=True
Authentication tab:
Authentication mode: Forms
Membership provider class: AspNetSqlMembershipProvide
r selected (the only option)
Role management enabled - Not checked
Application tab:
Identity settings, Local impersonation - Not checked
In SQL Server Configuration Manager:
SQL Server Services:
SQL Server (SQLEXPRESS) - Log On As "LocalSystem"
SQL Server Agent (SQLEXPRESS) - Stopped
SQL Server Browser - Log On As "NT AUTHORITY\LOCAL SERVICE"
web.config:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=INTRASERVE\SQLEXPRE
SS;Integra
ted Security=SSPI;AttachDBFile
name=|Data
Directory|
aspnetdb.m
df" providerName="System.Data.
SqlClient"
/>
<add name="testConnectionString
1" connectionString="Data Source=INTRASERVE\SQLEXPRE
SS;Initial
Catalog=aspnetdb;Integrate
d Security=True;Pooling=Fals
e" providerName="System.Data.
SqlClient"
/>
<add name="ConnectionString2" connectionString="Data Source=INTRASERVE\SQLEXPRE
SS;Initial
Catalog=aspnetdb;Integrate
d Security=True" providerName="System.Data.
SqlClient"
/>
<add name="SYEPConnectionString
" connectionString="Data Source=INTRASERVE\SQLEXPRE
SS;Databas
e=ASPNETDB
.MDF; Integrated Security=SSPI;" providerName="System.Data.
SqlClient"
/>
</connectionStrings>
<authentication mode="Forms" />
Help with this really appriciated. This form has to go "live" Monday.
Thanks in advance.
David
