Solved

Installation freezes and I must apply SP4 BEFORE installing?

Posted on 2006-06-30
8
780 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
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.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

809 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