Exception with SQL connection
-
I keep getting this same exception when i try to connect to a sql database: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 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 'NT AUTHORITY\ANONYMOUS LOGON'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 dev.Random1.Page_Load(Object sender, EventArgs e) in random1.aspx.cs:27 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 any ideas? This is a work-related project so i need to figure out the error quickly. -- Steve
-
I keep getting this same exception when i try to connect to a sql database: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. 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 'NT AUTHORITY\ANONYMOUS LOGON'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 dev.Random1.Page_Load(Object sender, EventArgs e) in random1.aspx.cs:27 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 any ideas? This is a work-related project so i need to figure out the error quickly. -- Steve
You need to either log in with an account that has permission to use SQL Server, or you need to set up the permission in SQL Server for the account you want to use. I'm not really a fan of allowing Anonymous access to things in a business senario so I would suggest that you log in using an appropriate account. As you are accessing this through an ASP.NET application I am curious as to what your security settings are, if you check the box that says allow anonymous access then it will access resources through a special ASP.NET account.
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.