Connecting To SQL Express 2005 Via Web.Config File In Visual Studio 2003

Hi

 I am following a project to build a small E-Commerce site from a book I have purchased and I have having problems connecting to the SQL Database with the code supplied.

The book is Apress Beginning ASP.NET 1.1 E-Commerce

http://www.amazon.co.uk/Beginning-ASP-Net-1-1-E-Commerce-Professional/dp/1590592549/ref=sr_11_1/202-7684451-7995058?ie=UTF8&qid=1193780707&sr=11-1

 The code added to the Web.Config file is :

<configuration>

<appSettings>

<add key="ConnectionString" value="Server=(local)NetSDK;Integrated Security=True;Initial Catalog=JokePoint" />

</appSettings>

 

The connection details are in a class file called Catalog.vb and is as follows

Imports System.Data.SqlClientPublic Class Catalog

Public Shared Function GetDepartments() As SqlDataReader

'Create the connection objectDim connection As New SqlConnection(connectionString)

'Create and initialize the command objectDim command As New SqlCommand("GetDepartments", connection)

command.CommandType = CommandType.StoredProcedure

'Open the connection

connection.Open()

'Return a SqlDataReader to the calling functionReturn command.ExecuteReader(CommandBehavior.CloseConnection)

End Function

Private Shared ReadOnly Property connectionString() As String

GetReturn ConfigurationSettings.AppSettings("ConnectionString")

End GetEnd Property

End Class

 The error is.....
Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'. 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: Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'.

Source Error:







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


Source File: C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb    Line: 17

Stack Trace:







[SqlException: Cannot open database "JokePoint" requested by the login. The login failed.
Login failed for user 'MachineNameASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
JokePoint.Catalog.GetDepartments() in C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb:17
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:MyCommerceSiteJokePointUserControlsDepartmentsList.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()


The connection tests ok in Visual Studio 2003. All permissions are set using SQL Management Studio Express 2005.

The book is using SQL 2000, I have been trying different connection syntax's in the Web.Config file all day and now I have a big headache. I know its something simple, can anyone please advise ?

Thanks in advance.

 

Mark