º¸¾È ¾÷µ¥ÀÌÆ®¸¦ ¼³Ä¡Çϰųª Á¦°ÅÇÏ·Á°í ÇÒ ¶§ SQL Server 2005 ¼­ºñ½º ÆÑ 2°¡ ¾÷µ¥ÀÌÆ®µÇÁö ¾ÊÀ½

±â¼ú ÀÚ·á: 957008 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

Çö»ó

Microsoft SQL Server 2005 ¼­ºñ½º ÆÑ 2¿ë º¸¾È ¾÷µ¥ÀÌÆ®¸¦ ¼³Ä¡ÇÏ·Á°í Çϸé Microsoft SQL Server 2005°¡ Á¦´ë·Î ¾÷µ¥ÀÌÆ®µÇÁö ¾Ê½À´Ï´Ù. ÀÌ ¹®Á¦´Â º¸¾È ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ ·Ñ¹é ÇÁ·Î¼¼½º°¡ ÇØ´ç ·ÎÄà SQL Server ¼­ºñ½º ±×·ì¿¡¼­ SQL Server 2005 ¼­ºñ½º °èÁ¤À» Á¦´ë·Î Á¦°ÅÇÏÁö ¸øÇϱ⠶§¹®¿¡ ¹ß»ýÇÕ´Ï´Ù.

¿øÀÎ

ÀÌ ¹®Á¦´Â º¸¾È ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ ·Ñ¹é ÇÁ·Î¼¼½º°¡ ÇØ´ç ·ÎÄà SQL Server ¼­ºñ½º ±×·ì¿¡¼­ SQL Server 2005 ¼­ºñ½º °èÁ¤À» Á¦´ë·Î Á¦°ÅÇÏÁö ¸øÇϱ⠶§¹®¿¡ ¹ß»ýÇÕ´Ï´Ù. »ç¿ë ±ÇÇÑÀº ¼­ºñ½º °èÁ¤ÀÌ ¾Æ´Ñ ·ÎÄà ¼­ºñ½º ±×·ì¿¡ ºÎ¿©µË´Ï´Ù. µû¶ó¼­ ¼­ºñ½º´Â ÇÊ¿äÇÑ ¸®¼Ò½º¿¡ ¾×¼¼½ºÇÒ ¼ö ¾øÀ¸¸ç ½ÃÀÛµÇÁö ¸øÇÕ´Ï´Ù.

ÇØ°á ¹æ¹ý

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
  1. ÄÄÇ»ÅÍ¿¡ ÀÖ´Â SQL Server 2005 ¼­ºñ½º ±×·ìÀ» ½Äº°ÇÕ´Ï´Ù. ÀÌ·¸°Ô ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
    1. ½ÃÀÛ, ½ÇÇàÀ» Â÷·Ê·Î Ŭ¸¯Çϰí compmgmt.msc¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù.
    2. ·ÎÄà »ç¿ëÀÚ ¹× ±×·ìÀ» È®ÀåÇÑ ´ÙÀ½ ±×·ìÀ» Ŭ¸¯ÇÕ´Ï´Ù.
  2. SQL Server 2005 ¼­ºñ½º ±×·ìÀº "SQLServer2005"·Î ½ÃÀ۵˴ϴÙ. °¢ ±×·ìÀ» ½Äº°ÇÑ ÈÄ µÎ ¹ø Ŭ¸¯ÇÏ¿© ±×·ì ±¸¼º¿ø ÀÚ°ÝÀ» È®ÀÎÇÕ´Ï´Ù. ±×·ì ±¸¼º¿ø ÀÚ°ÝÀÌ ºñ¾î ÀÖÀ¸¸é 3´Ü°è·Î À̵¿ÇÏ°í ±×·ì ±¸¼º¿ø ÀÚ°ÝÀÌ ºñ¾î ÀÖÁö ¾ÊÀ¸¸é ´ÙÀ½ ±×·ìÀ» È®ÀÎÇÕ´Ï´Ù.
  3. ¼­ºñ½º Microsoft Management Console(MMC) ½º³ÀÀο¡¼­ SQL Server 2005 ¼­ºñ½º¿¡ ´ëÇÑ ¼­ºñ½º °èÁ¤À» È®ÀÎÇÕ´Ï´Ù.

    ¼­ºñ½º ½º³ÀÀÎÀ» ¿­·Á¸é ½ÃÀÛ, ½ÇÇàÀ» Â÷·Ê·Î Ŭ¸¯Çϰí services.msc¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù.
  4. SQL Server ¼­ºñ½º À̸§Àº "SQL Server"·Î ½ÃÀ۵˴ϴÙ. ¿¹¸¦ µé¾î "SQL Server (MSSQLSERVER)"´Â SQL Server ±âº» ÀνºÅϽºÀÇ SQL ¿£Áø ¼­ºñ½ºÀÔ´Ï´Ù. ÀÌ ¼­ºñ½º°¡ SQL Server 2005ÀÇ ¼­ºñ½ºÀÎÁö È®ÀÎÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
    1. ¼­ºñ½º¸¦ ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߷ΠŬ¸¯ÇÑ ´ÙÀ½ ¼Ó¼ºÀ» Ŭ¸¯ÇÕ´Ï´Ù.
    2. ÀÌ ¼­ºñ½ºÀÇ ÇÁ·Î±×·¥ ÆÄÀÏÀ» ã½À´Ï´Ù. ÀÌ ÆÄÀÏÀº ½ÇÇà ÆÄÀÏ °æ·Î ¿µ¿ª¿¡ Ç¥½ÃµË´Ï´Ù.
    3. ÆÄÀÏ À̸§, ¼Ó¼º ¹× ¹öÀüÀ» ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߷ΠŬ¸¯ÇÕ´Ï´Ù. ÆÄÀÏ ¹öÀüÀº "9.0" ¶Ç´Â "2005.90"À¸·Î ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.
  5. ÄÄÇ»ÅÍ °ü¸® MMC ½º³ÀÀο¡¼­ 2´Ü°è¿¡¼­ ãÀº ¼­ºñ½º ±×·ì À̸§À» µÎ ¹ø Ŭ¸¯ÇÕ´Ï´Ù. ¼­ºñ½º °èÁ¤ Ç׸ñÀÌ ¼­ºñ½º ±×·ì¿¡ ¾ø´ÂÁö È®ÀÎÇÕ´Ï´Ù. ¼­ºñ½º °èÁ¤ Ç׸ñÀÌ ¾øÀ¸¸é Ãß°¡¸¦ Ŭ¸¯ÇÏ°í ¼±ÅÃÇÒ °³Ã¼ À̸§À» ÀÔ·ÂÇϽʽÿÀ. »óÀÚ¿¡ »ç¿ëÀÚÀÇ °èÁ¤ À̸§À» ÀÔ·ÂÇÑ ´ÙÀ½ È®ÀÎÀ» Ŭ¸¯ÇÕ´Ï´Ù.

    Âü°í ÄÄÇ»ÅÍ °ü¸® MMC ½º³ÀÀÎÀ» ¿­·Á¸é ½ÃÀÛ, ½ÇÇàÀ» Ŭ¸¯Çϰí compmgmt.msc¸¦ ÀÔ·ÂÇÑ ÈÄ Enter ۸¦ ´©¸¨´Ï´Ù.
  6. ¼­ºñ½º MMC ½º³ÀÀο¡¼­ SQL Server ¼­ºñ½º¸¦ ½ÃÀÛÇÕ´Ï´Ù.

    Âü°í ¼­ºñ½º ½º³ÀÀÎÀ» ¿­·Á¸é ½ÃÀÛ, ½ÇÇàÀ» Â÷·Ê·Î Ŭ¸¯Çϰí services.msc¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù.

Ãß°¡ Á¤º¸

Microsoft SQL Server 2005 ¼³Ä¡ ÇÁ·Î±×·¥Àº ¼³Ä¡ÇÏ´Â °¢ ¼­ºñ½º¿¡ ´ëÇÑ ·ÎÄà Windows ±×·ìÀ» ¸¸µì´Ï´Ù. ¸¸µé¾îÁø Windows ±×·ìÀº "¼­ºñ½º ±×·ì"À¸·Î ÁöÁ¤µË´Ï´Ù.

SQL Server 2005 ¼³Ä¡ ÇÁ·Î±×·¥Àº °¢ ¼­ºñ½º¿¡ ´ëÇÑ ¼­ºñ½º °èÁ¤À» ÇØ´ç ±×·ì¿¡ Ãß°¡ÇÕ´Ï´Ù. ƯÁ¤ SQL Server ¼­ºñ½º¿¡ ÇÊ¿äÇÑ ¸ðµç Windows NT »ç¿ë ±ÇÇÑÀÌ °¢ Windows ±×·ì¿¡ ºÎ¿©µË´Ï´Ù.

ÀÌ·¯ÇÑ ±×·ìÀº SQL Server ¼­ºñ½º ¹× ±âŸ ½ÇÇà ÆÄÀÏÀÇ ½ÇÇà¿¡ ÇÊ¿äÇÑ »ç¿ë ±ÇÇÑ ºÎ¿© ÇÁ·Î¼¼½º¸¦ °£¼ÒÈ­ÇÕ´Ï´Ù. ÀÌ·¯ÇÑ ±×·ìÀº ¶ÇÇÑ SQL Server ÆÄÀÏÀ» º¸È£ÇÏ´Â µ¥µµ µµ¿òÀÌ µË´Ï´Ù. SQL Server ¼­ºñ½º´Â ¼­ºñ½º ±×·ì ±¸¼º¿ø ÀÚ°ÝÀ» ÅëÇØ Windows ¸®¼Ò½º ¹× SQL Server ¸®¼Ò½º¿¡ ¾×¼¼½ºÇÕ´Ï´Ù.

SQL Server 2005 ¼³Ä¡ ÇÁ·Î¼¼½º Áß¿¡ ´ÙÀ½ ¼­ºñ½º ¹× ¼­ºñ½º ±×·ìÀÌ ¸¸µé¾îÁý´Ï´Ù.
Ç¥ Ãà¼ÒÇ¥ È®´ë
SQL Server ¼­ºñ½º ¼­ºñ½º ±×·ì
SQL Server±âº» ÀνºÅϽº: SQLServer2005MSSQLUser$ComputerName$MSSQLSERVER
¸í¸íµÈ ÀνºÅϽº: SQLServer2005MSSQLUser$ComputerName$InstanceName
SQL Server ¿¡ÀÌÀüÆ®±âº» ÀνºÅϽº: SQLServer2005SQLAgentUser$ComputerName$MSSQLSERVER
¸í¸íµÈ ÀνºÅϽº: SQLServer2005SQLAgentUser$ComputerName$InstanceName
Analysis Services±âº» ÀνºÅϽº: SQLServer2005MSOLAPUser$ComputerName$MSSQLSERVER
¸í¸íµÈ ÀνºÅϽº: SQLServer2005MSOLAPUser$ComputerName$InstanceName
Reporting Services±âº» ÀνºÅϽº:
SQLServer2005ReportServerUser$ComputerName$MSSQLSERVER and SQLServer2005ReportingServicesWebServiceUser$ComputerName$MSSQLSERVER

¸í¸íµÈ ÀνºÅϽº:
SQLServer2005ReportServerUser$ComputerName$InstanceName and SQLServer2005ReportingServicesWebServiceUser$ComputerName$InstanceName
Notification Services±âº» ¶Ç´Â ¸í¸íµÈ ÀνºÅϽº: SQLServer2005NotificationServicesUser$ComputerName
Integration Services ±âº» ¶Ç´Â ¸í¸íµÈ ÀνºÅϽº: SQLServer2005DTSUser$ComputerName
Àüü ÅØ½ºÆ® °Ë»ö±âº» ÀνºÅϽº: SQLServer2005MSFTEUser$ComputerName$MSSQLSERVER
¸í¸íµÈ ÀνºÅϽº: SQLServer2005MSFTEUser$ComputerName$InstanceName
SQL Server Browser±âº» ¶Ç´Â ¸í¸íµÈ ÀνºÅϽº: SQLServer2005SQLBrowserUser$ComputerName
SQL Server Active Directory Helper±âº» ¶Ç´Â ¸í¸íµÈ ÀνºÅϽº: SQLServer2005MSSQLServerADHelperUser$ComputerName
Windows ¼­ºñ½º °èÁ¤À» ¼³Á¤ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ÂüÁ¶ÇϽʽÿÀ.
http://msdn.microsoft.com/ko-kr/library/ms143504(SQL.90).aspx

¼Ó¼º

±â¼ú ÀÚ·á: 957008 - ¸¶Áö¸· °ËÅä: 2009³â 2¿ù 6ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 3.0
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2005 Service Pack 2?À»(¸¦) ´ÙÀ½°ú ÇÔ²² »ç¿ëÇßÀ» ¶§
    • Microsoft SQL Server 2005 Standard Edition
    • Microsoft SQL Server 2005 Enterprise Edition
    • Microsoft SQL Server 2005 Express Edition
    • Microsoft SQL Server 2005 Developer Edition
    • Microsoft SQL Server 2005 Express Edition with Advanced Services
    • Microsoft SQL Server 2005 Enterprise X64 Edition
    • Microsoft SQL Server 2005 Standard X64 Edition
    • Microsoft SQL Server 2005 Developer Edition for Itanium-based Systems Community Technology Preview
    • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems Community Technology Preview
    • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
Ű¿öµå:?
kbexpertiseinter kbfix kbbug kbsecvulnerability kbsecurity kbqfe kbpubtypekc KB957008

Çǵå¹é º¸³»±â