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 ersonName>toersonName> 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 ersonName>toersonName> do lab exercises at home)...
Is CD # 3 entitled "Visual Studio Team Foundation Server" Required ersonName>toersonName> be installed?
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 ersonName>toersonName> the database since they are referring ersonName>toersonName> "Northwind".
When Adding a Connection and I type in "Northwind", then, of course, the response is
The timeout period elapsed prior ersonName>toersonName> 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 ersonName>toersonName> Server Exporer, Select "Data Connection and right click ersonName>toersonName> "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:
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 ersonName>toersonName> direcersonName>toersonName>ry
" Start | Program Files | MS SQL Server " however, there is no subdirecersonName>toersonName>ry named Enterprise Manager
(like with MS SQL Server 2000) and so, I'm going ersonName>toersonName>…
I used a Web URL link ersonName>toersonName> 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 ersonName>toersonName> figure out what direcersonName>toersonName>ry they ended up in because their installer GUI does not share that info
(I guess MS is trying ersonName>toersonName> keep it a secret... or just trying ersonName>toersonName> tick me off).
Then I spent some time trying ersonName>toersonName> figure out what ersonName>toersonName> do next and when that fails, I always read the directions...
now click on the link above and scroll down ersonName>toersonName> 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" butersonName>toersonName>n results in Success (almost)...
Now, back ersonName>toersonName> 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 ersonName>toersonName> 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 ersonName>toersonName>
result after Adding a Connection (right-click on Data Connections & select Add Connection).
When I add a connection ersonName>toersonName> 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 ersonName>toersonName> drag & drop a Table onersonName>toersonName> the Visual Designer.