having a HECK of a time with ANP.NET 2.0 Application services

[Leo Selmani]

Hello. I am tryin gto setup Application services to make use of SQL server
for user authentication. I have tried to follow the steps that Microsoft
recommends, but to no avail. I keep getting the same error every time I try
to connect from the Web Site Administration Utility. The error that pops up
is:

The connection name 'LocalSqlServer' was not found in the applications
configuration or the connection string is empty.
(C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line
131)

Arghh....I check my IIS, it is using .NET 2.0. I check my machine.config and
I changed this section as per Scott Guthrie's recommendation:

<connectionStrings>
<remove name="AspNetSqlProvider"/>
<add name="AspNetSqlProvider"
connectionString="Data Source=localhost;
Initial Catalog=aspnetdb;
UID=sa;
PWD=********;
Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>
I ran the aspnet_regsql tool and it created the sql database. Beautiful.
I used sa as it has the most power in SQL. Great.
I attemtp to connect: Cr4p. No luck.
I have no problem connecting to SQL from my .NET project which I am working
on, but not from the management interface when I am trying to setup a forms
based security site as per MSs walkthrough tutorial:
http://msdn2.microsoft.com/en-us/library/879kf95c(VS.80).aspx

 

[stevefromoz]

Hey Leo,

Have you tried it with the 'integrated security=true' property remoed from
the conxn string? This iwll try to connect using a windows identity (most
likely network service) which i am assuming doesn't have access to your DB.
If you remove this, or set it to false, you're saying the connection should
use the UID & PWD you've supplied (ie the sa account).

Cheers,

Steve.