Login failed for user Admin.

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;Initial
Catalog=Northwind;Data Source=LocalNet;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=LocalNet;Use Encryption for
Data=False;Tag with column collation when possible=False

Any ideas on how to solve this problem?

Cheersi could find out

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;password=******;Initial
Catalog=Northwind;Data Source=LocalNet;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=LocalNet;Use Encryption for
Data=False;Tag with column collation when possible=False

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.

login and web admin tool

I've been trying to get my website back up and running, I lost the db and will have to reconstruct that but in the meantime I would like to get the website back in operation right now I have the following problems.

I receive an error message when trying to create a new user in the web admin tool. see 1A

or I receive another error message saying that the administrator is not authorized to sign onto the db

and I seem to have the authorization settings incorrect for the hashed password settings I had...

Ive looked back through my notes and the last time this happened I created a new database with the web admin tool but my settings are such that this still doesn't eliminate the error messages. Right now the website is in a cannot find server mode.

Thanks for your help.

Debbie

1A Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.Administration.WebAdminMembershipProvider.CallWebAdminMembershipProviderHelperMethodOutParams(String methodName, Object[] parameters, Type[] paramTypes) at System.Web.Administration.WebAdminMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) at System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() at System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Still having a problem. does anyone answer these forums? Since Microsoft is not offering support on VWD 2005 and it sends you to these forums for answers don't you think that they should staff the forums? for at least a modicum of support. Who - ever heard of a product being released without a repair system in place? HELP REQUESTED.

Here are a few suggestions to start:

http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx

Buck Woody

login and web admin tool

I've been trying to get my website back up and running, I lost the db and will have to reconstruct that but in the meantime I would like to get the website back in operation right now I have the following problems.

I receive an error message when trying to create a new user in the web admin tool. see 1A

or I receive another error message saying that the administrator is not authorized to sign onto the db

and I seem to have the authorization settings incorrect for the hashed password settings I had...

Ive looked back through my notes and the last time this happened I created a new database with the web admin tool but my settings are such that this still doesn't eliminate the error messages. Right now the website is in a cannot find server mode.

Thanks for your help.

Debbie

1A Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.Administration.WebAdminMembershipProvider.CallWebAdminMembershipProviderHelperMethodOutParams(String methodName, Object[] parameters, Type[] paramTypes) at System.Web.Administration.WebAdminMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) at System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() at System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Still having a problem. does anyone answer these forums? Since Microsoft is not offering support on VWD 2005 and it sends you to these forums for answers don't you think that they should staff the forums? for at least a modicum of support. Who - ever heard of a product being released without a repair system in place? HELP REQUESTED.

Here are a few suggestions to start:

http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx

Buck Woody