Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5366
  • Last Modified:

Error when installing SQL 2005 in Windows 8 Pro PC

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
rayluvs
Asked:
rayluvs
  • 7
1 Solution
 
tipsybroomCommented:
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
 
rayluvsAuthor Commented:
Didn't know that.

So I have to download SP3 or SP4 64bit version of SQL Server 2005 Developer Edition?
0
 
rayluvsAuthor Commented:
Just tried it in SP3 and both files not present.SQLSERVR.EXE and SQLOS.DLL.

will proceed and find sp4 to try.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rayluvsAuthor Commented:
found this link... which one should we download:

http://www.microsoft.com/en-us/download/details.aspx?id=7218
0
 
rayluvsAuthor Commented:
Note: download "Download SQLServer2005SP4-KB2463332-x64-ENU.exe" and still same problem.
0
 
rayluvsAuthor Commented:
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
 
rayluvsAuthor Commented:
We'll proceed close the question since no answer and award accordingly.
0
 
rayluvsAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now