Solved

Installation freezes and I must apply SP4 BEFORE installing?

Posted on 2006-06-30
8
778 Views
Last Modified: 2010-10-05
As i am trying to install developer edition on a windows XP with Sp2 it freezes while:

"setup is starting the server and installing your chosen configuration"

I checked the app log and found:

"You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with this version of Windows. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/default.mspx"

I found this article related:

http://support.microsoft.com/kb/841375/en-us

It tells I must install the latest service pack to solve the issue.

The question is:

How can I apply the latest service pack BEFORE installing SQL server?

I cannot install sql server because I have not installed the SP4, and I cannot apply the SP, because I have not installed SQL server.

"This is a snake biting its tail" my father would have said.

Thanks,

Diego
0
Comment
Question by:dsuarez1
  • 4
  • 2
8 Comments
 
LVL 41

Expert Comment

by:ralmada
ID: 17032660
And if you try enabling port 1433 and 1434 (MS-SQl reserved port) in your firewall configuration.
0
 
LVL 1

Author Comment

by:dsuarez1
ID: 17039358
Ralmada,

I had already enabled port 1433. After enabling port 1434 and cnfgsvr.exe still no luck.

Any other idea?

Diego
0
 
LVL 1

Author Comment

by:dsuarez1
ID: 17039382
Ralmada,

I also tried disabling windows firewall. Still the same.

Diego
0
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 1

Author Comment

by:dsuarez1
ID: 17039393
This is the kind of thing that I cannot understand from MS.

How is it possible that this happens?

When they were testing XP SP2, didn't they have the budget to test the effects of the SP on installing such an important product like sql-server 2000?

Why is it so difficult to find a workaround?

Do I have to license sql-server 2005 to solve the issue?
0
 
LVL 41

Accepted Solution

by:
ralmada earned 500 total points
ID: 17052101
I know it might sound silly but did you try to install sp4 directly?

You can get it from here

http://www.microsoft.com/downloads/details.aspx?displaylang=es&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5#QuickInfoContainer

It says it doesn't require SQL server in order to install it.

Hope to help.
0
 
LVL 1

Author Comment

by:dsuarez1
ID: 17407254
ralmada,

I could not install sp4 before installing Sql Server.

Diego
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now