Showing posts with label tool. Show all posts

Monday, March 12, 2012

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>

-->

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

Friday, March 9, 2012

login and web admin tool

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...

Thanks for your help.

Debbie

Here are a few suggestions to start:

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

Buck Woody

login and sql data base

I make my login account data base using the Web Site Administration Tool in the solution explorer i then debug it on my computer and it works fine i can login then i upload my site and sql data base to server and it no longer works i just get this message what do i do can i change theWeb Site Administration Tool so that it uses a access data base by default for login instead of sql.

Server Error in '/KRAZYJON' Application.

Failedto generate a user instance of SQL Server due to afailure in startingthe process for the user instance. The connection will be closed.

Description:Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.

SQLExpress database file auto-creation error:

Theconnection string specifies a local Sql Server Express instance using adatabase location within the applications App_Data directory. Theprovider attempted to automatically create the application servicesdatabase because the provider determined that the database does notexist. The following configuration requirements are necessary tosuccessfully check for existence of the application services databaseand automatically create the application services database:

Ifthe applications App_Data directory does not already exist, the webserver account must have read and write access to the applicationsdirectory. This is necessary because the web server account willautomatically create the App_Data directory if it does not alreadyexist.If the applications App_Data directory already exists, the webserver account only requires read and write access to the applicationsApp_Data directory. This is necessary because the web server accountwill attempt to verify that the Sql Server Express database alreadyexists within the applications App_Data directory. Revoking read accesson the App_Data directory from the web server account will prevent theprovider from correctly determining if the Sql Server Express databasealready exists. This will cause an error when the provider attempts tocreate a duplicate of an already existing database. Write access isrequired because the web server accounts credentials are used whencreating the new database.Sql Server Express must be installed on the machine.The process identity for the web server account must have a localuser profile. See the readme document for details on how to create alocal user profile for both machine and domain accounts.Source Error:

An unhandled exception was generated during the execution of thecurrent web request. Information regarding the origin and location ofthe exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +68

[HttpException (0x80004005): Unable to connect to SQL Server database.]
System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +124
System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +86
System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +25
System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +397

This may cuased by the IIS account (5.0 is ASPNET and 6.0 is NT AUTHORITY\NETWORK SERVICE) used to connect to SQL is not allowed to generate the user instance. I'm sorry to say that I don't know how to give the permission to the account, maybe you can try to add the IIS account to local machine Administrators group. You can also remove the User Instance attribute from your connection string if you do not need it. To learn more about the User Instance, take a look at:

http://msdn2.microsoft.com/en-us/library/ms143684.aspx

And here is a link for SqlConnection.ConnecitonString:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(d=ide).aspx

Logiment explorer

Is logiment log explorer is a good tool for SQL server DBA?
Thanks
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23n6yHgXZHHA.5044@.TK2MSFTNGP05.phx.gbl...
> Is logiment log explorer is a good tool for SQL server DBA?
> Thanks
>
It's one of those tools that if you need it, it's absolutely essential and a
great tool.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com
|||thanks
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:ut$VwjXZHHA.4772@.TK2MSFTNGP05.phx.gbl...
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:%23n6yHgXZHHA.5044@.TK2MSFTNGP05.phx.gbl...
> It's one of those tools that if you need it, it's absolutely essential and
> a great tool.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>

Logiment explorer

Is logiment log explorer is a good tool for SQL server DBA?
Thanks"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23n6yHgXZHHA.5044@.TK2MSFTNGP05.phx.gbl...
> Is logiment log explorer is a good tool for SQL server DBA?
> Thanks
>
It's one of those tools that if you need it, it's absolutely essential and a
great tool.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||thanks
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:ut$VwjXZHHA.4772@.TK2MSFTNGP05.phx.gbl...
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:%23n6yHgXZHHA.5044@.TK2MSFTNGP05.phx.gbl...
> It's one of those tools that if you need it, it's absolutely essential and
> a great tool.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>

Logiment explorer

Is logiment log explorer is a good tool for SQL server DBA?
Thanks"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23n6yHgXZHHA.5044@.TK2MSFTNGP05.phx.gbl...
> Is logiment log explorer is a good tool for SQL server DBA?
> Thanks
>
It's one of those tools that if you need it, it's absolutely essential and a
great tool.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||thanks
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:ut$VwjXZHHA.4772@.TK2MSFTNGP05.phx.gbl...
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:%23n6yHgXZHHA.5044@.TK2MSFTNGP05.phx.gbl...
>> Is logiment log explorer is a good tool for SQL server DBA?
>> Thanks
> It's one of those tools that if you need it, it's absolutely essential and
> a great tool.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com
>

Friday, February 24, 2012

Logging using OnError Event

We are generating log file in our SSIS package by enabling the built-in feature of SSIS tool. We are generating log for the "OnError" event. This also recorded the error/failed task messages in the text file "log.txt". That error information is too complex with more unwanted information like below

-OnError,,,pkgExtract,,,8/30/2006 11:50:04 AM,8/30/2006 11:50:04 AM,-1071636471,0x,An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

OnError,,,pkgExtract,,,8/30/2006 11:50:04 AM,8/30/2006 11:50:04 AM,-1071607780,0x,There was an error with input column "create_user_id" (116) on input "OLE DB Destination Input" (103). The column status returned was: "The value violated the integrity constraints for the column.".

OnError,,,pkgExtract,,,8/30/2006 11:50:04 AM,8/30/2006 11:50:04 AM,-1071607767,0x,The "input "OLE DB Destination Input" (103)" failed because error code 0xC020907D occurred, and the error row disposition on "input "OLE DB Destination Input" (103)" specifies failure on error. An error occurred on the specified object of the specified component.

This is infact not in a better readable format. We also don't want to do our error logging in database.

Is there any way of defining our error log and create error error log with customization of our messages . Can we do it using OnError event handler.

Please help us with some good solution to avoid giving this confused error log messages.

Thanks

Kumaran

Sure, you can do that. Read this: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx

-Jamie

Monday, March 12, 2012

Login Error - Please Help

login and web admin tool

Friday, March 9, 2012

login and web admin tool

login and sql data base

Server Error in '/KRAZYJON' Application.

Failedto generate a user instance of SQL Server due to afailure in startingthe process for the user instance. The connection will be closed.

Logiment explorer

Logiment explorer

Logiment explorer

Friday, February 24, 2012

Logging using OnError Event

Logging query errors

Blog Archive

About Me