TechNote: Installing SQL Server 2005 and Visual Studio 2005

  • debrucer1


    Points: 5366

    Comments posted to this topic are about the content posted at

    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • Shayne Boyer

    SSC Rookie

    Points: 31

    Actually SQL Server 2005 is in Beta 3 and Visual Studio is now RC.

  • david russell-253790

    SSCarpal Tunnel

    Points: 4042

    True fact!  Ironic to me that it took until 9/14 to be published.  it was written almost a month ago, and there are quite a few hurdles to getting it on this site.  Steve Jones was a big help in the formatting and editing; but it still takes time.  Since the article we have installed the June beta on SS 2005 and the August beta on VS 2005 and there is another tech note around here somewhere.  The MSDN site went down yesterday and reported that it might be because of people trying to get the new products   And yes, we were trying to get them, too.

    Coming from an Oracle DBA, the perception of installing Microsoft products is that a monkey could do it.  Apparently this is not true - yet!  Hopefully Gonzo will report otherwise with the latest and greatest!


    david russell

  • Michael Amanti

    SSC Rookie

    Points: 46



    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?



    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...  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:

    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 Amanti

    SSC Rookie

    Points: 46

    The only reason I'm trying to get VS 2005 working on XP Home Edition is because my MOC instructor has been suggesting that ADO and ASP features work on XP Home Edition.

    However, I think there is substantial evidence that ADO and ASP features do not work on XP Home Edition. If anyone has information to suggest otherwise, then please post here.

    Here is some data which supports the notion that ADO and ASP features do not work on XP Home Edition...

    After installing Visual Studio 2005, Start | All Programs | Visual Studio 2005 Beta 2 | Documentation.

                Navigate to VS | Introducing VS | Installation & Setup | VS Hardware Requirements

                See:      “Operating System        Windows® 2000, Windows XP, or Windows Server 20033,4 “

                    3Windows XP Home Edition does not support local Web application development;

                Local Web application development is only supported in the Professional or Server versions of Windows.


                Microsoft ASP.NET (search for “XP Home Edition” )




                System Requirements for Visual Studio .NET 2003


                Windows XP Home Edition¹

                ¹ Limited functionality. Visual Studio .NET 2003 does not support creating ASP.NET Web applications or

                  ASP.NET XML Web services when using Windows XP Home Edition.

                ² ASP.NET Web applications and XML Web services can only be hosted on Windows XP Professional,

                  Windows 2000, and Windows Server 2003.


                Running IIS on Windows XP Home Edition?



                Question: How can I install Personal Web Server (PWS) onto Windows XP Home edition?



                Can I run ASP on XP Home Edition?



                p2p Community Forums



                Google Groups



                You have everything you need except for a webserver



                IIS5 & XP home edition



                WebMatrix from Microsoft



                (there is more at…)

  • Chris Lane-152984

    Mr or Mrs. 500

    Points: 576


    I created a local user account just like the article stated with the same name as in the article, problem is I can't browse the Reports Server websites in IIS without being asked for a password and when I use the password of the local service account it doesn't accept it. What am I doing wrong, or what user name/password do I need to use to connect to the report manager web sites?


  • lduvall

    SSCarpal Tunnel

    Points: 4866

    Please forgive me if my question is completely idiotic. I've been running SQL Server 2005 for nearly a year now and I've used BIDS to develop SSIS packages, etc... I am trying to figure out why the Visual Studio 2005 installation that automatically got installed doesn't include the normal VS templates like "Windows application," etc... I assume it's a licensing issue? Is that because you're only allowed BIDS or SQL-related VS development tools? Is there a way to install the default VS templates to this installation?

  • Chris Lane-152984

    Mr or Mrs. 500

    Points: 576

    BIDs is not the same as the full blown Visual Studio.Net that is why you don't see those other templates when using BIDS. You need Visual Studio to do web and windows development.

    Hope that helps.

  • Chris Lane-152984

    Mr or Mrs. 500

    Points: 576

    Chris Lane (3/11/2009)


    I created a local user account just like the article stated with the same name as in the article, problem is I can't browse the Reports Server websites in IIS without being asked for a password and when I use the password of the local service account it doesn't accept it. What am I doing wrong, or what user name/password do I need to use to connect to the report manager web sites?


    I am not sure what my problem was, my only guess the configuration hadn't refreshed yet as it now works.

  • manju016


    Points: 18

    All the components of SQL server 2005 express edition free downloadable from the below link even BI project patch is also available here.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply