How To Install Msde On Windows 10

Posted : admin On 11.08.2019
How To Install Msde On Windows 10 3,6/5 339 votes
Active2 years, 1 month ago

Then, when the MSDE installation finishes, you should verify that the WSUS instance is running as a Windows NT service. Finally, you must add a security patch to MSDE to protect your WSUS server. Step 2 contains the following procedures: Download and expand the MSDE archive. Install MSDE. Verify that the MSDE database instance is running. This is sort of a reverse-answer to the question, hope it's OK! I couldn't find anyone else mentioning it so hopefully it's alright. Just wanted to say that Dan's solution also works for uninstalling MSDE 2000 from Windows 10. I had a Win7 computer that had MSDE 2000 installed, which I upgraded to Windows 10.

I need to install SQL Server MSDE 2000 SP4 on Windows 10.

I have other machines that run Windows 7 and 8.1 and SQL Server MSDE 2000 works fine (with merge replication configured too).

Now I testing the same scenario with Windows 10, but setup is closing unexpectedly during installation.

I know that this version is very old, but is there a workaround to install it on Windows 10?

Paul White
59.4k16 gold badges308 silver badges487 bronze badges
KronosInfoKronosInfo

2 Answers

I know of no hacks to get SQL Server 2000 to install on an existing Windows 10 installation. There are probably forces against you from both within the setup program (which looks for certain things on the host system) and within the operating system (which prevents many flavors of older software from getting installed, mostly for security reasons but also compatibility, stability, etc). I have tried in the past and even with compatibility override options I came across the same failures every time.

A couple of ideas:

Home
  1. Use a virtual machine. This really is the simplest and most obvious solution. Most (if not all) editions of Windows 10 now support Hyper-V natively; if not, there is always VMWare Workstation (not free) and Oracle VirtualBox (free).
  2. Install 2000 then upgrade. Not really practical, especially if you want to use the Windows 10 installation you already have, but if you were doing this from scratch, you could install XP/Vista/Win7, all of which should allow you to install 2000, and then upgrade. Take care, though, because some methods of upgrading to Windows 10 will relegate all of your programs and services to Windows.old, and they won't run any more.

In either case, firewall the crap out of that thing, because the most recent security patches for 2000 are hard to find, and the ones that I found wouldn't install anyway..

Aaron BertrandAaron Bertrand
161k19 gold badges323 silver badges528 bronze badges

I managed to install following these steps:

Sillunu Oru Kadhal Songs Video Download 3GP, MP4, HD MP4, And Watch Sillunu Oru Kadhal Songs Video. Sillunu oru kadhal hd video songs free download. Sillunu Oru Kaadhal DVDRip 1080p HD Video Songs Download, Sillunu Oru Kaadhal DVDRip Video Songs Download, Sillunu Oru Kaadhal DVDRip HD MP4 1080p Video Songs Free Download. Kuttyweb Songs Kuttyweb Ringtones kuttyweb.in Free Mp3 Songs Download Kuttyweb Video songs Download Kuttyweb Malayalam Songs Kuttywap Tamil Songs Kuttywap Ringtones Kuttyweb Old Malayalam Songs.

  1. Extract SP4
  2. Copy .SP4x86othersqlredis.exe to .originalinstallpathx86other
    (this avoid mdac insall freezing)
  3. Create this folder structure (any place):
    • Microsoft SQL Server80ToolsBinn
    • Microsoft SQL ServerMSSQLBinn
  4. Find out sqlunirl.dll on SP4 path and copy to Binn folder above
  5. Copy dll files on .SP4x86setup to Microsoft SQL ServerMSSQLBinn (folder above)
  6. Copy folder structure (created on step 3) to C:Program Files (x86)
    • Give full access to user logged to **Microsoft SQL Server** folder
  7. Change install compatiblity .originalinstallpathx86setupsetupsql.exe
    • XP SP2
    • Run as administrator

All these steps are in this tutorial: How to install SQL Server 2000 (SP4) on Windows 10

rubStackOverflowrubStackOverflow

protected by Paul WhiteAug 12 '17 at 7:44

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged sql-serverinstallationsql-server-2000windows-10 or ask your own question.

6 Oct 2015CC (ASA 3U)
Step by step process of installation of SQL Server Express 2014 on Windows 10

I had planned installation of SQL Server Express 2014 on Windows 10 PRO OS. During this, I encountered minor road blocks, which I overcame to install SQL Server Express 2014. This article summarizes the step by step process of installing it.

These steps are not confined to SQL Server Express 2014, they are almost similar to other SQL Server Express like 2012, 2008 R2, 2008.

What is Microsoft SQL Server 2014 Express?

MSDN defines it as Microsoft SQL Server 2014 Express is a free, feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

SQL Server 2014 Express can be installed on Windows 10/ Windows 8.1/ Windows 7. These steps are almost similar for any SQL Server Express edition installation on any Windows OS.

Step 1 – Download SQL Server 2014 Express Edition

In this very first step, there was minor road block, from where to download SQL Server installation? Naturally, you will open Download SQL Server Express 2014 link. I tried downloading it, but it wasn’t working. Then, I found this link - The 12 step process to download Microsoft SQL Server Express 2014.

Oh !! 12 steps to be followed for downloading, then think of its installation. Scott Hanselman made our life easy by writing this post Download SQL Server. It has not only 2014 edition but SQL Server 2012, 2008 R2. Everyone just download it from this link, save your time.

I choose this “Express with Advanced Services (SQLEXPRADV)” option because of my need for:

  • Reporting Services
  • Full Text Search
  • Full version of SQL Server 2014 Management Studio which gives us SQL Profiler
  • It gives almost full working SQL Server database system with lots of tools

Download it from Scott’s blog link for Download SQL Server, I used 64 bit download (32 bit also available). It’s around 1+GB. This will take time to download, meanwhile let's see briefly what are other editions of SQL Server 2014 Express.

LocalDB (SqlLocalDB)

LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. It can be bundled with Application and Database Development tools like Visual Studio or embedded with an application that needs local databases.

Express (SQLEXPR)

Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.

Express with Tools (SQLEXPRWT)

This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio. Choose either LocalDB or Express depending on your needs above.

SQL Server Management Studio Express (SQLManagementStudio)

This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2014 Management Studio, etc. Use this if you already have the database and only need the management tools.

How

Step 2 – Extraction of Downloaded Installation EXE

This is fairly simple, double-click downloaded file “SQLEXPRADV_x64_ENU.exe“; it will extract all install files to directory where EXE is present, you can change that also.

Extraction of downloaded SQL Server 2014 Installation file.

Step 3 – Run Setup, Start Installation and Accept Terms

After extraction of EXE, run the Setup and click “New SQL Server Stand alone installation…” from window open. You should and must “Accept terms”.

Accept License Terms

Step 4 – Install Rules and Disable Installed ANTI VIRUS Software

Setup or Install Rules identify potential problems that might occur for SUCCESSFUL installation of SQL Server Express 2014 edition. All rules passed but “Windows Firewall” gives a warning.

“Windows Firewall” warning is related to ANTI VIRUS installation might block enabling ports, settings for SQL Server to use.

DON'T FORGET TO DISABLED ANTI VIRUS PROGRAM. It will save time during the installation process.

I have an anti-virus program with full protection, not thinking much I moved ahead without disabling. Installation was not progressing and was struck at point for hours. So Please Disable IT NOW.

Others might not come across this issue based on anti-virus program and its protection levels, but still do disable it.

Step 5 – Feature Selection

In this step, we can select the features that need to be installed, SQL Server gives us the option Database Engine, Reporting Services (only if you had downloaded appropriate version), Client Tools for connectivity and SQL Management Tools (do select SQL Profiler)

It also displays disk space requirements, make sure you have enough disk space before installation.

Features Selection

Step 6 – Rule “Microsoft .NET Framework 3.5 SP1” Required

I was installing SQL Server 2014 on fresh Windows 10 installation, it’s obviously that .NET Framework is not found. But SQL Server installation needs .NET 3.5 SP1 for proceeding. It is one of the requirements in Hardware and Software Requirements for Installing SQL Server 2014. We face this error as shown:

Two ways we can install .NET 3.5 framework – Download the .NET Framework 3.5 SP1 or Install using “Windows Features”as shown in images below

Enable .NET Framework 3.5 from ‘Turn Windows feature on or off’.

Restart the machine to ensure everything is properly installed (Recommended) and then run “Features Rule” to verify that it's ready to proceed installation.

Verified Microsoft .NET Framework 3.5 SP1 exists.

Step 7 – Instance and Server Configuration Settings

We are installing “SqlExpress” edition, it’s better to keep NAMED instance as “SQLEXPRESS” itself and proceed further.

Server Configuration is important as it deals with account names under which database engine runs. It's better not to play around with these settings. Click NEXT to go ahead.

Server Configuration.

Step 8 – Database Engine Configuration

It's the heart and soul of your SQL Server installation process, database engine is one which does all the work. It’s mainly split into “Server Configurations”, “Data Directories”, “User Instances” and “FILESTREAM”.

Server Configurations deal with “Who can get access to the database engine?”. We have “Windows mode” and “Mixed mode” type of authentication.

Use Mixed Mode authentication mode so that we can Windows mode and sa ‘SQL Server System administrator’ account.

Since we are installing Reporting Services along with SQL Server Express, select “Install and Configure” so that it starts operational.

Reporting Service Configurations.

Step 10 – Installation Progress and Completion

Database engine, reporting service, management tools etc. are successfully installed.

Sql Server Installation Completed.

Install Msde

Step 11 – Connecting to Installed Sql Server Express using Management Tools

After installation, let's open “SQL Server Management Studio” from Program files directory.

Connecting to SQL Server Express using Windows Authentication.
Connecting to SQL Server Express using Mixed Mode Authentication.

It's a bit time-consuming but still installation process is clear and simple.

The post Installation of SQL Server Express 2014 on Windows 10 appeared first on Mithunvp.com.

How Install Windows 10 Free