Dear All,

I am a newbie and just trying to get started however this is what i got instead.

I thought it should be up and running when i deploy the official WROX sample code.



The error occurred in:
http://localhost/thephile/Default.aspx

Error Message:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

Error Stack:
System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
   at System.Data.SqlClient.SqlConnection.Open()
   at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, Int32& rowsAffected) in C:\wrox\ThePhileVB\WebModules\Core\DBObject.vb:lin e 53
   at Wrox.WebModules.Polls.Data.Questions.GetCurrentId( ) in C:\wrox\ThePhileVB\WebModules\Polls\Polls.Data\Que stions.vb:line 158
   at Wrox.WebModules.Polls.Business.Question.GetCurrent Id() in C:\wrox\ThePhileVB\WebModules\Polls\Polls.Business \Question.vb:line 227
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\wrox\ThePhileVB\WebModules\Polls\Poll.ascx.vb:l ine 260
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\wrox\ThePhileVB\WebModules\Polls\Poll.ascx.vb:l ine 62
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()

How did you set up your SQL Server installation?

try to configure the SqlServer to accept both Sql server and windows authentication

Ahmed Ali
Software Developer