I created the SQL DB using the script provided. I use a domain joined machine hence i have to create connection entry for windows login as my SQL server is logging on using my local credentials.
Now i am getting error while logging in to login.aspx page. Please help me fix this.
Login failed for user 'DOMAIN\USERNAME$'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DOMAIN\USERNAME$'.
I created the SQL DB using the script provided. I use a domain joined machine hence i have to create connection entry for windows login as my SQL server is logging on using my local credentials.
I used following connection string.
"<connectionstrings>
<add name="InnovationManagement_ConnString" connectionstring="Data Source=localhost;Initial Catalog=LMS;Integrated Security=true;User Instance=true;" providername="System.Data.SqlClient">
</add></connectionstrings>"
Now i am getting error while logging in to login.aspx page. Please help me fix this.
Login failed for user 'DOMAIN\USERNAME$'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DOMAIN\USERNAME$'.
[SqlException (0x80131904): Login failed for user 'DOMAIN\USERNAME$'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +6256873
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1099
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +53
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +248
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +6271738
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +6271704
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +354
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +300
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +54
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +6272968
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +81
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1657
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +88
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6276407
System.Data.SqlClient.SqlConnection.Open() +258
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +53
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +188
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +579
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +181
leave_management.DataAccessLayer.DBTableAdapters.Innovation_Management_UserTableAdapter.GetDataByLogin(String email, String password) in c:\Users\dml2\Downloads\lms release 1.13\leave_management\leave_management\DataAccessLayer\DB.Designer.cs:3460
leave_management.Login.Button_login_Click(Object sender, EventArgs e) in c:\Users\dml2\Downloads\lms release 1.13\leave_management\leave_management\Login.aspx.cs:22
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +140
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981
Last edit: Simon 2013-10-24
<add name="InnovationManagement_ConnString" connectionstring="Data Source=localhost;Initial Catalog=LMS;Integrated Security=true;User Instance=true;" providername="System.Data.SqlClient"></add>
This is the connection string
I am facing a problem. its not working
I need help