?
Solved

Error when installing SQL 2005 in Windows 8 Pro PC

Posted on 2013-02-02
8
Medium Priority
?
5,126 Views
Last Modified: 2013-02-28
We are trying to install Ms 2005 SQL on a Windows 8 Pro PC and keep getting an error at the end of the installation:

------------------------------------------------------------
TITLE: Microsoft SQL Server 2005 Setup
------------------------------------------------------------

The SQL Server service failed to start. For more information,
see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

sqlerrr
What are we missing?

(PC is:  Intel Core i7, 8gb Ram, 1tr hdisk)
0
Comment
Question by:rayluvs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
8 Comments
 
LVL 7

Accepted Solution

by:
tipsybroom earned 1000 total points
ID: 38847493
First of all: SQL Server 2005 and any previous version is NOT supported on Windows 8/Windows Server 2012



I had the same problem. But I also had to perform additional steps. Here is what I did.

Perform the following steps (Only 64bit version of SQL Server 2005 Developer Edition tested on Windows 8 Pro 64bit)

    Extract sqlncli.msi / sqlncli_x64.msi from SP3 or SP4. I did it from SP4
    Install sqlncli
    Start SQL Server 2005 Setup
    During setup I recieved an error The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    Don't click cancel yet. From an installation of SQL Server 2005 SP3 or SP4 copy SQLSERVR.EXE and SQLOS.DLL files and put them in your SQL install folder.
    Click RETRY

For STEP 5 above: Although I didn't try looking into SP4 / SP3 setup for SQLSERVR.EXE and SQLOS.DLL but if you don't have an existing installation of SQL Server 2005 SP3/SP4 then maybe try looking into the SP3/SP4 EXE (Compressed file). I am not sure if this may help. In any case you can create a VM and install SQL Server 2005 with SP3/Sp4 to copy the files for Windows 8
0
 

Author Comment

by:rayluvs
ID: 38847559
Didn't know that.

So I have to download SP3 or SP4 64bit version of SQL Server 2005 Developer Edition?
0
 

Author Comment

by:rayluvs
ID: 38847834
Just tried it in SP3 and both files not present.SQLSERVR.EXE and SQLOS.DLL.

will proceed and find sp4 to try.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:rayluvs
ID: 38847846
found this link... which one should we download:

http://www.microsoft.com/en-us/download/details.aspx?id=7218
0
 

Author Comment

by:rayluvs
ID: 38848624
Note: download "Download SQLServer2005SP4-KB2463332-x64-ENU.exe" and still same problem.
0
 

Author Comment

by:rayluvs
ID: 38848653
Ok... on both SP3 and SP4 we could install sqlncli.msi (sqlncli_x64.msi was not present on none).  But the files  SQLSERVR.EXE and SQLOS.DLL files were not found.

However we did find the  SQLOS.DLL (link http://opendll.net/index.php?file-download=sqlos.dll&arch=64bit&version=2007.100.1600.22&dsc=SQLOS-Hosting-DLL) but haven't been able to find SQLSERVR.EXE.

Please advice.
0
 

Author Comment

by:rayluvs
ID: 38938887
We'll proceed close the question since no answer and award accordingly.
0
 

Author Closing Comment

by:rayluvs
ID: 38938904
Unfortunately there was no more support to clear our question but it seems that the sql2005 is not supported should be awarded.

Thankyou anyways.
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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

719 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