Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Installation freezes and I must apply SP4 BEFORE installing?

Posted on 2006-06-30
8
Medium Priority
?
785 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

963 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