I am having a problem in regrads to connecting to the sql server in page 91 step 15 after compiling I am getting the following error. I would be grateful if someone can tell me why I am having this problem. I have followed the book sentence by sentence.
The application builds perfctly but when execute ity gives the following error


Harry


Server Error in '/WroxJokeShop' Application.
--------------------------------------------------------------------------------

Login failed for user 'Fury7'. Reason: Not associated with a trusted SQL Server connection.
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 'Fury7'. Reason: Not associated with a trusted SQL Server connection.

Source Error:


Line 14:
Line 15: ' Open the connection
Line 16: connection.Open()
Line 17:
Line 18: ' Return a SqlDataReader to the calling function


Source File: C:\BigECom\WroxJokeShop\BuisnessObjects\Catalog.vb Line: 16

Stack Trace:


[SqlException: Login failed for user 'Fury7'. Reason: Not associated with a trusted SQL Server connection.]
   System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnection.Open()
   WroxJokeShop.Catalog.GetDepartments() in C:\BigECom\WroxJokeShop\BuisnessObjects\Catalog.vb :16
   WroxJokeShop.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:\BigECom\WroxJokeShop\UserControls\DepartmentsLi st.ascx.vb:44
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Check out my reply to in this topic. It believe it may prove useful to you.

http://p2p.wrox.com/topic.asp?TOPIC_ID=1702