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.