Reporting Services ´Ù¸¥ ÄÄÇ»ÅÍ¿¡ ½ÇÇàµÇ°í ÀÖ´Â ÄÄÇ»ÅÍ¿¡¼­ Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ À̵¿ÇÏ´Â ¹æ¹ý

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

¼Ò°³

ÀÌ ¹®¼­¿¡¼­´Â Microsoft SQL Server Reporting Services ´Ù¸¥ ÄÄÇ»ÅÍ¿¡ ½ÇÇàµÇ°í ÀÖ´Â ÄÄÇ»ÅÍ¿¡¼­ Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ À̵¿ÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. ÀÌ ¹®¼­¿¡¼­´Â SQL Server 2005 Reporting Services ȯ°æ ¹× SQL Server 2005 Reporting Services ȯ°æ¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.

»õ SQL Server 2005 Reporting Services ÀνºÅϽº SQL Server 2000 Reporting Services ¹èÆ÷ ¸¶À̱׷¹À̼ÇÇÒ °æ¿ì ´ÙÀ½ Microsoft °³¹ßÀÚ ³×Æ®¿öÅ© (MSDN) À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
http://msdn2.microsoft.com/en-us/library/ms143724.aspx

Ãß°¡ Á¤º¸

Reporting Services µ¥ÀÌÅͺ£À̽º ÇÑ ÄÄÇ»ÅÍ¿¡¼­ ´Ù¸¥ ÄÄÇ»ÅÍ·Î ¿©·¯ °¡Áö ÀÌÀ¯·Î À̵¿ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, Reporting Services ÀÀ¿ë ÇÁ·Î±×·¥ °³¹ß ȯ°æ¿¡¼­ »ç¿ëÇÏ´Â ÄÄÇ»ÅÍÀÇ º¸°í¼­¸¦ ¸¸µé ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ º¸°í¼­´Â ÇÁ·Î´ö¼Ç ȯ°æ¿¡¼­ »ç¿ëÇÏ´Â ÄÄÇ»ÅÍ·Î À̵¿ÇÏ·Á´Â °æ¿ì Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ º¸°í ¼­ºñ½º Windows ¼­ºñ½º¿Í Reporting Services À¥ ¼­ºñ½º°¡ ÇÔ²² À̵¿ÇØ¾ß ÇÕ´Ï´Ù. ´Ù¸¥ ÄÄÇ»ÅÍ·Î Reporting Services µ¥ÀÌÅͺ£À̽º ¹× º¸°í ¼­ºñ½º¸¦ ÄÄÇ»ÅÍ °£¿¡ À̵¿ÇÏ´Â °æ¿ì¿¡´Â º¸°í¼­¸¦ ´Ù½Ã ¹èÆ÷ÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.

SQL Server 2000 Reporting Services



SQL Server 2000 Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ ´Ù¸¥ ÄÄÇ»ÅÍ·Î À̵¿ÇÒ Reporting Services ÇØ´ç µ¥ÀÌÅͺ£À̽º¸¦ °¡¸®Å°µµ·Ï ÇÏ·Á¸é ´ÙÀ½ ÀÌ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
  1. ¿øº» ÄÄÇ»ÅÍ¿¡ Reporting Services µ¥ÀÌÅͺ£À̽º ¹× Reporting Àӽà µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷ÇϽʽÿÀ.

    Âü°í ±âº»ÀûÀ¸·Î ReportServer, Reporting Services µ¥ÀÌÅͺ£À̽º À̸§Àº ¹× ReportServerTempDB Reporting Àӽà µ¥ÀÌÅͺ£À̽º À̸§ÀÔ´Ï´Ù.
  2. 1 ´Ü°è¿¡¼­ ÀûÀýÇÑ SQL Server ÀνºÅϽº¸¦ ´ë»ó ÄÄÇ»ÅÍ¿¡ ´ëÇØ ¹é¾÷µÈ µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇϽʽÿÀ.
  3. Reporting Services 2 ´Ü°è¿¡¼­ º¹¿øÇÑ µ¥ÀÌÅͺ£À̽º¸¦ °¡¸®Å°°í ÇÏ·Á¸é º¸°í¼­ ¼­¹ö·Î ±¸¼ºµÈ ÄÄÇ»ÅÍÀÇ ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    RSConfig - c-s Server name -d Reporting Services database name-Sql|Windows - u-p User passwordUser name

    Âü°í Rsconfig.exe ¸í·ÉÁÙ À¯Æ¿¸®Æ¼¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    RSConfig/?
º¸°í ¼­ºñ½º Windows ¼­ºñ½º¿Í Reporting Services À¥ ¼­ºñ½º°¡ ÇÔ²² Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ ÇÑ ÄÄÇ»ÅÍ¿¡¼­ ´Ù¸¥ ÄÄÇ»ÅÍ·Î À̵¿ÇÒ ¼ö ¸ÕÀú ¿øº» ÄÄÇ»ÅÍ¿¡ ÀÖ´Â ¾Ïȣȭ ۸¦ ¹é¾÷ÇØ¾ß ÇÕ´Ï´Ù. ´ÙÀ½ Reporting Services µ¥ÀÌÅͺ£À̽º ¿øº» ÄÄÇ»ÅÍ¿¡¼­ ´ë»ó ÄÄÇ»ÅÍ·Î À̵¿ÇÒ ¹× ´ë»ó ÄÄÇ»ÅÍÀÇ ¾Ïȣȭ ۸¦ º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¸°Ô ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ¿øº» ÄÄÇ»ÅÍ¿¡ ´ëĪ ¾Ïȣȭ ۸¦ ¹é¾÷ÇÏ·Á¸é Rskeymgmt.exe ¸í·ÉÁÙ À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇϽʽÿÀ. ÀÌ·¸°Ô ÇÏ·Á¸é ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    RSKeyMgmt.exe -e-f Path of file name -p Strong password

    Âü°í Rskeymgmt.exe ¸í·ÉÁÙ À¯Æ¿¸®Æ¼¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    RSKeyMgmt/?
  2. ´ë»ó ÄÄÇ»ÅÍ¿¡¼­ ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
    1. º¸°í ¼­ºñ½º¸¦ ¼³Ä¡ÇϽʽÿÀ.
    2. º¸°í¼­ ¼­¹ö Windows ¼­ºñ½º¸¦ ÁßÁöÇϽʽÿÀ.
    3. Microsoft ÀÎÅÍ³Ý Á¤º¸ ¼­ºñ½º (IIS) ÁßÁöÇϽʽÿÀ.
  3. Reporting Services µ¥ÀÌÅͺ£À̽º ¹× Reporting Àӽà µ¥ÀÌÅͺ£À̽º¸¦ ¿øº» ÄÄÇ»ÅÍ¿¡¼­ ´ë»ó ÄÄÇ»ÅÍÀÇ ÀûÀýÇÑ SQL Server ÀνºÅϽº¸¦ À̵¿ÇϽʽÿÀ.

    Âü°í ±âº»ÀûÀ¸·Î ReportServer, Reporting Services µ¥ÀÌÅͺ£À̽º À̸§Àº ¹× ReportServerTempDB Reporting Àӽà µ¥ÀÌÅͺ£À̽º À̸§ÀÔ´Ï´Ù.

    SQL Server¸¦ ½ÇÇàÇÏ´Â ÄÄÇ»ÅÍ °£¿¡ µ¥ÀÌÅͺ£À̽º¸¦ À̵¿ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
    314546SQL Server¸¦ ½ÇÇàÇÏ´Â ÄÄÇ»ÅÍ °£¿¡ µ¥ÀÌÅͺ£À̽º¸¦ À̵¿ÇÏ´Â ¹æ¹ý
  4. ´ë»ó ÄÄÇ»ÅÍ¿¡¼­ ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
    1. º¸°í¼­ ¼­¹ö Windows ¼­ºñ½º¸¦ ½ÃÀÛÇϽʽÿÀ.
    2. IIS¸¦ ½ÃÀÛÇϽʽÿÀ.
    3. Rsconfig.exe ¸í·ÉÁÙ À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇÏ¿© º¸°í¼­ ¼­¹ö ÀνºÅϽº¸¦ 3´Ü°è¿¡¼­ ´ë»ó ÄÄÇ»ÅÍ·Î À̵¿ÇÒ Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇϵµ·Ï ±¸¼ºÇÕ´Ï´Ù. ÀÌ·¸°Ô ÇÏ·Á¸é ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

      RSConfig - c-s Server name -d Reporting Services database name-Sql|Windows - u-p User passwordUser name

      Âü°í Rsconfig.exe ¸í·ÉÁÙ À¯Æ¿¸®Æ¼¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

      RSConfig/?
    4. Rskeymgmt.exe ¸í·ÉÁÙ À¯Æ¿¸®Æ¼´Â 1´Ü°è¿¡¼­ ¹é¾÷ÇÑ ´ëĪ ¾Ïȣȭ ۸¦ Àû¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¸°Ô ÇÏ·Á¸é ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

      Âü°íPath of file name ¸¦ °æ·Î ÆÄÀÏ À̸§, Strong password ¸¦ 1´Ü°è¿¡¼­ »ç¿ëÇÑ ¾ÏÈ£·Î):

      RSKeyMgmt - a-f Path of file name -p Strong password
Âü°í ÀÌ ¹®¼­ÀÇ ÇØ°á ½ºÅÄ´õµå º¸°í¼­ ¼­¹ö¸¦ º¹¿øÇÏ´Â °æ¿ì ¹ß»ýÇÏ´Â ¹®Á¦¸¦ °èÁ¤ ÀÛ¾÷À»Áö ¾Ê½À´Ï´Ù. ¹®Á¦´Â Áö½Ã¿¡ µû¶ó ÈÄ ÀÌÀü ÀνºÅϽº¿¡ ´ëÇÑ ÇàÀÌ ¿©ÀüÈ÷ µ¥ÀÌÅͺ£À̽º¿¡ ¼ö ÀÖ½À´Ï´Ù. ¿øº» ÄÄÇ»ÅÍ¿Í ´ë»ó ÄÄÇ»ÅͰ¡ À¥ ÆÊ °¡ÀÔÇÑ »ý°¢ÇÒ ¶§¹®¿¡ ½ºÅÄ´õµå ½ÃÀÛµÇÁö ¾Ê½À´Ï´Ù.

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é ¼öµ¿À¸·Î »èÁ¦ Ű¿¡¼­ ½ÇÇàµÇ´Â Ŭ¶óÀÌ¾ðÆ® > -1 ¹é¾÷ ۸¦ Àû¿ëÇϽʽÿÀ. ¼öµ¿À¸·Î »èÁ¦ Ű¿¡¼­ ½ÇÇàµÇ´Â Ŭ¶óÀÌ¾ðÆ® > -1 Ç¥ÁØ ¹öÀüÀÇ. À¥ ÆÊÀÇ °æ¿ì ¿©ÀüÈ÷ µéÁö¸¸ ÀÛ¾÷ ÁßÀÎ ´Ù¸¥ ¸ðµç ³ëµå´Â À¥ ÆÊÀÇ ÇØÁ¦ÇØ¾ß ÇÕ´Ï´Ù.

SQL Server 2005 Reporting Services

Âü°í ReportServer À̵¿ÇÕ´Ï´Ù. SQL Server 2005 º¸°í ¼­ºñ½º µ¥ÀÌÅͺ£À̽º À̸§Àº °¡Á¤ÇϽʽÿÀ.

SQL Server 2005 Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ ´Ù¸¥ ÄÄÇ»ÅÍ·Î À̵¿ÇÒ Reporting Services ÇØ´ç µ¥ÀÌÅͺ£À̽º¸¦ °¡¸®Å°µµ·Ï ÇÏ·Á¸é ´ÙÀ½ ÀÌ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
¿øº» ¼­¹ö¿¡¼­ ÀÛ¾÷
  1. SQL Server °ü¸® Studio¸¦ ¿­°í SQL Server 2005 ÀνºÅϽº¿¡ ¿¬°áÇϽʽÿÀ.
  2. ReportServer µ¥ÀÌÅͺ£À̽º, ReportServerTempDB µ¥ÀÌÅͺ£À̽º ¹× º¸°í¼­¸¦ ÅëÇØ ¾×¼¼½ºµÇ´Â µ¥ÀÌÅͺ£À̽º ³ª¸ÓÁö ¹é¾÷ÇϽʽÿÀ.

    ¹é¾÷ ¹× µ¥ÀÌÅͺ£À̽º º¹¿ø ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ MSDN À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
    http://msdn2.microsoft.com/en-us/library/ms143724.aspx
  3. Reporting Services ±¸¼º °ü¸®ÀÚ¸¦ »ç¿ëÇÏ¿© ¾Ïȣȭ ۸¦ ¹é¾÷ÇÏ·Á¸é ¹é¾÷ÇϽʽÿÀ.

    ¾Ïȣȭ ۸¦ ¹é¾÷ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ MSDN À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
    http://msdn2.microsoft.com/en-us/library/ms157275.aspx
  4. ¹é¾÷ µ¥ÀÌÅͺ£À̽º ÆÄÀÏ ¹× ¹é¾÷ ¾Ïȣȭ Ű ÆÄÀÏÀ» ´ë»ó ¼­¹ö·Î º¹»çÇϽʽÿÀ.
´ë»ó ¼­¹ö¿¡¼­ ÀÛ¾÷
  1. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ iisreset/stop ¸í·ÉÀ» ½ÇÇàÇÏ¿© ÀÎÅÍ³Ý Á¤º¸ ¼­ºñ½º (IIS) ¼­ºñ½º¸¦ ÁßÁöÇϽʽÿÀ.

    ½ÃÀÛ ¹× IIS ÁßÁö ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
    http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/95826e7a-bac4-4e1f-bcb6-c52d49c9d7f4.mspx?mfr=true
  2. ¼­ºñ½º ±¸¼º º¸°í °ü¸®ÀÚ¸¦ ¿­°í SQL Server 2005 Reporting Services ÀνºÅϽº¿¡ ¿¬°áÇϽʽÿÀ.
  3. º¸°í ¼­ºñ½º¸¦ Windows ¼­ºñ½º¸¦ ÁßÁöÇÏ·Á¸é ¼­¹ö »óÅ ¸¦ Ŭ¸¯ÇÏ°í ¼­¹ö »óÅ º¸°í¼­ ÆäÀÌÁöÀÇ ÁßÁö ¸¦ Ŭ¸¯ÇϽʽÿÀ. ÁßÁö »ç¿ëÇÒ ¼ö ¾ø´Â °æ¿ì ¼­ºñ½º°¡ À̹Ì, ÁßÁöµÇ¾ú½À´Ï´Ù.
  4. SQL Server °ü¸® Studio¸¦ ¿­°í SQL Server 2005 ÀνºÅϽº¿¡ ¿¬°áÇϽʽÿÀ.
  5. ÀÖÀ¸¸é ReportServer µ¥ÀÌÅͺ£À̽º ¹× ReportServerTempDB µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷ÇϽʽÿÀ.
  6. ÀÖÀ¸¸é ReportServer µ¥ÀÌÅͺ£À̽º ¹× ReportServerTempDB µ¥ÀÌÅͺ£À̽º¸¦ ºÐ¸®ÇϽʽÿÀ.
  7. ¿øº» ¼­¹ö¿¡¼­ ¹é¾÷ µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇϽʽÿÀ.
  8. ¼­ºñ½º ±¸¼º º¸°í °ü¸®ÀÚ¿¡¼­ ´ÙÀ½ ÆäÀÌÁö ±¸¼º¿¡¼­ ¼Ò½º ¼­¹ö¿¡¼­ µ¿ÀÏÇÕ´Ï´Ù ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
    • º¸°í¼­ ¼­¹ö °¡»ó µð·ºÅ͸® ±¸¼º
    • º¸°í¼­ °ü¸®ÀÚ °¡»ó µð·ºÅ͸® ±¸¼º
    • ¼­ºñ½º °èÁ¤ ±¸¼º¿¡ Windows ¼­ºñ½º ID À¯Çü
    • º¸°í¼­ ¼­¹ö ±¸¼º ¹× À¥ ¼­ºñ½º IDº¸°í¼­ °ü¸®ÀÚ ±¸¼º
  9. º¸°í ¼­ºñ½º¸¦ Windows ¼­ºñ½º¸¦ ½ÃÀÛÇÏ·Á¸é ¼­¹ö »óÅ º¸°í ¼­ºñ½º ±¸¼º °ü¸®ÀÚ¿¡¼­, Ŭ¸¯ÇÑ ´ÙÀ½ ¼­¹ö »óÅ º¸°í¼­ ÆäÀÌÁöÀÇ ½ÃÀÛ À» ´©¸¨´Ï´Ù.
  10. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ iisreset/start ¸í·ÉÀ» ½ÇÇàÇÏ¿© IIS ¼­ºñ½º¸¦ ½ÃÀÛÇϽʽÿÀ.
  11. ¿øº» ¼­¹ö¿¡¼­ ¾Ïȣȭ ۸¦ Á¦°ÅÇϽʽÿÀ. ÇØ´ç SQL Server 2005 Reporting »ç¿ëÀÚ°¡ Services SQL Server 2005 Enterprise Edition Æ÷ÇÔµÈ °æ¿ì Á÷Á¢ º¸°í ¼­ºñ½º ±¸¼º °ü¸®ÀÚ¿¡¼­ ÀÌ ÀÛ¾÷À» ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¸Áö ¾ÊÀº °æ¿ì À̸¦ rskeymgmt À¯Æ¿¸®Æ¼¸¦ ÀÇÁ¸ÇØ¾ß ÇÕ´Ï´Ù.

    SQL Server 2005 Enterprise Edition ȯ°æ

    1. ¼­ºñ½º ±¸¼º º¸°í °ü¸®ÀÚ ÃʱâÈ­ ¸¦ Ŭ¸¯ÇϽʽÿÀ.
    2. SQL Server 2005ÀÇ ´Ù¸¥ ÀνºÅϽº¿¡¼­ ¾Ïȣȭ ۸¦ Á¦°ÅÇϽʽÿÀ. ´ë»ó ¼­¹ö¿Í °°Àº ¼­¹ö À̸§À» °¡Áø Ű Çϳª¸¸ º¸°üÇϽʽÿÀ.
    3. º¸°í ¼­ºñ½º ±¸¼º °ü¸®ÀÚ¿¡¼­, ¾Ïȣȭ Ű, Ŭ¸¯ÇÑ ´ÙÀ½ ¾Ïȣȭ Ű ÆäÀÌÁöÀÇ º¹¿ø À» Ŭ¸¯ÇϽʽÿÀ.
    4. ¾Ïȣȭ Ű Á¤º¸ â¿¡¼­ ¾Ïȣȭ ۸¦ ´Ù½Ã ¿øº» ¼­¹ö¿¡¼­ À§·Î ¿øº» ¼­¹ö¿¡¼­ ¹é¾÷ ¾Ïȣȭ ۸¦ ãÀº ´ÙÀ½ È®ÀÎ À» Ŭ¸¯ÇÏ¿© »ç¿ëÇÒ ¾ÏÈ£¸¦ ÀÔ·ÂÇϽʽÿÀ.

    ´Ù¸¥ ¹öÀüÀÇ SQL Server 2005 ȯ°æ



    Âü°í ¶ÇÇÑ ÀÌ ¹æ¹ýÀº SQL Server 2005 Enterprise Edition ȯ°æ¿¡ Àû¿ëµË´Ï´Ù.
    1. ½ÃÀÛ À», ½ÇÇà À», cmd ¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ ¸í·É ÇÁ·ÒÇÁÆ® âÀ» ¿­·Á¸é È®ÀÎ ´©¸¨´Ï´Ù.
    2. Á¸ÀçÇÏ´Â ¾Ïȣȭ ۸¦ °Ë»çÇϽʽÿÀ. ´ë»ó ¼­¹ö¿¡ ¼³Ä¡µÈ SQL Server 2005 ÀνºÅϽºÀÇ Çü½ÄÀ» ±â¹ÝÀ¸·Î, ¸í·É ÇÁ·ÒÇÁÆ® â¿¡¼­ ´ÙÀ½À» ÀÔ·ÂÇÕ´Ï´Ù.

      ±âº» ÀνºÅϽº
      rskeymgmt -l À» ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù

      ¸í¸íµÈ ÀνºÅϽº
      Çü½Ä rskeymgmt -l-i InstName, ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù

      ³ª¿­µÈ µÎ °³ÀÇ ¾Ïȣȭ ۸¦ º¼ ¼ö ÀÖ½À´Ï´Ù. ¿øº» ¼­¹ö¿¡¼­ ÇϳªÀÌ¸ç ´Ù¸¥ ´ë»ó ¼­¹ö¿¡¼­ »ç¿ëµË´Ï´Ù. ³ª¿­µÈ ¾Ïȣȭ ŰÀÇ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
      ComputerName\ InstNameEncryptionKeyID

      Âü°íComputerName ´ë»ó ¼­¹ö¿¡ ¼³Ä¡µÈ SQL Server 2005 ÀνºÅϽº À̸§¿¡ ´ëÇÑ ÀÚ¸® Ç¥½ÃÀÚ À̸§À» ´ë»ó ¼­¹ö°¡. InstName °ÍÀÔ´Ï´Ù. EncryptionKeyID ¾Ïȣȭ ŰÀÇ ID¿¡ [NULL]¿¡ ´ëÇÑ ÀÚ¸® Ç¥½ÃÀÚÀÔ´Ï´Ù.
    3. ¿øº» ¼­¹ö¿¡¼­ ¾Ïȣȭ ۸¦ »èÁ¦ÇϽʽÿÀ. ÄÄÇ»ÅÍ¿¡ ¼³Ä¡µÈ SQL Server 2005 ÀνºÅϽºÀÇ Çü½ÄÀ» ±â¹ÝÀ¸·Î ¸í·É ÇÁ·ÒÇÁÆ® â¿¡¼­ ´ÙÀ½À» ÀÔ·ÂÇÕ´Ï´Ù.

      ±âº» ÀνºÅϽº
      rskeymgmt - r SourceEncryptionKeyID ¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù

      ¸í¸íµÈ ÀνºÅϽº
      Çü½Ä rskeymgmt -i InstName - r SourceEncryptionKeyID, ÀÔ·ÂÇÑ ´ÙÀ½ Enter ۸¦ ´©¸¨´Ï´Ù

      Âü°íSourceEncryptionKeyID 2 ´Ü°è¿¡¼­ ¾òÀº ¿øº» ¼­¹ö¿¡¼­ ¾Ïȣȭ Ű ID¿¡ ´ëÇÑ ÀÚ¸® Ç¥½ÃÀÚÀÔ´Ï´Ù.
    4. 2´Ü°è¸¦ ¹Ýº¹ÇϽʽÿÀ. ´ë»ó ¼­¹öÀÇ ¾Ïȣȭ ۰¡ °æ¿ì¿¡¸¸ ÀÌÁ¦ ÀÖ´ÂÁö È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.
  12. ¿øº» ¼­¹ö¿¡¼­ ¹é¾÷ ¾Ïȣȭ ۸¦ º¹¿øÇϽʽÿÀ. ÀÌ·¸°Ô ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
    1. º¸°í ¼­ºñ½º ±¸¼º °ü¸®ÀÚ¿¡¼­, ¾Ïȣȭ Ű, Ŭ¸¯ÇÑ ´ÙÀ½ ¾Ïȣȭ Ű ÆäÀÌÁöÀÇ º¹¿ø À» Ŭ¸¯ÇϽʽÿÀ.
    2. ¾Ïȣȭ Ű Á¤º¸ â¿¡¼­ ¾Ïȣȭ ۸¦ ´Ù½Ã ¿øº» ¼­¹ö¿¡¼­ À§·Î ¿øº» ¼­¹ö¿¡¼­ ¹é¾÷ ¾Ïȣȭ ۸¦ ãÀº ´ÙÀ½ È®ÀÎ À» Ŭ¸¯ÇÏ¿© »ç¿ëÇÒ ¾ÏÈ£¸¦ ÀÔ·ÂÇϽʽÿÀ.
  13. Rsreportserver.config ÆÄÀÏ¿¡ ´ëÇÑ ASP.NET ¼­ºñ½º °èÁ¤ µ¿ÀÏÇÑ »ç¿ëÀÚ °èÁ¤À¸·Î ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ. ÀÌ·¸°Ô ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
    1. ¼­ºñ½º ±¸¼º º¸°í °ü¸®ÀÚ À¥ ¼­ºñ½º ID ¸¦ Ŭ¸¯ÇϽʽÿÀ. ASP.NET ¼­ºñ½º °èÁ¤ Á¤º¸¸¦ È®ÀÎÇϽʽÿÀ.
    2. SQLInstall ¿­: \Program Files\Microsoft SQL Server\ MSSQL.X \Reporting Services\ReportServer Æú´õ. Rsreportserver.config ÆÄÀÏÀ» ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߷ΠŬ¸¯ÇÑ ´ÙÀ½ ¼Ó¼º À» Ŭ¸¯ÇϽʽÿÀ.

      Âü°íSQLInstall SQL Server 2005 ¼³Ä¡µÇ¾î ÀÖ´Â µå¶óÀ̺ê À§ÇÑ ÀÚ¸® Ç¥½ÃÀÚÀÔ´Ï´Ù. MSSQL.X SQL Server 2005 º¸°í¼­ ´ë»ó ¼­¹ö¿¡¼­ ½ÇÇà ÁßÀÎ Services ÀνºÅϽºÀÇ ÀνºÅϽº ID¿¡ [NULL]¿¡ ´ëÇÑ ÀÚ¸® Ç¥½ÃÀÚÀÔ´Ï´Ù. ÀνºÅϽº ID¸¦ ¹ÞÀ¸·Á¸é, ¼­¹ö »óÅ º¸°í ¼­ºñ½º ±¸¼º °ü¸®ÀÚ¿¡¼­ ´©¸¥ ´ÙÀ½ ÀνºÅϽº ID Á¤º¸¸¦ È®ÀÎÇϽʽÿÀ.
    3. Rsreportserver ¼Ó¼º ´ëÈ­ »óÀÚ¿¡¼­ º¸¾È ÅÇÀ» Ŭ¸¯ÇϽʽÿÀ.
    4. ASP.NET ¼­ºñ½º °èÁ¤ÀÌ ³ª¿­µÇÁö ¾ÊÀº °æ¿ì Ãß°¡ÇϽʽÿÀ. ASP.NET ¼­ºñ½º °èÁ¤¿¡ ÀÐ±â ¹× ÀÐ±â ¹× ½ÇÇà ±ÇÇÑÀÌ ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ »ç¿ë ±ÇÇÑ.
    5. Rsreportserver ¼Ó¼º âÀ» ´ÝÀ¸·Á¸é È®ÀΠŬ¸¯ÇϽʽÿÀ.
  14. À¥ ºê¶ó¿ìÀú¸¦ ¿­°í ´ë»ó ¼­¹ö¿¡¼­ º¸°í¼­¸¦ º¾´Ï´Ù.
´ë»ó ¼­¹ö¿¡¼­ º¸°í¼­¸¦ º¼ ¶§ ¹®Á¦°¡ ¹ß»ýÇÏ´Â °æ¿ì SQL Server °ü¸® Studio º¸°í¼­ ±¸¼º ¿ä¼Ò¿¡ ´ëÇÑ º¸¾È ¼³Á¤À» °Ë»çÇÒ ¼ö ÀÖ½À´Ï´Ù. ¹®Á¦°¡ ÀÖ´Â À¥ ÆäÀÌÁö¿¡ ¿À·ù ¸Þ½ÃÁö¸¦ º¸¿© ÁÝ´Ï´Ù.

ÂüÁ¶

Reporting Services µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
http://msdn2.microsoft.com/en-us/library/aa972237.aspx
SQL Server¸¦ ½ÇÇàÇÏ´Â ÄÄÇ»ÅÍ °£¿¡ µ¥ÀÌÅͺ£À̽º¸¦ À̵¿ÇÒ ¶§ »ç¿ë ±ÇÇÑ ¹®Á¦¸¦ ÇØ°áÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
240872SQL Server¸¦ ½ÇÇàÇÏ´Â ¼­¹ö »çÀÌ¿¡¼­ µ¥ÀÌÅͺ£À̽º¸¦ À̵¿ÇÒ ¶§ »ç¿ë ±ÇÇÑ ¹®Á¦¸¦ ÇØ°áÇÏ´Â ¹æ¹ý

¼Ó¼º

±â¼ú ÀÚ·á: 842425 - ¸¶Áö¸· °ËÅä: 2006³â 4¿ù 7ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 4.4
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2000 Reporting Services
  • Microsoft SQL Server 2005 Reporting Services
Ű¿öµå:?
kbmt kbsql2005rs kbexpertiseadvanced kbinfo kbreport kbserver kbdatabase kbsettings kbconsole kbhowto KB842425 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.

Çǵå¹é º¸³»±â