SQLServerCentral / Discuss Content Posted by David Russell / Article Discussions / Article Discussions by Author / TechNote: Installing SQL Server 2005 and Visual Studio 2005 / Latest Posts

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

manju016 — Mon, 24 Jan 2011 06:27:33 GMT

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

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

Chris Lane-152984 — Tue, 17 Mar 2009 22:05:57 GMT

[quote][b]Chris Lane (3/11/2009)[/b][hr]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![/quote]I am not sure what my problem was, my only guess the configuration hadn't refreshed yet as it now works.

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

Chris Lane-152984 — Tue, 17 Mar 2009 22:00:43 GMT

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.

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

lduvall — Tue, 17 Mar 2009 14:01:38 GMT

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?

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

Chris Lane-152984 — Wed, 11 Mar 2009 20:44:22 GMT

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!

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

Michael Amanti — Wed, 28 Sep 2005 10:14:00 GMT

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

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

Michael Amanti — Sun, 25 Sep 2005 15:35:00 GMT

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 to 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 to do lab exercises at home)...

Is CD # 3 entitled "Visual Studio Team Foundation Server" Required to 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 to the database since they are referring to "Northwind".

When Adding a Connection and I type in "Northwind", then, of course, the response is

“Timeout expired.

The timeout period elapsed prior to 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 to Server Exporer, Select "Data Connection and right click to "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 to directory

" Start | Program Files | MS SQL Server " however, there is no subdirectory named Enterprise Manager

(like with MS SQL Server 2000) and so, I'm going to…

I used a Web URL link to 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 to figure out what directory they ended up in because their installer GUI does not share that info

(I guess MS is trying to keep it a secret... or just trying to tick me off).

Then I spent some time trying to figure out what to do next and when that fails, I always read the directions...

now click on the link above and scroll down to 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" button results in Success (almost)...

Now, back to 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 to 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 to

result after Adding a Connection (right-click on Data Connections & select Add Connection).

When I add a connection to 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 to drag & drop a Table onto the Visual Designer.

Michael

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

david russell-253790 — Wed, 14 Sep 2005 10:30:00 GMT

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!

RE: TechNote: Installing SQL Server 2005 and Visual Studio 2005

Shayne Boyer — Wed, 14 Sep 2005 05:32:00 GMT

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

TechNote: Installing SQL Server 2005 and Visual Studio 2005

debrucer1 — Thu, 08 Sep 2005 22:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/drussell/technoteinstallingsqlserver2005andvisualstudio2005.asp