# SQL Server

{% hint style="info" %}
SQL Server 2022를 기준으로 작성되었습니다.
{% endhint %}

1. [SQL Server 2022 다운로드 페이지](https://www.microsoft.com/ko-kr/sql-server/sql-server-downloads)에 접속하여 Express 버전 다운로드

<figure><img src="/files/6iygMtWeBc1xMVxoPRrF" alt=""><figcaption></figcaption></figure>

2. SQL Server 2022 Express Edition Custom 다운로드

<figure><img src="/files/2pDO6jZvQ5KuhwTSi2fo" alt=""><figcaption></figcaption></figure>

3. New SQL Server standalone installation or add features to an existing installation 클릭

<figure><img src="/files/wt0l3UPYcSjyJjmbTebi" alt=""><figcaption></figcaption></figure>

4. 인스턴스 이름 변경 필요 시 변경

<figure><img src="/files/ZxYW0uX3yO8ot0Xm8IVb" alt=""><figcaption></figcaption></figure>

5. SPN을 등록할 주체의 계정정보 입력

<figure><img src="/files/36ZrG19Z8PfxKXa7gde2" alt=""><figcaption></figcaption></figure>

6. 혼합 인증 모드 및 sa 계정 패스워드 설정

<figure><img src="/files/zkHPQZk4STXKHPGIAtas" alt=""><figcaption></figcaption></figure>

7. `SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS > TCP/IP` 활성화

<figure><img src="/files/1Fose9Kx2Ja38JVipjjW" alt=""><figcaption></figcaption></figure>

9. IP Address 탭에서 로컬 및 루프백 IP 항목 활성화 및 TCP 동적 포트 1433으로 설정

* `루프백 IP 항목` : 활성화 및 TCP Dynamic Ports 1433 설정
* `로컬 IP 주소` : 활성화 및 TCP Dynamic Ports 1433 설정
* `IPAll > TCP Dynamic Ports` : 1433

<figure><img src="/files/WOrpkK5toN2XUTer0uE1" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://www.pentestwiki.com/home-lab/active-directory/sql-server.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.