I am lost. Everything is great up til now. I was not sure if this chapter actually creates a sql database on the server (I am using my laptop for this development training) or I was supposed to create one first. SO I created a sql database ProjectTimeTracker with one table and tried to get an open connection (SQL Server) but keeps coming up "login failed. User not associated with trusted sql server connection". Now when I loaded SQL from VS2005, I never set up any logins, passwords nor have I done such on the laptop. I keep playing with Sql Config Mgr and get no where. Please help, so I can move forward.
Thank you, Russ

Hi Russ,

Please post the piece of code you wrote to connect to your server.
Also, are you using SQL Server Express 2005 or another version of SQL Server.

Answer those two and we take it from there...

Good luck


__________________________
I'm just a noob

If you are referring to SQL Server 2005 and you installed it on your laptop, you can click on the Start button, go to All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager. Next, click on SQL Server 2005 Network Configuration and expand it and then click on Protocols for SQLExpress. In the details pane, right click on Named Pipes and select Enable from the context menu. Now click on SQL Server 2005 Services in the tree view and then right click on SQL Server (SQLExpress) in the details pane and select Restart from the context menu.

Thearon

The version of Sql is what was delivered with VisualStudio. It shows protocols of MSSQL & SQLEXPRESS. Can't tell which it is using. I already Enabled Named Pipes and restarted but didn't help. When I change the code to IntegratedSecurity=True it will open. I assume this is because my laptop does not require passwords?? The code I used was verbatim from Chapter 8 using Login & Password from textboxes.

If you are able to use integrated security then you should do so.

Thearon