Lou's lab

Edit the page and hit Save. See syntax for Wiki syntax. Please edit the page only if you can improve it. If you want to test some things, learn to make your first steps on the playground.

====== SQL Server 2022 Developer Edition======
[[sql:sql|{{ :sql:icon.jpg?120|}}]]

===== context=====
dit document beschrijft installatie van MS SQL Server 2022 Developer Edition
===== voorbereiding =====
  - maak een AD gebruiker **sqladmin** aan. \\ Deze gebruiker krijgt later admin rechten op de SQL server

===== stappenplan=====
  - donwload op de [[https://www.microsoft.com/nl-nl/sql-server/sql-server-downloads|Microsoft site]]
  - kies **Download Media**, ISO
  - start de installer, kies **Installation**.
  - **Specify a free edition**: Developer
  - **Instance features**: Database Engine Services
  - **Default instance**
  - **Server Configuration**:
    - SQL Server Agent: **Automatic**
    - SQL Server Database Engine: **Automatic**
    - SQL Server Browser: **Automatic**
  - **Mixed Mode Authentication**
  - **SQL Server administrators**: voeg SQL admin toe (zie: hierboven)
  - reboot de server
  - installeer [[sql:sql_server_management_studio|**SQL Server Management Studio**]]
  - Open **SQL Server Configuration Manager > SQL Server Network Configuration**
    - **Named Pipes**: Enabled
    - **TCP/IP**: Enabled
  - Herstart **MSSQLSERVER** Service
  - start een DOS-as-administrator en voer uit: <code>netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN</code>
  - Installeer [[sql:sql_server_management_studio|SQL Server Management Studio]]
  - reboot de server

<bootnote>Nu heb je een SQL Server waarop vanaf andere hosts kan verbonden worden</bootnote>

===== meer info =====
  * [[https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16|Configure the Windows Firewall to allow SQL Server access]]
{{tag>apps sql microsoft}}

Edit summary

Note: By editing this page you agree to license your content under the following license: CC Attribution-Share Alike 4.0 International