Solved

Installation freezes and I must apply SP4 BEFORE installing?

Posted on 2006-06-30
8
779 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

777 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