Hi all together,
I've got a problem with executing the user registration of chaper 5. When I click on 'Register', I get the following error message (I don't know if it exactly sounds like this in english, because I use the german language version of the .NET framework):
Code:
System.Data.SqlClient.SqlException: Error at login for user 'sa'.
Reason: Not assigned to trusted DB server connection.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, String tableName)
in c:\inetpub\wwwroot\thePhile\modules\core\dbobject.cs:line 138
at Wrox.WebModules.Accounts.Data.AccountsTool.GetStateList()
in c:\inetpub\wwwroot\thePhile\modules\accounts\accountsdata\accountstool.cs:line 18
at Wrox.WebModules.Accounts.Business.AccountsTool.GetStates()
in c:\inetpub\wwwroot\thePhile\modules\accounts\accountsbusiness\accountstool.cs:line 14
at Wrox.ThePhile.WebModules.Accounts.Web._new.Page_Load(Object sender, EventArgs e)
in c:\inetpub\wwwroot\thePhile\modules\users\new.aspx.cs:line 61
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
As I am very new to MS SQL Server, I don't know what to do. The help file tells something like trusted connections are only necessary for Windows authentication. But actually the user 'sa' uses a SQL authentication, I think.
I'd be glad if anybody could help me, since this isn't the first problem I got with chapter 5 and I'm hanging on this chapter nearly two weeks now
.
Thanks
Andreas
Error with DB user 'sa'
Linear Mode
