Login Error - Please Help

I have created a site using a login through the Asp.net Admin Website Tool. Through numerous tries of trying to get this to work, I am now receiving the following error "Login failed for user 'app1_lakeshore'." Can anyone help?

Here is my werbconfig file:

<?xmlversion="1.0"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<

configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<

appSettings>

<

addkey="/LMCIntranet" />

</

appSettings>

<

connectionStrings>

<

removename="LocalSqlServer"/>

<

addname="LocalSqlServer"connectionString="Data Source=sqldev2.aurora.org;Initial Catalog=Lakeshore;Persist Security Info=True;User ID=app1_lakeshore"providerName="System.Data.SqlClient"/>

</

connectionStrings>

<

system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

<

authenticationmode="Forms" />

<

customErrorsmode="Off"/>

<

compilationdebug="true"strict="false"explicit="true"/>

<

pages>

<

namespaces>

<

clear/>

<

addnamespace="System"/>

<

addnamespace="System.Collections"/>

<

addnamespace="System.Collections.Specialized"/>

<

addnamespace="System.Configuration"/>

<

addnamespace="System.Text"/>

<

addnamespace="System.Text.RegularExpressions"/>

<

addnamespace="System.Web"/>

<

addnamespace="System.Web.Caching"/>

<

addnamespace="System.Web.SessionState"/>

<

addnamespace="System.Web.Security"/>

<

addnamespace="System.Web.Profile"/>

<

addnamespace="System.Web.UI"/>

<

addnamespace="System.Web.UI.WebControls"/>

<

addnamespace="System.Web.UI.WebControls.WebParts"/>

<

addnamespace="System.Web.UI.HtmlControls"/>

</

namespaces>

</

pages>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

-->

</

system.web>

<

system.net>

<

mailSettings>

<

smtpfrom="vanessa.edwards@.aurora.org">

<

networkhost="localhost"password=""userName="" />

</

smtp>

</

mailSettings>

</

system.net>

</

configuration>

It looks like you need to add the password to the connection string. Without the TrustedConnection parameter it will be using SQL Server authentication (authenticating against a SQL Server user ID). If you want to use the current Windows id you'll want to set TrustedConnection=true and omit username and password from the connection string.|||

I am still getting the same error - what am I doing wrong?

<

addname="LocalSqlServer"connectionString="Data Source=sqldev2.aurora.org;Initial Catalog=Lakeshore;Persist Security Info=True;User ID=app1_lakeshore;Password=need1004"providerName="System.Data.SqlClient"/>

</

connectionStrings>

Please HELP!!!!

|||

Hi,

I suggest you try to create a UDL file to test the connection to see if the username and password can work.

Here are the steps

1. Create a normal Text file.
2. Rename it to .udl extension.
3. Double click on that file and a Data Link Properties dialog box will be show.
4. Select the provider and data source, specify username and password, and click the Test Connection button for test.