Can slick ticket work with sql 2008 R2server

Dec 6, 2010 at 3:40 AM

I am using windows 2008 R2 with sql 2008 r2. i have done all the thing mantioned in documentation. when browsing the site getting the following error message:

 

 

Server Error in '/support' Application.

Login failed for user 'IIS APPPOOL\Support'.

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 'IIS APPPOOL\Support'.

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: e:\Support\App_Code\Users.cs    Line: 16

Stack Trace:

[SqlException (0x80131904): Login failed for user 'IIS APPPOOL\Support'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +578
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +88
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6265031
   System.Data.SqlClient.SqlConnection.Open() +258
   System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +65
   System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +33
   System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +32
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +63
   System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +45
   System.Linq.Queryable.Count(IQueryable`1 source) +310
   Users.Exists(dbDataContext db, String _user) in e:\Support\App_Code\Users.cs:16
   MasterPage.Page_Load(Object sender, EventArgs e) in e:\Support\MasterPage.master.cs:34
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428



Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955

<!-- [SqlException]: Login failed for user 'IIS APPPOOL\Support'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) at System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() at System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Linq.Queryable.Count[TSource](IQueryable`1 source) at Users.Exists(dbDataContext db, String _user) in e:\Support\App_Code\Users.cs:line 16 at MasterPage.Page_Load(Object sender, EventArgs e) in e:\Support\MasterPage.master.cs:line 34 at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.default_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\support\0b2b21d8\b255d15b\App_Web_7g9f2f6q.10.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->

 

Coordinator
Dec 9, 2010 at 4:48 PM

It appears you are trying to login to SQL with the IIS APPPOOL\Support account, does it have privileges in SQL?