TechNote: Installing SQL Server 2005 and Visual Studio 2005

Question

Post reply

TechNote: Installing SQL Server 2005 and Visual Studio 2005

debrucer1

SSCertifiable

Points: 5366
More actions
September 8, 2005 at 10:00 pm

#168720

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/drussell/technoteinstallingsqlserver2005andvisualstudio2005.asp
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

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

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

Shayne Boyer SSC Rookie Points: 31 More actions · Answer 1

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

david russell-253790 SSCarpal Tunnel Points: 4042 More actions · Answer 2

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

Michael Amanti SSC Rookie Points: 46 More actions · Answer 3

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.

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

Michael Amanti SSC Rookie Points: 46 More actions · Answer 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 2003^{3,4 “}

³Windows 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…)

Chris Lane-152984 SSChasing Mays Points: 636 More actions · Answer 5

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!

lduvall SSCarpal Tunnel Points: 4869 More actions · Answer 6

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 SSChasing Mays Points: 636 More actions · Answer 7

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 SSChasing Mays Points: 636 More actions · Answer 8

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.

manju016 Grasshopper Points: 18 More actions · Answer 9

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