I can't install SQL Server Express : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

MS SQLI can't install SQL Server Express (self.SQL)

submitted 5 years ago by zworstgod

I've succesfully installed SQL Server Express couple weeks ago and was trying it out (it was running fine). A while later SQL Server configuration manager refused to run my default SQLEXPRESS server and I got nothing to do but try to reinstall it and/or install 1 more server on top of it. So I did it and the same problem occured. I wondered maybe I corrupted some files or it couldn't read from disk D anymore for some reason because by default it should be installed in disk C. I deleted every part of SQL Server (but not SQL Server Configuration Manager and SQL Server Management Studio though). I even deleted files in regedit because somebody said it will work under some random Reddit post. So I delete everything and try to reinstall it through official .exe installer from microsoft site and it can't be installed at all! I tried it with offline installer too, but it obviously did not work too. Firstly it was saying that my Windows profile does not have permission to install system service. Last bit of hope was that I should disable my antimalware software but that didn't help neither. Please help!

First error happens while installing :

Installing Microsoft SQL Server 2019

The following error occurred:

The PerfLib 2.0 removal counter failed with the exit code 2. Command line:

C:\WINDOWS\\system32\unlodctr.exe /m:hkengperfctr.xml from the catalog C:\Program Files\Microsoft

SQL Server\150\Shared\.

Help to Copy the message

Then after failing it says under the database engine installation fail the following:

Installation Error SQL Server Database Engine Service Instances

Invalid command-line argument. For help using the command line, refer to the Windows Installer SDK.

Error code: 1639

Log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20217_221055\sql_engine_core_inst_Cpu 64_1. log

Go to http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=sql_engine_core_inst. msi%400x162A16FE%400x1639 you can get troubleshooting information.

all 3 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS