Is the connection not working because I'm using SQL Express 2005 or something else. Because it does not work for me.

I used the SQL Server Management Studio Express and gave myself all rights everywhere, still didn't let me login.

[email protected]

I just replied to this other post which may offer a solution to the problem you are having. http://p2p.wrox.com/topic.asp?TOPIC_ID=44780

Thearon

I found the same thing, it was disabled.
I enabled it and am at the stage to figure out how to restart it.

One thing though, I have been using windows Authentication, does this matter regarding the login based on your DB migration?

Feeling a little lost here.

ps. Suggestion, having a place to capture video of problem and submit for review, and have your post back the fix. What you think?

[email protected]

While in SQL Server Configuration Manager, click on SQL Server 2005 Services in the tree node and then in the display list, right click on SQL Server and choose Restart from the context menu. This will restart SQL Server 2005.

You can use either SQL Server Authentication or Windows Authentication for the examples in the book.

Thearon