Install SQL Server without Azure Anything

Julie Campbell 0 Reputation points
2024-10-19T02:06:06.7766667+00:00

I am trying to install an instance of SQL Server Express 2022 on my Windows 11 machine, for my own use locally. I tried SQLLocalDB and that had it's own myriad of issues. I had to disable my Windows firewall which is disturbing. Then it almost gets through the installation, but then it fails on

image.png

Pressing Help give this:

image.png

Which leads to this link:

https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/connect?view=sql-server-ver16&tabs=windows

image.png

I do not care about Azure anything at this point. I want a local database accessed only from the machine it is on. What do I do for a simple, local database installation that actually sets up the engine?

SQL Server Other
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2024-10-19T04:22:11.57+00:00

    I do not care about Azure anything at this point.

    You are on the wrong track; MS SQL Server on-premise has (nearly) nothing to do with Azure cloud.

    Read the error message and do what it says.

    https://learn.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver16


  2. Julie Campbell 0 Reputation points
    2024-10-19T04:40:57.5066667+00:00

    Thanks for trying, not the answer, but I do appreciate your effort. The link from "help" on the error message is bad. The answer was a combination of two things:

    1. Windows 11, had to change the partition size from 4096 to 4095
    2. Use this for the engine service NT AUTHORITY\NETWORK SERVICE Both are mentioned here, I tried them at the same time.https://stackoverflow.com/questions/19538089/wait-on-the-database-engine-recovery-handle-failed-check-the-sql-server-error-l
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.