How to install SQL server and SSMS on Windows 10?

Question

How to install SQL server and SSMS on Windows 10?

Mandeep Singh 0

I have downloaded the correct files from this link and trying to install a SQL server Express edtion alongwith SQL server management studio but the installation is getting failed evertime I try to install.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

SQL Server Management Studio - As soon as I begin the installation, the sytem recognises the click and asks me to run the .exe file and then nothing happens after a few seconds. I have tried this over 20 - 25 times now. I have chcked if any antivirus is trying to stop the program but cannot find the reason why it is constantly being stopped from the background process. I feel that some unwanted program is trying to stop the installation, but I don;t know how to figure that out.

Also, I have installed the most recent .NET framework as well but that did not help either.

For SQL Server Express setup I am getting this error:

TITLE: SQL Server Setup failure.

SQL Server Setup has encountered the following error:

Exception has been thrown by the target of an invocation..

For help, click: https://go.microsoft.com/fwlink?LinkID=2209051&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xE8049925%25400x42B4DED7

BUTTONS:

OK

Can someone help me to get it installed on my laptop?

Thank you

Greg Low 2,105 Reputation points Microsoft Regional Director

2024-03-03T10:40:31.16+00:00

For SSMS, I know it might sound like a dumb question, but have you tried waiting for quite a while? I find it often takes quite a long time before it starts doing things. Otherwise, it's generally pretty good to install. I presume you downloaded the setup file and are just running that as a local admin?

For SQL Express, every time you try to install, there is an installation log file that's created. Please check what's in that log file. Also, with this one, did you install while downloading, or use the download media option? If the latter, how did you open it? I've seen people with these errors from using zip files to unzip the ISO and it's not done a good job. Generally, make sure you've just mounted it.
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator

2024-03-03T11:01:59.21+00:00

Is this your private laptop or a corporate machine? In the latter case, your IT department may have installed roadblocls.

It is not unheard of people having problems with installing SSMS, although I'm not sure that I recognise this exact description.

When it comes to SQL Express, in C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log there is a folder for each installation attempt. nnn here depends on the version of SQL Server you are trying to install. It would be 160 for SQL 2022 and 150 for SQL 2019.

The files of most interest are Summary.txt and details.txt.
Mandeep Singh 0 Reputation points

2024-03-04T02:28:31.6666667+00:00

Hi Erland,

This is my personal laptop and there are no restrictions whatsoever as far as I know.

For the Microsoft SQL Server I have attached the Detail file and Summary of the installation failure.

The other file with all the details has been attached for your reference.Detail.txt
Mandeep Singh 0 Reputation points

2024-03-04T02:52:24.4333333+00:00

Hi Greg,

For Sql Server Management Studio - Yes I did give ample time for the software to run but clearly nothing happens and in a normal scenario I should see the installation window with the next steps to proceed ahead, but it is not happening at all. I have checked other resources online as well but I am not able to install either of these on my laptop.

The installation window simply doesn't show up anywhere.

For SQL Server I have tried all the ways to download the file separately as well via the Media option but the installation fails in the end. I have attached extra snapshots below to show you the exact process.

SSEX Step 1.PNG

SSEX Step 2.PNG
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator

2024-03-04T22:15:59.4333333+00:00

I see various exception starting with

"Microsoft.SqlServer.Configuration.UIExtension.StartAction"

Which tells me very little.

I also see:

SQL Server Setup was not able to find product updates within 5 minutes. This can happen when there are Internet or network issues.

But I can't imagine that this would cause Setup to fail. Normally, it just reports that it could not find any updates and moves on.

I get the feeling that your .NET installation is not in best shape. That could explain why the installation of SSMS also fails.

Would creating a VM be an option for you? That may be easier than trying to repair your machine.
Mandeep Singh 0 Reputation points

2024-03-05T03:25:48.8666667+00:00

Hi @Erland Sommarskog

I have the latest version of .NET framework installed on my machine.

For installing VM, how do I initiate the process, any resources or tips to install it succesffully?

Thanks
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator

2024-03-05T22:22:15.4333333+00:00

Yeah, you may have it installed, but it may still be messed up.

The SQL Server tag is not the place to learn about using virtual machines. What come closest at hand may be Hyper-V, since it comes with Windows, but myself I use VMware. VMWare comes with a license fee, although the Workstation Player is free for non-commerical use.

Yes, if you have never used virtual machines before, I understand that there is a hurdle. But I have found virtual machines to be a tremendous asset. If I want to try some software that I find a little suspicious, for instance a beta version, I install it a VM so I don't mess up my main machine.

2 answers

Your answer

Greg Low 2,105 Reputation points Microsoft Regional Director

2024-03-03T10:40:31.16+00:00

For SSMS, I know it might sound like a dumb question, but have you tried waiting for quite a while? I find it often takes quite a long time before it starts doing things. Otherwise, it's generally pretty good to install. I presume you downloaded the setup file and are just running that as a local admin?

For SQL Express, every time you try to install, there is an installation log file that's created. Please check what's in that log file. Also, with this one, did you install while downloading, or use the download media option? If the latter, how did you open it? I've seen people with these errors from using zip files to unzip the ISO and it's not done a good job. Generally, make sure you've just mounted it.
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator

2024-03-03T11:01:59.21+00:00

Is this your private laptop or a corporate machine? In the latter case, your IT department may have installed roadblocls.

It is not unheard of people having problems with installing SSMS, although I'm not sure that I recognise this exact description.

When it comes to SQL Express, in C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log there is a folder for each installation attempt. nnn here depends on the version of SQL Server you are trying to install. It would be 160 for SQL 2022 and 150 for SQL 2019.

The files of most interest are Summary.txt and details.txt.
Mandeep Singh 0 Reputation points

2024-03-04T02:28:31.6666667+00:00

Hi Erland,

This is my personal laptop and there are no restrictions whatsoever as far as I know.

For the Microsoft SQL Server I have attached the Detail file and Summary of the installation failure.

The other file with all the details has been attached for your reference.Detail.txt
Mandeep Singh 0 Reputation points

2024-03-04T02:52:24.4333333+00:00

Hi Greg,

For Sql Server Management Studio - Yes I did give ample time for the software to run but clearly nothing happens and in a normal scenario I should see the installation window with the next steps to proceed ahead, but it is not happening at all. I have checked other resources online as well but I am not able to install either of these on my laptop.

The installation window simply doesn't show up anywhere.

For SQL Server I have tried all the ways to download the file separately as well via the Media option but the installation fails in the end. I have attached extra snapshots below to show you the exact process.

SSEX Step 1.PNG

SSEX Step 2.PNG
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator

2024-03-04T22:15:59.4333333+00:00

I see various exception starting with

"Microsoft.SqlServer.Configuration.UIExtension.StartAction"

Which tells me very little.

I also see:

SQL Server Setup was not able to find product updates within 5 minutes. This can happen when there are Internet or network issues.

But I can't imagine that this would cause Setup to fail. Normally, it just reports that it could not find any updates and moves on.

I get the feeling that your .NET installation is not in best shape. That could explain why the installation of SSMS also fails.

Would creating a VM be an option for you? That may be easier than trying to repair your machine.
Mandeep Singh 0 Reputation points

2024-03-05T03:25:48.8666667+00:00

Hi @Erland Sommarskog

I have the latest version of .NET framework installed on my machine.

For installing VM, how do I initiate the process, any resources or tips to install it succesffully?

Thanks
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator

2024-03-05T22:22:15.4333333+00:00

Yeah, you may have it installed, but it may still be messed up.

The SQL Server tag is not the place to learn about using virtual machines. What come closest at hand may be Hyper-V, since it comes with Windows, but myself I use VMware. VMWare comes with a license fee, although the Workstation Player is free for non-commerical use.

Yes, if you have never used virtual machines before, I understand that there is a hurdle. But I have found virtual machines to be a tremendous asset. If I want to try some software that I find a little suspicious, for instance a beta version, I install it a VM so I don't mess up my main machine.

Answer 1

Mandeep Singh 0

Hi @ZoeHui-MSFT I have changed the installation path as well (C:\Program Files\Microsoft SQL Server) but it's still showing me the same error. Sending a screeenshot of the problem below, does this indicate something in particular that can rectify this?

Process Monitor log file.PNG

Process Monitor log file

0 comments

Answer 2

Hi @Mandeep Singh,In the detail log we can see this.

Unable to open hklm registry key SOFTWARE\Microsoft\MSSQLServer, error The system cannot find the file specified.

If you use installationpath C:\SQL2022\Express_ENU\x64\setup, system may not find key.

Please try with default path like C:\Program Files\Microsoft SQL Server.

If this does not work, try to first clear uninstall the SQL Server and then install it.

Use process monitor to get more trace with setup.exe&senarioengine.exe.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Share via

How to install SQL server and SSMS on Windows 10?

2 answers

Your answer