Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TechNote: Installing SQL Server 2005 and Visual Studio 2005 Expand / Collapse
Author
Message
Posted Thursday, September 08, 2005 10:00 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 2:23 PM
Points: 254, Visits: 131
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/drussell/technoteinstallingsqlserver2005andvisualstudio2005.asp

Thanks,

David Russell
Oracle Since 1982
SQL Server Since 1998
Post #218246
Posted Wednesday, September 14, 2005 5:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 14, 2005 5:31 AM
Points: 1, Visits: 1

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

Post #219530
Posted Wednesday, September 14, 2005 10:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 22, 2006 2:23 PM
Points: 254, Visits: 1

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 channel9.msdn.com 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!




Cheers,

david russell

Post #219720
Posted Sunday, September 25, 2005 3:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 31, 2010 3:26 PM
Points: 2, Visits: 4

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 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?

 

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

            “Timeout expired.

                      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:

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

 

Michael

Post #223417
Posted Wednesday, September 28, 2005 10:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 31, 2010 3:26 PM
Points: 2, Visits: 4

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” )

            http://forums.asp.net/search/SearchResults.aspx?q=xp+home+edition&f=&u=

 

           

            System Requirements for Visual Studio .NET 2003

            http://msdn.microsoft.com/vstudio/productinfo/sysreqs/default.aspx       

            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?

            http://www.15seconds.com/issue/020118.htm

           

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

            http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=180

 

            Can I run ASP on XP Home Edition?

            http://coveryourasp.com/Snippet.asp?snip=48

 

            p2p Community Forums

            http://p2p.wrox.com/topic.asp?TOPIC_ID=31127

 

            Google Groups

            http://groups.google.com/groups?hl=en&lr=&sa=X&oi=groupst&q=xp+home+edition+asp.net

 

            You have everything you need except for a webserver

            http://groups.google.com/group/microsoft.public.dotnet.framework.aspnet/browse_thread/thread/285853d8efc03efe/436f1b52805ca881?lnk=st&q=xp+home+edition+asp.net&rnum=6&hl=en#436f1b52805ca881

 

            IIS5 & XP home edition

            http://groups.google.com/group/microsoft.public.dotnet.general/browse_thread/thread/14182df1f883a43a/b59d6a0145cdb656?lnk=st&q=xp+home+edition+asp.net&rnum=7&hl=en#b59d6a0145cdb656

 

            WebMatrix from Microsoft

            http://groups.google.com/group/microsoft.public.windowsxp.general/browse_thread/thread/83d4f9ecdfbb5340/432abaa78df9289a?lnk=st&q=xp+home+edition+asp.net&rnum=11&hl=en#432abaa78df9289a

 

            (there is more at google.com/group…)

Post #224475
Posted Wednesday, March 11, 2009 8:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 19, 2009 6:36 PM
Points: 36, Visits: 75
Hi,

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?

Thanks!
Post #673898
Posted Tuesday, March 17, 2009 2:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 06, 2014 11:00 AM
Points: 121, Visits: 306
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?
Post #677855
Posted Tuesday, March 17, 2009 10:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 19, 2009 6:36 PM
Points: 36, Visits: 75
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.
Post #678079
Posted Tuesday, March 17, 2009 10:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 19, 2009 6:36 PM
Points: 36, Visits: 75
Chris Lane (3/11/2009)
Hi,

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?

Thanks!


I am not sure what my problem was, my only guess the configuration hadn't refreshed yet as it now works.
Post #678081
Posted Monday, January 24, 2011 6:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 18, 2014 9:49 AM
Points: 1, Visits: 5
All the components of SQL server 2005 express edition free downloadable from the below link even BI project patch is also available here.

http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
Post #1052319
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse