• Hi:

     

    I am new here and would be extremely grateful if I could get some help.

     

    I am a student in a series of Microsoft Official Courses.

    I want <st1ersonName>to</st1ersonName> do the Practices and Lab Exercises at Home on

    My PC with Windows XP Home Edition (and the Beta 2

    System Requirements supports Home Edition).

     

    I have the 3 installation CDs for Visual Studio 2005 Beta 2...

     1)  Visual Studio 2005 Team Suite

     2)  SQL Server 2005 Developer Edition

     3)  VS Team Foundation Server

     

    I installed the first 2 (in that order... and also uninstalled #1 and reinstalled)

    And I am having a problem.

    Given my objective (student simply wanting <st1ersonName>to</st1ersonName> do lab exercises at home)...

    Is CD # 3 entitled "Visual Studio Team Foundation Server" Required <st1ersonName>to</st1ersonName> be installed?

     

    MORE DETAILS:

    The MOC course number (book) is for # 2609.

    The Module is Module # 7.

    The Page number is Page # 32.

    This practice is entitled "Using the Data Adapter Configuration Wizard".

    For Step # 2, I had no connection <st1ersonName>to</st1ersonName> the database since they are referring <st1ersonName>to</st1ersonName> "Northwind".

    When Adding a Connection and I type in "Northwind", then, of course, the response is

                “Timeout expired.

                          The timeout period elapsed prior <st1ersonName>to</st1ersonName> completion of the

                          operation   or    The server is not responding.  

    This article... http://blogs.msdn.com/askburton  graciously indicates the next step: Go To...

    Control Panel | Administration Tools | Services and locate the entry named "SQL Server (MSSQLSERVER)" and verify that the "Start Type" = AUTO (and "STATUS" = Started).

     

    Now, when I go <st1ersonName>to</st1ersonName> Server Exporer, Select "Data Connection and right click <st1ersonName>to</st1ersonName> "Add Connection",

    I select the Data Source as "MS SQL Server" and type "localhost" and select "Use Windows Authentication" and now, in the "Connect To Database" pane, the option box gives me 4 options:

    1) master  

    2) model  

    3) msdb  

    4) tempdb. 

    I selected each one... one at a time and clicked "Test Connection" and all succeeded :-).

     

    NEXT PROBLEM “Where is the Northwind Sample Database?”

    Northwind is not there on the option box. I navigated over <st1ersonName>to</st1ersonName> direc<st1ersonName>to</st1ersonName>ry

    " Start | Program Files | MS SQL Server " however, there is no subdirec<st1ersonName>to</st1ersonName>ry named Enterprise Manager

     (like with MS SQL Server 2000) and so, I'm going <st1ersonName>to</st1ersonName>…

    I used a Web URL link <st1ersonName>to</st1ersonName> download the Sample Database files.

    Here, again, is that link: http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

    After downloading the files, I had spend some time <st1ersonName>to</st1ersonName> figure out what direc<st1ersonName>to</st1ersonName>ry they ended up in because their installer GUI does not share that info

    (I guess MS is trying <st1ersonName>to</st1ersonName> keep it a secret... or just trying <st1ersonName>to</st1ersonName> tick me off).

    Then I spent some time trying <st1ersonName>to</st1ersonName> figure out what <st1ersonName>to</st1ersonName> do next and when that fails, I always read the directions...

    now click on the link above and scroll down <st1ersonName>to</st1ersonName> the section entitled "Instructions".

    They provide several strategies for getting the DB files associated (perhaps registered) with VS SQL Server.

    I chose this method…

     

                To install the Northwind database on a default instance on the same computer:

                                        osql -E -i instnwnd.sql

     

                To install the pubs database on a default instance on a different computer:

                                        osql -E -i instpubs.sql

     

    Now when I do "Add Connection" and specify "localhost", Northwind and Pubs appear as options in the Options Box and clicking the "Test Connections" but<st1ersonName>to</st1ersonName>n results in Success (almost)...

     

    Now, back <st1ersonName>to</st1ersonName> the MOC (Microsoft Official Course) lab exercise 2609 Module 7, Page 32.

    In Step 2, the Database Reference is added (successfully).

     

    In Step 3, Server Explorer is used <st1ersonName>to</st1ersonName> browse and view the Northwind "Shippers" table and

    Step 3 explicitly states this should be performed under the Server Explorer <machine-name> node.

    The current problem for me is that this *.dbo does not appear under the <machine-name> node.

     

    The O-Reilly book entitled Mastering Visual Studio .Net (Copyright 2003) Chapter 5 “Databases”

    page 126, figure 5-1 Entitled “Server Explorer”… shows a screen shot of what is supposed <st1ersonName>to</st1ersonName>

    result after Adding a Connection (right-click on Data Connections & select Add Connection).

    When I add a connection <st1ersonName>to</st1ersonName> the Northwind database, I do get some *.dbo entries under the

    Root of the tree, Data Connections.

    However, under the “Servers” node is my machine name and other stuff… but NO “SQL Servers” L

     

    Therefore, I am unable <st1ersonName>to</st1ersonName> drag & drop a Table on<st1ersonName>to</st1ersonName> the Visual Designer.

     

    Michael