> For the complete documentation index, see [llms.txt](https://www.pentestwiki.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.pentestwiki.com/home-lab/active-directory/sql-server.md).

# 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="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2FW5VZvCFdhhLQePcAfyJR%2F7.png?alt=media&amp;token=515a732e-87c1-4b0e-9c62-4993b3b1533a" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2F8kkIn47emumnpTQ9FRrj%2F1.png?alt=media&amp;token=b1afb358-595b-4f67-9c42-54102e1bbfaa" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2FvqMMqpNy0ulNBB2iFf6c%2F2.png?alt=media&amp;token=370899e3-d9ea-4c5b-a775-3fbc8f225f14" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2Fh1g5q5wqQ9LKpiBtjXkd%2F4.png?alt=media&amp;token=79164b01-ab2e-4eea-9a88-e21ad439508c" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2FE4pVR5lSG9kYMjHz9oiC%2F5.png?alt=media&amp;token=2818edfa-38a8-4427-8d5b-1fccabd21080" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2FNMNNoWLjS4BPhYmhu8Ia%2F6.png?alt=media&amp;token=7408de5e-5024-4acc-bf08-a3f81229124b" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2F2mKMdLjbyyfh17LDZU5o%2F1.png?alt=media&amp;token=ce59149b-6e43-4556-bea4-64109880833f" 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="https://1400861083-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FiA9eS35C4waXdT3c51bW%2Fuploads%2FLRnojH8wzfRlJ1Fin8LR%2F2.png?alt=media&amp;token=848eb867-1aa9-4244-86a6-295931be94ea" alt=""><figcaption></figcaption></figure>