I never could make the connection to the SQL Server work in Chapter 8. I went ahead and created a new database in SQL and I am able to connect to it from within Visual Studio 2005. The SQL Database is setup using Windows Authentication so there is no User ID or Password. I was able to create the Stored Procedures in the ProjectTimeTracker database from within Visual Studio.
I followed instruction for Section 2 page 195 and Section 5 on 196 to setup for connection to SQL Server when running the Time Tracker application.
Values entered for User ID and Password under the "Settings" tab in the Properties of Time Tracker Project are set to 'Nothing'
The Error Message I get when I test the Time Tracker application is:
"Login failed for user 'Nothing'. The user is not associated with a trusted SQL Server connection."
Yet when I test the connection to the SQL Server 'ProjectTimeTracker" database in Server Explorer in Visual Studio the test connection works.
I am sure that it is something to do with the Windows Authentication of SQL Server, but not sure what code to enter to make connection work.
Thanks in Advance