Unable to install SQL server 2019 Developer Edition

Question

Unable to install SQL server 2019 Developer Edition

Josef Szeliga 6

After having issues installing MSSQLLocalDB (SQL Express) 2019 I decided to try and install the SQL Server Developer edition.

During the install I received this error message.

"TITLE: Microsoft SQL Server 2019 Setup

The following error has occurred:

The service cannot be started, either because it is disabled or because it has no enabled devices associated with it."

There is no additional information in the event logs.

Here is the final install window.

SQL 2019 Install error message

The error mentions that a service has not started. But it doesn't name the service or why it didn't start.

I've attached the detail and summary log setup files. Summary.txt and Detail.txt

Is anyone able to point me in the right direction to resolve this issue?

Josef

3 answers

Your answer

Answer 1

As you are using the named instance "SQL2019" the service would have been called "MSSQL$SQL2019". You can check in the Windows Event logs for the Service Control Manager for any problems with starting that service.

Additionally, depending on how far the service started, you may have an error log from SQL Server that would be included in the "C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20230511_195313" directory. If it has been created, that may give a clue as to why the service was not able to completely start.

Answer 2

ZoeHui-MSFT 41,491

Hi @Josef Szeliga,

Try to open Services Window, by writing services.msc into Start->Run and hit Enter.

When window appears, then find SQL Browser service, right click and choose Properties, and then in dropdown list choose Automatic, or Manual, whatever you want, and click OK. Eventually, if not started immediately, you can again press right click on this service and click Start.

If this do not work, please check the error log to see if there is any useful messages.

Regards，

Zoe Hui

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

Josef Szeliga 6 Reputation points

2023-05-13T06:34:02.95+00:00

I first uninstalled SQL server 2019. Then rebooted.

When I opened up the services, I set SQL Bowser Service to manual. Then selected "Start".

Application Event Log error is "The SQL configuration for SQL is inaccessible or invalid."

I then tried to instal SQL Server 2019 again. And got this error.

This time nothing was able to be installed.

Detail.txt

Summary.txt

Logs attached.
Josef Szeliga 6 Reputation points

2023-05-13T09:20:36.87+00:00

I started the browser but when i tried to connect to the Server via Managment studio i received this error. "The certificate chain was issued by an authority that is not trusted."

I check the signature on SQL installation ISO. It did not contain a signature block.

I uninstalled 2019 SQL server then went to a different Microsoft location to download the 2019 developer server again. This was in instal from the web with the installer choosing all the settings.

Everything seemed ok. No errors during the installation.

Setup.exe is signed by Microsoft. It all appears to be running.

I tried to connect SSMS and received the same error.

I also checked the certification manager. I'm not sure whether SQL should be in there, but in any case, it is not listed.

I do not appear to be getting any traction here.

The new Setup.exe is signed by Microsoft.

I'm surprised that the instal worked from the web as I did not at any time have to state, "run as administrator".

Configuration manager shows everything is running. But SQL browser is not running under the same account as the other services.

There is a line in the log "Received cancel request from user, skipping remaining scheduled actions" At no time did I cancel anything. The instal completed by itself. See attached logs.

Summary.txt

Detail.txt
Josef Szeliga 6 Reputation points

2023-05-14T11:09:27.16+00:00

I uninstalled SQL Server 2019 from my machine and installed it using a different method.

A web installed that first download the file then starts the install.

I was not prompted for any input and a name so a default named instance was created.

No errors were thrown. I have no idea what the Admin password is or if i have been added as an administrator.

I was not prompted for this during the instal. When I try to attach with SSMS I get an error

"A connection was established with the server, but then an error occurred during the login process.

The certificate chain was issued by an authority that is not trusted."

Event errors as follows.

The certificate received from the remote server was issued by an untrusted certificate authority.

Because of this, none of the data contained in the certificate can be validated. The TLS connection request has failed.

The attached data contains the server certificate.

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

Windows.SecurityCenter.SecurityAppBroker

and APPID

Unavailable

to the user NT AUTHORITY\SYSTEM SID (S-1-5-18) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable).

This security permission can be modified using the Component Services administrative tool.

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

Windows.SecurityCenter.WscBrokerManager

and APPID

Unavailable

to the user NT AUTHORITY\SYSTEM SID (S-1-5-18) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable).

This security permission can be modified using the Component Services administrative tool.

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

Windows.SecurityCenter.WscDataProtection

and APPID

Unavailable

to the user NT AUTHORITY\SYSTEM SID (S-1-5-18) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable).

This security permission can be modified using the Component Services administrative tool.

Answer 3

Finally found the answer on StackOverflow. Seems that after 2022 Microsoft has started encrypting data between any clients (including SSMS) and the server. On a personal server it's unlikely to find any certificate from a trusted certificate authority.

So, i just checked this box when connecting to the server.

If you're using SQL Management Studio, please goto connection properties and click on "Trust server certificated"

Seems to work fine. Haven't tried connecting with EF yet.

More here on stackoverflow.

https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn

Share via

Unable to install SQL server 2019 Developer Edition

3 answers

Your answer