View Single Post
  #3 (permalink)  
Old August 22nd, 2010, 11:28 AM
martycom martycom is offline
Registered User
 
Join Date: Jul 2010
Posts: 3
Thanks: 1
Thanked 1 Time in 1 Post
Default Ch12 pg 406-407 (Try it Out)access db within VWD Reply to Thread

Hi Imar,

1. Which version of SQL Server are you using? Use "SQL Server Configuration Manager" from the start menu to find out. MS SQL Server 2008 R2
2. What's the name of your SQL Instance? I guess the Server Browser should not be in stopped state.
Name State Start Mode
SQL Server Browser Stopped Other
SQl Server(SQLEXPRESS) Running Automatic
SQL Server Agent(SQLEXPRESS) Stopped Other

Server .SQLExpress connected as MARTY-PC\MARTY

3. What happens when you create a brand new web site, add App_Data and a SQL Server database and open that. Does that work? (App_Data folder was automatically created on new.) I dragged the book download PlanetWrox. mdf file in , doubled clicked it, and got the same error message.

4. Are you trying this out with your own database, or with one from the download?

5. Can you log in using SQL Server Management Studio?
Yes! I have 2 registered server names: ./SQLExpress and MARTY-PC\SQLExpress Both connections tested ok using Windows Authentication.
Reply With Quote