question

ChetanJawale-9207 avatar image
0 Votes"
ChetanJawale-9207 asked ErlandSommarskog answered

Not able to install SSMS ?

I want to use SQL in my local machine for learning.

I have downloaded and installed successfully the latest version of SQLEXPRADV_x64_ENU.exe ( 15.0.2000.5 )

While I'm trying to install SSMS (18.10) , User Account Control dialogue box appears, I select Yes and nothing happens.


Below is the log file for the same :

[3E28:3E0C][2021-10-20T18:50:54]i001: Burn v3.8.1128.0, Windows v6.3 (Build 9600: Service Pack 0), path: C:\Users\Chexki\Downloads\DB_Healthcare_Project\SSMS-Setup-ENU.exe, cmdline: ''
[3E28:3E0C][2021-10-20T18:50:54]e000: Error 0x80040154: Failed to load manifest as XML document.
[3E28:3E0C][2021-10-20T18:50:54]e000: Error 0x80040154: Failed to load manifest.
[3E28:3E0C][2021-10-20T18:50:54]e000: Error 0x80040154: Failed to initialize core.


I have researched a lot but could not get any possible solution to this.
This is fresh and first time ever mssql installation on my laptop.

It would be great if someone can help me.

sql-server-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Is this your private machine, or is it in a corporate network? I get the feeling of an over-zealous anti-malware program here.

0 Votes 0 ·

Hi,
This is my private machine, windows home official is installed and no other anti-virus than windows defender is installed.

0 Votes 0 ·

Hi @ChetanJawale-9207,

As Erland mentioned, please check the anti-virus software in your server. Download the SSMS 18.10 again from this link, then run the SSMS setup file as administrator. Suggest you reading the blog that provide the detail steps about SSMS installation.

I have downloaded and installed successfully the latest version of SQLEXPRADV_x64_ENU.exe ( 15.0.2000.5 )

The latest version of SQL server is SQL 2019 CU13 (15.0.4178.1). Refer to SQL Server Versions and Build Numbers.


0 Votes 0 ·

Hi,
This is my private machine, windows home official is installed and no other anti-virus than windows defender is installed.

I have followed your given steps as well.
same thing happening.

0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I see that you are running Windows 8.1. This is listed as a supported version for SSMS 18.10. Nevertheless, you may want to try SSMS 17.9.1 instead: https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15#1791

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.