How to install SQL Server 2005 Express in Windows 8

Question

I tried to install SQL Server 2005 Express SP3 x64 on Windows 8 but the installer gives me an error      An installation package for the product Microsoft SQL server native   Client cannot be found  Try the installation again using a valid copy   of the installation package  sqlncli x64 msi      How can I solve the problem

User · Answer

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

User · Answer

Microsoft says the SQL Server 2005 it s not compatible with Windows 8  but I ve run it without problems  only using SP3  except the installation   After you run the install file SQLExpr exe look for a hidden folder recently created in the C drive  Copy the contents to another folder and cancel the installer  or use WinRar to open the file and extract the contents to a temp folder   After that  find the file sqlncli x64 msi in the setup folder  and run it   Now you are ready the run the setup exe file and install SQL server 2005 without errors

User · Answer

Microsoft SQL Server 2005 Express Edition Service Pack 4 on Windows Server 2012 R2  Those steps are based on previous howto from https   stackoverflow com users 2385 eduardo-molteni   download SQLEXPR EXE run SQLEXPR EXE copy c  generated installation dir to inst bak quit install run inst bak setuip sqlncli x64 msi run SQLEXPR EXE enjoy    This works with Microsoft SQL Server 2005 Express Edition Service Pack 4 http   www microsoft com en-us download details aspx id 184

User · Answer

I had a different experience loading SQL Server 2005 Express on Windows 8   I was using the installer that already had SP4 applied so maybe that explains the difference   The first error I received was when Setup tried to start the SQL VSS Writer   I just told it to Ignore and it continued   I then ran into the same error Sohail had where the SQL Server service failed to start   There was no point in following the rest of Sohail s method since I already was using a SP4 version of SQLServr exe and SQLOS dll  Instead  I just canceled the install rebooted the machine and ran the install again   Everything ran fine the second time around   The place I found Sohail s technique invaluable was when I needed to install SQL Server 2005 Standard on Windows Server 2012   We have a few new servers we re looking to roll out with Windows 2012 but we didn t feel the need to upgrade SQL Server since the 2005 version has all the functionality we need and the cost to license SQL 2012 on these boxes would have been a 5-figure sum   I wound up tweaking Sohail s technique a bit by adding steps to revert the SQLServr exe and SQLOS dll files so that I could then apply SP4 fully   Below are all the steps I took starting from a scratch install of Windows Server 2012 Standard   I hope this helps anyone else looking to get a fully updated install of SQL Server 2005 x64 on this OS    Use Server Manger Add roles and features wizard to satisfy all of SQL s prerequisites   Select the Web Server  IIS  Role Add the following additional Web Server Role Services  note that some of these will automatically pull in others  just accept and move on    HTTP Redirection Windows Authentication ASP NET 3 5  note that you ll need to tell the wizard to look in the  Sources SxS folder of the Windows 2012 installation media for this to install properly  just click the link to  Specify an alternate source path  before clicking Install  IIS 6 Metabase Compatibility IIS 6 WMI Compatibility   Start SQL Server 2005 Install  ignoring any compatibility warnings  If SQL Server service fails to start during setup  leave dialog up and do the following   Backup SQLServr exe and SQLOS dll from C  Program Files Microsoft SQL Server MSSQL 1 MSSQL Binn Replace those two files from a working copy of SQL Server 2005 that already has had SP4 applied Return to setup  hit Retry and setup will now run to completion  Stop SQL Service and restore orignal versions of SQLServr exe and SQLOS dll  or else SP4 doesn t think it is needed in the next step    Install SQL Server 2005 SP4 Install SQL Server 2005 SP4 Cumulative Hotfix 5069  Windows Update wasn t offering this for some reason so I had to download and install manually  If you want the latest documentation  install the latest version of SQL Server 2005 Books Online

User · Answer

install  SQL Express 2005 service pack 4  version  directly      it contains sql Express 2005 inside   dont let the name fool you  runs succesfuly  from my experince

User · Answer

I found that on Windows 8 1 with an instance of SQL 2014 already installed  if I ran the SQLEXPR EXE and then dismissed the Windows  warning this may be incompatible  dialogs  that the installer completed successfully   I suspect having 2014 bits already in place probably helped

[sql-server-2005] How to install SQL Server 2005 Express in Windows 8

Examples related to sql-server-2005

Examples related to sql-server-2005-express