Error with DB user 'sa'

AHaeusler · August 29th, 2003, 01:55 PM

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

AHaeusler · August 29th, 2003, 03:43 PM

Hi folks,

actually my SQL Server authentication mode was set to "Windows only", so all I had to do to solve this problem was changing the settings for my server in the Enterprise Manager's security tab to "Windows and SQL authentication".

By the way, I also want to say that this is a very great book. It's not so easy finding a book which doesn't tell you how to write code or other fundamental topics at the first 200 pages. Thanks a lot.

Andreas