±â¼ú ÀÚ·á½Ç
[Linux] RHEL / CentOS ¿¡ MS SQL ¼³Ä¡ ¹æ¹ý |
---|
Date : 2021-03-29
Name : ¼¹ö¸ó
Hits : 3753
|
¾È³çÇϼ¼¿ä. ÁÖ½Äȸ»ç ¼¹ö¸ó ÀÔ´Ï´Ù. RHEL / CentOS ¿¡ MS SQL ¼³Ä¡ ÇÏ´Â ¹æ¹ý¿¡ ´ëÇؼ ¾Ë¾Æ º¸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
--------------------------------------------------------------------------------------------------------- 1) ¼¹ö Çʼö ±¸¼º ¿ä¼Ò
2) OS ¹öÀü È®ÀÎ ¹æ¹ý cat /etc/centos-release
3) ¸Þ¸ð¸® È®ÀÎ ¹æ¹ý free -h
4) MS SQL ¼³Ä¡ RHEL/CentOS¿¡¼ SQL ServerÀ» ±¸¼ºÇÏ·Á¸é Å͹̳ο¡¼ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇÏ¿© mssql-server ·¹Æ÷¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
* RHEL/Centos7ÀÇ °æ¿ì: curl -o /etc/yum.repos.d/msql-server.repo http://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo
* RHEL/Centos8ÀÇ °æ¿ì: curl -o /etc/yum.repos.d/msql-server.repo http://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo
´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇÏ¿© SQL Server¸¦ ¼³Ä¡ÇÕ´Ï´Ù. sudo yum install -y mssql-server
ÆÐÅ°Áö ¼³Ä¡°¡ ¿Ï·áµÇ¸é mssql-conf setup À» ½ÇÇàÇÏ°í, ÇÁ·ÒÇÁÆ®¿¡ µû¶ó SA ¾ÏÈ£¸¦ ¼³Á¤ÇÏ°í, ¹öÀüÀ» ¼±ÅÃÇÕ´Ï´Ù. sudo /opt/mssql/bin/mssql-conf setup
usermod: ¹Ù²ï Á¡ÀÌ ¾øÀ½
ÀÌ ¼ÒÇÁÆ®¿þ¾îÀÇ À¯·á ¹öÀüÀ» »ç¿ëÇÏ·Á¸é °³ÀÎÁ¤º¸Ã³¸®¹æħÀº ´ÙÀ½ À§Ä¡¿¡¼ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. »ç¿ë Á¶°Ç¿¡ µ¿ÀÇÇϽðڽÀ´Ï±î? [Yes/No]: Yes
SQL ServerÀÇ ¾ð¾î¸¦ ¼±ÅÃÇÕ´Ï´Ù.
¶óÀ̼±½Ì PID°¡ 󸮵Ǿú½À´Ï´Ù. »õ ¹öÀüÀº [Express Edition]ÀÔ´Ï´Ù. ¼³Ä¡°¡ ¿Ï·áµÇ¾ú½À´Ï´Ù. ÀÌÁ¦ SQL Server¸¦ ½ÃÀÛÇÏ´Â ÁßÀÔ´Ï´Ù.
5) SQL ¼³Ä¡ È®ÀÎ ¾Æ·¡ ¸µÅ©·Î À̵¿ÇÏ¿© SSMS ÇÁ·Î±×·¥À» ¼³Ä¡ ÇÕ´Ï´Ù. docs.microsoft.com/ko-kr/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 ¼³Ä¡µÈ ÇØ»ó ¼¹ö¿¡ SQL ÀÎÁõ ¹æ½ÄÀ¸·Î ·Î±×ÀÎ ÇÕ´Ï´Ù. ¼³Ä¡½Ã ÁöÁ¤ÇÑ SA°èÁ¤°ú ºñ¹Ð ¹øÈ£¸¦ ÀÌ¿ëÇÕ´Ï´Ù.
SQL ¹öÀü°ú Á¦Ç°À» È®ÀÎ ÇÕ´Ï´Ù..
6) SQL Á¢¼Ó ºÒ°¡½Ã OS ÀÚüÀÇ ¹æȺ® ¶Ç´Â ¿ÜºÎ ¹æȺ®ÀÇ ¹®Á¦ÀÏ ¼ö ÀÖ½À´Ï´Ù. ¾Æ·¡ ¸í·É¾î¸¦ ÅëÇØ Firewall Á¤Ã¥À» Çã¿ëÇÕ´Ï´Ù.
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
---------------------------------------------------------------------------------------------------------
HPE, ·¹³ë¹ö, µ¨ ¼¹ö, ¿öÅ©½ºÅ×À̼Ç, ±â¾÷¿ë ³ëÆ®ºÏ µî IT Á¦Ç°Àº ¼¹ö¸ó¿¡¼ °ßÀû¹Þ¾Æº¸¼¼¿ä~ Á¦Ç°¿¡ ´ëÇÑ »ó´ãÀ» Èñ¸ÁÇϽøé, 02-2026-5062 or sales@servermon.co.kr·Î ¹®ÀÇ ÁÖ¼¼¿ä. ¼¹ö¸ó¿¡¼ ¿î¿µÇÏ´Â IT ¼îÇθôÀ» ±¸°æÇϽ÷Á¸é, ÇÏ´ÜÀÇ ·Î°í¸¦ Ŭ¸¯ÇØÁÖ¼¼¿ä.
|
Content |
Name |
Date |
Hits |
---|---|---|---|
|
2021-03-29 |
3753 |