This project is read-only.

System.Data.SqlClient.SqlException: Error during logging in for the User 'slickadmin'

Mar 2, 2011 at 8:03 AM

Hey guys,

i am German and my english is not very nice but maybe you understand my Problem and can help me ;)

I tried to install Slick Ticket with the Documentation which is given, but often i get an error. Now i search the second day for the same error.

In German the Warning is the following one:

"Fehler bei der Anmeldung für den Benutzer 'slickadmin'.
Beschreibung: Unbehandelte Ausnahme beim Ausführen der aktuellen Webanforderung. Überprüfen Sie die Stapelüberwachung, um weitere Informationen über diesen Fehler anzuzeigen und festzustellen, wo der Fehler im Code verursacht wurde.

Ausnahmedetails: System.Data.SqlClient.SqlException: Fehler bei der Anmeldung für den Benutzer 'slickadmin'.

Quellfehler:


Zeile 14:     public static bool Exists(dbDataContext db, string _user)
Zeile 15:     {
Zeile 16:         bool exists = (from p in db.users where p.userName.Equals(_user) select p).Count() > 0;
Zeile 17:         HttpContext.Current.Session["isUser"] = exists.ToString();
Zeile 18:         if (!exists)
 

Quelldatei: c:\Inetpub\slickticket\App_Code\Users.cs    Zeile: 16

Stapelüberwachung:


[SqlException (0x80131904): Fehler bei der Anmeldung für den Benutzer 'slickadmin'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +44
   System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +45
   System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +20
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +57
   System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +23
   System.Linq.Queryable.Count(IQueryable`1 source) +240
   Users.Exists(dbDataContext db, String _user) in c:\Inetpub\slickticket\App_Code\Users.cs:16
   MasterPage.Page_Load(Object sender, EventArgs e) in c:\Inetpub\slickticket\MasterPage.master.cs:34
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
"

In English it is something like

"Error durin logging in for the User 'slickadmin'.

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: Error during logging in for the User 'slickadmin'.

Source Error:

line 14:     public static bool Exists(dbDataContext db, string _user)
line 15:     {
line 16:         bool exists = (from p in db.users where p.userName.Equals(_user) select p).Count() > 0;
line 17:         HttpContext.Current.Session["isUser"] = exists.ToString();
line 18:         if (!exists)

Source File: c:\Inetpub\slickticket\App_Code\Users.cs   Line: 16

Stack trace


[SqlException (0x80131904): Fehler bei der Anmeldung für den Benutzer 'slickadmin'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +44
   System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +45
   System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +20
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +57
   System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +23
   System.Linq.Queryable.Count(IQueryable`1 source) +240
   Users.Exists(dbDataContext db, String _user) in c:\Inetpub\slickticket\App_Code\Users.cs:16
   MasterPage.Page_Load(Object sender, EventArgs e) in c:\Inetpub\slickticket\MasterPage.master.cs:34
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627"

 

I hope you understand what i mean.

The only step which differentiate from the Documentation ist the connection string in web.config.

<connectionStrings>
<add name="SlickTicket" connectionString="
Data Source=.\SQLEXPRESS; ;         
Initial Catalog=SlickTicket;
User iD=slickadmin;
password=mypassword"
providerName="System.Data.SqlClient"/>

</connectionStrings>

I try to install slick ticket on a Server 2003 R2 whith SQL Express. I hope you can help me to find my failure.

 

Mar 2, 2011 at 6:42 PM

This is a login error in sql, nothing in the code.  

I would say the first step would be to make sure you can login to SQL Server Management studio with those credentials and browse/modify the SlickTicket database using them - then you can work from there.

Mar 2, 2011 at 10:07 PM

Thanks, i will try tomorrow.

I guess this, so tomorrow i reinstall the virtual machine because i guess something is wrong with the installation of sql server 2008.

I hope it works tomorrow.

Thank you for the reply, if it won't work i write again :)