Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Installation freezes and I must apply SP4 BEFORE installing?

Posted on 2006-06-30
8
Medium Priority
?
786 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
6 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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

580 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