Select the product you need help with
SQL Server ¹öÀü ¹× Edition°ú ÇØ´ç ±¸¼º ¿ä¼Ò¸¦ È®ÀÎÇÏ´Â ¹æ¹ý±â¼ú ÀÚ·á: 321185 - ÀÌ ¹®¼°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â. ÀÌ ¹®¼´Â ÀÌÀü¿¡ ´ÙÀ½ ID·Î ÃâÆÇµÇ¾úÀ½: KR321185 ÀÌ ÆäÀÌÁö¿¡¼¿ä¾àÀÌ ¹®¼¿¡¼´Â ÇöÀç Microsoft SQL Server ¹öÀü ¹øÈ£¿Í ÇØ´ç Á¦Ç° ¶Ç´Â ¼ºñ½º ÆÑ ¼öÁØÀ» È®ÀÎÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù. ¶ÇÇÑ »ç¿ë ÁßÀΠƯÁ¤ SQL Server EditionÀ» È®ÀÎÇÏ´Â ¹æ¹ýµµ ¼³¸íÇÕ´Ï´Ù. Âü°í SQL ServerÀÇ ÃֽŠºôµå¸¦ ãÀ¸·Á¸é ´ÙÀ½ ¹®¼¸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶Ç´Â ÀÌ ¹®¼ÀÇ "Ãß°¡ Á¤º¸" Àý¿¡¼ Á¦Ç°¿¡ ÇØ´çÇϴ ǥ¸¦ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. 957826
(http://support.microsoft.com/default.aspx?scid=kb;ko-kr;957826)
ÃֽŠSQL Server ºôµå¿¡ ´ëÇÑ Á¤º¸¸¦ ã´Â À§Ä¡SQL Server Ŭ¶óÀÌ¾ðÆ® µµ±¸ ¹öÀüÀ» È®ÀÎÇÏ´Â ¹æ¹ýSMO(SQL Server Management Studio)½Ã½ºÅÛ¿¡ ¼³Ä¡µÈ Ŭ¶óÀÌ¾ðÆ® µµ±¸ ¹öÀüÀ» È®ÀÎÇÏ·Á¸é Management Studio¸¦ ½ÃÀÛÇÑ ´ÙÀ½ µµ¿ò¸» ¸Þ´º¿¡¼ Á¤º¸¸¦ Ŭ¸¯ÇÕ´Ï´Ù.±×¸² Ãà¼Ò ![]() SQL Server BIDS(Business Intelligence Development Studio)Analysis Services Designer, Integration Services Designer ¶Ç´Â SQL Server Reporting Services Designer ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
½ÇÇà ÁßÀÎ SQL Server µ¥ÀÌÅͺ£À̽º ¿£Áø ¹öÀü ¹× EditionÀ» È®ÀÎÇÏ´Â ¹æ¹ýSQL Server ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.¹æ¹ý 1: SQL Server Management Studio¿¡¼ °³Ã¼ Ž»ö±â¸¦ »ç¿ëÇÏ¿© ¼¹ö¿¡ ¿¬°áÇÕ´Ï´Ù. °³Ã¼ Ž»ö±â°¡ ¿¬°áµÇ¸é ¹öÀü Á¤º¸°¡ °ýÈ£·Î ¹¿© Ç¥½ÃµÇ°í ÇØ´ç ƯÁ¤ SQL Server ÀνºÅϽº¿¡ ¿¬°áÇÏ´Â µ¥ »ç¿ëµÈ »ç¿ëÀÚ À̸§ÀÌ Ç¥½ÃµË´Ï´Ù. ¹æ¹ý 2: ÇØ´ç ÀνºÅϽº¿¡ ´ëÇÑ ¿À·ù ·Î±× ÆÄÀÏÀÇ Ã³À½ ¸î ÁÙÀ» È®ÀÎÇØº¾´Ï´Ù. ±âº»ÀûÀ¸·Î ¿À·ù ·Î±×´Â Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG ¹× ERRORLOG.n ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. ÇØ´ç Ç׸ñÀº ´ÙÀ½°ú ºñ½ÁÇÕ´Ï´Ù. 2011-03-27 22:31:33.50 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) ¹æ¹ý 3: SQL Server ÀνºÅϽº¿¡ ¿¬°áÇÏ°í ´ÙÀ½ Äõ¸®¸¦ ½ÇÇàÇÕ´Ï´Ù. Select @@version Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) ¹æ¹ý 4: SQL Server ÀνºÅϽº¿¡ ¿¬°áÇÏ°í ´ÙÀ½ Äõ¸®¸¦ ½ÇÇàÇÕ´Ï´Ù. SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')´ÙÀ½ °á°ú°¡ ¹ÝȯµË´Ï´Ù.
¿¹¸¦ µé¸é °á°ú´Â ´ÙÀ½°ú ºñ½ÁÇÕ´Ï´Ù. Ç¥ Ãà¼Ò
¹æ¹ý 5: SQL Server 2008ºÎÅÍ ¼³Ä¡µÈ SQL Server ±â´É °Ë»ö º¸°í¼¸¦ »ç¿ëÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÀÌ º¸°í¼´Â SQL Server ¼³Ä¡ ¼¾ÅÍÀÇ µµ±¸ ÆäÀÌÁö¿¡¼ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ µµ±¸´Â ½Ã½ºÅÛ¿¡ ¼³Ä¡µÈ ¸ðµç SQL Server ÀνºÅϽº¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù. ¿©±â¿¡´Â SQL Server Management Studio¿Í °°Àº Ŭ¶óÀÌ¾ðÆ® µµ±¸°¡ Æ÷ÇԵ˴ϴÙ. SQL Server°¡ ¼³Ä¡µÈ ½Ã½ºÅÛ¿¡¼¸¸ ·ÎÄ÷ΠÀÌ µµ±¸¸¦ ½ÇÇàÇÒ ¼ö ÀÖ´Ù´Â »ç½Ç¸¸ ¾Ë°í ÀÖÀ¸¸é µË´Ï´Ù. µû¶ó¼ ¿ø°Ý ¼¹ö¿¡ ´ëÇÑ Á¤º¸¸¦ ±¸ÇÏ´Â µ¥´Â ÀÌ µµ±¸¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº MSDN(Microsoft °³¹ßÀÚ ³×Æ®¿öÅ©)¿¡¼ ´ÙÀ½ ºí·Î±× °Ô½Ã¹°À» ÂüÁ¶ÇϽʽÿÀ. SQL Server 2008 °Ë»ö º¸°í¼ »ùÇà º¸°í¼ ½º³À¼ôÀº ´ÙÀ½°ú °°½À´Ï´Ù.
(http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx)
±×¸² Ãà¼Ò ![]() SQL Server 2012 ¹öÀü Á¤º¸´ÙÀ½ Ç¥¿¡´Â SQL Server 2012 ÁÖ ¸±¸®½º°¡ ³ª¿Í ÀÖ½À´Ï´Ù.Ç¥ Ãà¼Ò
2755533
(http://support.microsoft.com/kb/2755533/ko/
)
SQL Server 2012¿ë Ãֽмºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ýSQL Server 2012ÀÇ ÃֽŠ´©Àû ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 2692828
(http://support.microsoft.com/kb/2692828/ko/
)
SQL Server 2012 ¹èÆ÷ ÈÄ ¹èÆ÷µÈ SQL Server 2012 ºôµåSQL Server 2008 R2 ¹öÀü Á¤º¸´ÙÀ½ Ç¥¿¡´Â SQL Server 2008 R2 ÁÖ ¸±¸®½º°¡ ³ª¿Í ÀÖ½À´Ï´Ù.Ç¥ Ãà¼Ò
2527041
(http://support.microsoft.com/kb/2527041/ko/
)
SQL Server 2008 R2¿ë Ãֽмºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ýSQL Server 2008 R2ÀÇ ÃֽŠ´©Àû ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 981356
(http://support.microsoft.com/kb/981356/ko/
)
SQL Server 2008 R2 ¹èÆ÷ ÈÄ ¹èÆ÷µÈ SQL Server 2008 R2 ºôµå2567616
(http://support.microsoft.com/kb/2567616/ko/
)
SQL Server 2008 R2 ¼ºñ½º ÆÑ 1 ¹èÆ÷ ÈÄ ¹èÆ÷µÈ SQL Server 2008 R2 ºôµå2730301
(http://support.microsoft.com/kb/2730301/ko/
)
SQL Server 2008 R2 ¼ºñ½º ÆÑ 2 ¹èÆ÷ ÈÄ ¹èÆ÷µÈ SQL Server 2008 R2 ºôµåSQL Server 2008 ¹öÀü Á¤º¸´ÙÀ½ Ç¥¿¡´Â SQL Server 2008 ÁÖ ¸±¸®½º°¡ ³ª¿Í ÀÖ½À´Ï´Ù.Ç¥ Ãà¼Ò
968382 SQL Server 2008ÀÇ ÃֽŠ´©Àû ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
(http://support.microsoft.com/kb/968382/ko/
)
SQL Server 2008¿ë Ãֽмºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý956909
(http://support.microsoft.com/kb/956909/ko/
)
SQL Server 2008 ¹èÆ÷ ÈÄ ¹èÆ÷µÈ SQL Server 2008 ºôµå970365
(http://support.microsoft.com/kb/970365/ko/
)
SQL Server 2008 ¼ºñ½º ÆÑ 1ÀÌ Ãâ½ÃµÈ ÈÄ Ãâ½ÃµÈ SQL Server 2008 ºôµå2402659
(http://support.microsoft.com/kb/2402659/ko/
)
SQL Server 2008 ¼ºñ½º ÆÑ 2°¡ Ãâ½ÃµÈ ÈÄ Ãâ½ÃµÈ SQL Server 2008 ºôµå2629969
(http://support.microsoft.com/kb/2629969/ko/
)
SQL Server 2008 ¼ºñ½º ÆÑ 3ÀÌ Ãâ½ÃµÈ ÈÄ Ãâ½ÃµÈ SQL Server 2008 ºôµåSQL Server 2005 ¹öÀü Á¤º¸´ÙÀ½ Ç¥¿¡´Â SQL Server 2005 ÁÖ ¸±¸®½º°¡ ³ª¿Í ÀÖ½À´Ï´Ù.Ç¥ Ãà¼Ò
913089 SQL Server 2005ÀÇ ÃֽŠ´©Àû ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
(http://support.microsoft.com/kb/913089/ko/
)
SQL Server 2005¿ë Ãֽмºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý937137
(http://support.microsoft.com/kb/937137/ko/
)
SQL Server 2005 ¼ºñ½º ÆÑ 2°¡ Ãâ½ÃµÈ ÈÄ Ãâ½ÃµÈ SQL Server 2005 ºôµå960598
(http://support.microsoft.com/kb/960598/ko/
)
SQL Server 2005 ¼ºñ½º ÆÑ 3ÀÌ Ãâ½ÃµÈ ÈÄ Ãâ½ÃµÈ SQL Server 2005 ºôµå2485757
(http://support.microsoft.com/kb/2485757/ko/
)
SQL Server 2005 ¼ºñ½º ÆÑ 4°¡ Ãâ½ÃµÈ ÈÄ Ãâ½ÃµÈ SQL Server 2005 ºôµåSQL Server 2000 ¹öÀü Á¤º¸´ÙÀ½ Ç¥¿¡´Â Sqlservr.exe ÆÄÀÏÀÇ ¹öÀü ¹øÈ£°¡ ³ª¿Í ÀÖ½À´Ï´Ù.Ç¥ Ãà¼Ò
290211
(http://support.microsoft.com/kb/290211/ko/
)
ÃֽŠSQL Server 2000 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ýSQL Server Reporting ServicesSQL Server Reporting Services ¹öÀüÀ» È®ÀÎÇÏ·Á¸é SQL Server ¿Â¶óÀÎ ¼³¸í¼¿¡¼ ´ÙÀ½ Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.¹æ¹ý: ¹öÀü Á¤º¸ °Ë»ö(Reporting Services)
(http://msdn.microsoft.com/ko-kr/library/bb630446.aspx)
SQL Server Integration ServicesSQL Server Integration Services ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½ Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.942177
(http://support.microsoft.com/default.aspx?scid=kb;ko-kr;942177)
SQL Server Integration Services ¹öÀüÀ» È®ÀÎÇÏ´Â ¹æ¹ýSQL Server Analysis ServicesSQL Server Analysis Services ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ.¹æ¹ý 1: SQL Server Management Studio¿¡¼ °³Ã¼ Ž»ö±â¸¦ »ç¿ëÇÏ¿© ¼¹ö¿¡ ¿¬°áÇÕ´Ï´Ù. °³Ã¼ Ž»ö±â°¡ ¿¬°áµÇ¸é ¹öÀü Á¤º¸°¡ °ýÈ£·Î ¹¿© Ç¥½ÃµÇ°í ÇØ´ç ƯÁ¤ Analysis Services ÀνºÅϽº¿¡ ¿¬°áÇÏ´Â µ¥ »ç¿ëµÈ »ç¿ëÀÚ À̸§ÀÌ Ç¥½ÃµË´Ï´Ù. ¹æ¹ý 2: Analysis Services Bin Æú´õ¿¡¼ Msmdsrv.exe ÆÄÀÏ ¹öÀüÀ» È®ÀÎÇÕ´Ï´Ù. ±âº» À§Ä¡´Â ´ÙÀ½ Ç¥¿¡ Ç¥½ÃµË´Ï´Ù. Ç¥ Ãà¼Ò
¹æ¹ý 3: ´ÙÀ½ Ç¥¿¡ Ç¥½ÃµÈ ·¹Áö½ºÆ®¸® ۸¦ »ç¿ëÇÕ´Ï´Ù. Ç¥ Ãà¼Ò
ÀÚ¼¼ÇÑ ³»¿ëÀ» º¸·Á¸é ´ÙÀ½ Microsoft TechNet ºí·Î±× °Ô½Ã¹°À» ÂüÁ¶ÇϽʽÿÀ. Analysis Services ¼¹ö ¹öÀüÀ» ã´Â ¹æ¹ý
(http://blogs.technet.com/b/sqlman/archive/2008/03/25/how-to-find-analysis-services-server-version.aspx)
SQL Server º¹Á¦º¹Á¦ ¿¡ÀÌÀüÆ®°¡ ¿©·¯ ´Ù¸¥ ÄÄÇ»ÅÍ¿¡ ¼³Ä¡µÇ¾î ÀÖÀ» ¼ö ÀÖÀ¸¹Ç·Î ¿µÇâÀ» ¹Þ´Â ¸ðµç ÄÄÇ»ÅÍ¿¡¼ ¼³Ä¡µÈ ¹öÀüÀ» È®ÀÎÇÏ´Â °ÍÀÌ Áß¿äÇÕ´Ï´Ù.¿¹¸¦ µé¾î Æ®·£Àè¼Ç ¶Ç´Â ÇǾî Åõ ÇÇ¾î º¹Á¦ÀÇ ¹èÆ÷ ¿¡ÀÌÀüÆ®°¡ SQL Server °Ô½ÃÀÚ ÀνºÅϽº¿Í´Â ´Ù¸¥ ÄÄÇ»ÅÍ¿¡ ÀÖÀ» ¼ö ÀÖÀ¸¸ç ²ø¾î¿À±â ±¸µ¶ÀÇ ´Ù¾çÇÑ SQL Server ±¸µ¶ÀÚ ÀνºÅϽº¿¡ ÀÖÀ» ¼öµµ ÀÖ½À´Ï´Ù. º´ÇÕ º¹Á¦ ¶Ç´Â SQL Server 2000 Windows CE Edition º¹Á¦¿¡ ´ëÇØ À¥ µ¿±âȸ¦ »ç¿ëÇÏ´Â °æ¿ì IIS À¥ ¼¹ö´Â SQL Server°¡ ½ÇÇàµÇ´Â ÄÄÇ»ÅÍ¿Í ´Ù¸¥ ÄÄÇ»ÅÍÀÏ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼ IIS À¥ ¼¹ö¿¡ ¼³Ä¡µÈ º¹Á¦ ¿¡ÀÌÀüÆ® ÆÄÀÏÀ» º¸À¯ÇÏ°Ô µË´Ï´Ù. ¶ÇÇÑ IIS °¡»ó µð·ºÅ͸®¿¡¼ ÇØ´ç .dll ÆÄÀÏÀÇ ¹öÀüÀ» È®ÀÎÇϰí À¥ ¿¡ÀÌÀüÆ®¿¡ ´ëÇÑ Ãֽмºñ½º ÆÑ, ´©Àû ¾÷µ¥ÀÌÆ® ¹× ÇÖÇȽº¸¦ ¾ò±â À§ÇØ ¸í½ÃÀûÀ¸·Î ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server ¿Â¶óÀÎ ¼³¸í¼¿¡¼ ´ÙÀ½ Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ. º¹Á¦ ÅäÆú·ÎÁö¿¡¼ ¿©·¯ ¹öÀüÀÇ SQL Server »ç¿ë
(http://msdn.microsoft.com/ko-kr/library/ms143241.aspx)
Àüü ÅØ½ºÆ® °Ë»öÀüü ÅØ½ºÆ® °Ë»ö ±¸¼º ¿ä¼Ò¿¡´Â ´ÙÀ½ÀÌ Æ÷ÇԵ˴ϴÙ.
´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇÏ¿© ½Ã½ºÅÛ¿¡ ¼³Ä¡µÇ¾î ÀÖ´Â Àüü ÅØ½ºÆ® °Ë»ö ±¸¼º ¿ä¼ÒÀÇ ¹öÀüÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. Âü°í ´ÙÀ½ÀÇ °¢ ¹æ¹ýÀ» ÅëÇØ Àüü ÅØ½ºÆ® °Ë»ö ±¸¼º ¿ä¼Ò ¹öÀüÀÌ RTMÀÎÁö ¶Ç´Â µ¥ÀÌÅͺ£À̽º ±¸¼º ¿ä¼ÒÀÇ ÇöÀç ¹öÀüº¸´Ù ÀÌÀü ¹öÀüÀÎÁö¸¦ ¾Ë ¼ö ÀÖ½À´Ï´Ù. ÇöÀç ÀÌ·¯ÇÑ ¹®Á¦Á¡ÀÌ ÃæºÐÈ÷ ÆÄ¾ÇµÇ¾úÀ¸¸ç ÇâÈÄ ¾÷µ¥ÀÌÆ®¿¡¼ ÇØ°áÇϱâ À§ÇØ ÀÛ¾÷ ÁßÀÔ´Ï´Ù. ¹æ¹ý 1: SQL Server 2008 R2 ¶Ç´Â SQL Server 2008 ¼³Ä¡ Æú´õ¿¡¼ SQL Server Àüü ÅØ½ºÆ® Ű(Sql_fulltext_keyfile.dll) ¹öÀüÀ» È®ÀÎÇÕ´Ï´Ù. ÀϹÝÀûÀ¸·Î SQL Server 2008 R2ÀÇ °æ¿ì ÀÌ ÆÄÀÏÀº ´ÙÀ½ Æú´õ¿¡ ÀÖ½À´Ï´Ù. %ProgramFiles%\Microsoft SQL Server\MSQL10_50.<Instance Name>\MSSQL ÀϹÝÀûÀ¸·Î SQL Server 2008ÀÇ °æ¿ì ÀÌ ÆÄÀÏÀº ´ÙÀ½ Æú´õ¿¡ ÀÖ½À´Ï´Ù. %ProgramFiles%\Microsoft SQL Server\MSQL10.<Instance Name>\MSSQL ¹æ¹ý 2: ´ÙÀ½ ·¹Áö½ºÆ®¸® ÇÏÀ§ ۸¦ È®ÀÎÇÕ´Ï´Ù. HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft sql server\Mssql10_50.instname\Setup\SQL_FULLTEXT_ADV featurelist: SQL_FullText_Adv=3 SQL_FullText_CNI=3ProductCode: {9DFA5914-C275-42E0-810E-C88E46A7F9EA}Patchlevel: 10.50.1765.0Version: 10.50.1600.1¹æ¹ý 3: ¼³Ä¡ Áß¿¡ ¸¸µé¾îÁø Summary.txt ÆÄÀÏÀ» »ç¿ëÇÕ´Ï´Ù. SQL Server 2008 R2ÀÇ °æ¿ì ÀÌ ÆÄÀÏÀº ´ÙÀ½ Æú´õ¿¡ ÀÖ½À´Ï´Ù. %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\LOG\Summary.txt SQL Server 2008ÀÇ °æ¿ì ÀÌ ÆÄÀÏÀº ´ÙÀ½ Æú´õ¿¡ ÀÖ½À´Ï´Ù. %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt SQL Server 2008 ¼³Ä¡¿¡ Æ÷ÇÔµÈ Àüü ÅØ½ºÆ® °Ë»ö ±¸¼º ¿ä¼ÒÀÇ ¾Ë·ÁÁø ¹®Á¦¿¡ ´ëÇØ¼´Â ´ÙÀ½ Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 973888
(http://support.microsoft.com/kb/973888/ko/
)
Àüü ÅØ½ºÆ® °Ë»ö ±¸¼º ¿ä¼Ò°¡ ÅëÇÕ ¼³Ä¡¸¦ »ç¿ëÇÏ¿© Àû¿ëµÈ SQL Server 2008 ¼ºñ½º ÆÑ 1¿ë ´©Àû ¾÷µ¥ÀÌÆ® 3À» Á¦°ÅÇÑ ÈÄ¿¡ ¼ºñ½º ÆÑ 1·Î ¿ÏÀüÇÏ°Ô ·Ñ¹éµÇÁö ¸ø ÇÔSQL Server MDS(Master Data Services)MDS ±¸¼º °ü¸®ÀÚ´Â ÇöÀç ¼³Ä¡µÈ ¹öÀü ¹øÈ£¸¦ Á÷Á¢ Ç¥½ÃÇÏÁö ¾Ê½À´Ï´Ù.MDS´Â SQL Server µ¥ÀÌÅͺ£À̽º ¿£Áø ¼³Ä¡°¡ ¹Ýµå½Ã MDS ¹öÀü°ú ÀÏÄ¡ÇÏÁö´Â ¾Ê´Â °íÀ¯ÇÑ ¹öÀü °ü¸® ½Ã³ª¸®¿À¸¦ À¯ÁöÇÕ´Ï´Ù. SQL Server ¼³Ä¡¸¦ MDS À¥ »çÀÌÆ®¿¡ ¹èÆ÷µÈ ¹ÙÀ̳ʸ® ¹× MDS īŻ·Î±× ½ºÅ°¸¶ ¹öÀü°ú ºñ±³ÇÏ¸é ¹öÀüÀÌ ´Ù¸¦ ¼ö ÀÖ½À´Ï´Ù. MDS À¥ »çÀÌÆ® ¹× µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶¸¦ ¾÷µ¥ÀÌÆ® ¹× ¾÷±×·¹À̵åÇϱâ À§ÇØ MDS ±¸¼º °ü¸®ÀÚ µµ±¸¸¦ »ç¿ëÇÏ´Â ¼öµ¿ ´Ü°è°¡ ÇÊ¿äÇÕ´Ï´Ù. ´ÙÀ½ ºí·Î±× °Ô½Ã¹°¿¡¼ MDSÀÇ ÇÖÇȽº ¹× ¼ºñ½º ÆÑ ¾÷µ¥ÀÌÆ® ¹æ¹ýÀ» ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. SQL Server 2008 R2 MDS(Master Data Services) ´©Àû ¾÷µ¥ÀÌÆ® ´Ù¿î·Îµå ¹× ¼³Ä¡
(http://sqlblog.com/blogs/mds_team/archive/2010/08/25/downloading-and-installing-sql-server-2008-r2-master-data-services-mds-cumulative-updates.aspx)
´ÙÀ½ ·¹Áö½ºÆ®¸® Ű´Â SQL Server¿¡ ¼³Ä¡µÈ ¹ÙÀ̳ʸ® ¹öÀüÀ» Ç¥½ÃÇÕ´Ï´Ù. ±×·¯³ª MDS ¾÷±×·¹À̵å ÇÁ·Î¼¼½º°¡ ¿Ï·áµÉ ¶§±îÁö´Â ÀÌ ¹öÀüÀÌ ÀÌ À¥ »çÀÌÆ® ¹× µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶ ¹öÀü°ú ÀÏÄ¡ÇÏÁö ¾ÊÀ» ¼öµµ ÀÖ½À´Ï´Ù. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Master Data Services 10.5\CurrentVersion MDS īŻ·Î±×¿¡¼ ´ÙÀ½ Äõ¸®¸¦ »ç¿ëÇÏ¿© ¼³Ä¡µÈ Á¦Ç° ¹öÀü ¹× ½ºÅ°¸¶ ¹öÀüÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. select * from mds.mdm.tblSystem SQL Server Native ClientSQL Server Native Client ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ.¹æ¹ý 1: Native Client ¹öÀüÀ» È®ÀÎÇÏ·Á´Â ½Ã½ºÅÛ¿¡¼ ODBC °ü¸®ÀÚ(odbcad32.exe)¸¦ ½ÃÀÛÇÑ ´ÙÀ½ µå¶óÀ̹ö ÅÇ¿¡¼ ¹öÀü ¿À» È®ÀÎÇϽʽÿÀ. ¹æ¹ý 2: ´ÙÀ½ ·¹Áö½ºÆ®¸® À§Ä¡¿¡¼ ´ÙÀ½ PatchLevel ¶Ç´Â Version ۸¦ È®ÀÎÇÕ´Ï´Ù. Ç¥ Ãà¼Ò
SQL Server ºê¶ó¿ìÀúÀÌ ºê¶ó¿ìÀú ¹öÀüÀº ÄÄÇ»ÅÍ¿¡ ¼³Ä¡µÈ SQL Server µ¥ÀÌÅͺ£À̽º ¿£Áø ¹× Analysis Services ÀνºÅϽºÀÇ °¡Àå ³ôÀº ¹öÀü°ú ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù.SQL Server ±â·Ï±âSQL Server ±â·Ï±â ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½ ·¹Áö½ºÆ®¸® Ű °ªÀ» È®ÀÎÇϽʽÿÀ.HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SqlWriter\CurrentVersion Microsoft .NET Framework½Ã½ºÅÛÀÇ .NET Framework ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ´ÙÀ½ Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.318785 ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
(http://support.microsoft.com/default.aspx?scid=kb;ko-kr;318785)
¼³Ä¡µÈ Microsoft .NET FrameworkÀÇ ¹öÀü ¹× ¼ºñ½º ÆÑ ¼öÁØÀ» È®ÀÎÇÏ´Â ¹æ¹ý2027770
(http://support.microsoft.com/kb/2027770/ko/
)
´Ù¾çÇÑ SQL Server ¹öÀü¿¡ ´ëÇÑ .NET Framework ¿ä±¸ »çÇ× ÀÌÇØSQL AzureSQL Azure ÀνºÅϽº ¹öÀü ¹× °ü·Ã Á¤º¸¸¦ È®ÀÎÇÏ·Á¸é ¿Â¶óÀÎ ¼³¸í¼¿¡¼ ´ÙÀ½ Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.SERVERPROPERTY(SQL Azure µ¥ÀÌÅͺ£À̽º)
(http://msdn.microsoft.com/ko-kr/library/ee336261(en-us).aspx)
SQL Server CESQL Server CE ÀνºÅϽºÀÇ ¹öÀü°ú °ü·Ã Á¤º¸¸¦ È®ÀÎÇÏ·Á¸é ´ÙÀ½ ¸®¼Ò½º¸¦ ÂüÁ¶ÇϽʽÿÀ.
ÀÌÀü ¹öÀüÀÇ SQL ServerSQL Server 7.0´ÙÀ½ Ç¥ÀÇ ¹öÀü ¹øÈ£¸¦ »ç¿ëÇÏ¿© Á¦Ç° ¶Ç´Â ¼ºñ½º ÆÑ ¼öÁØÀ» È®ÀÎÇϽʽÿÀ.?Ç¥ Ãà¼Ò
ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 301511
(http://support.microsoft.com/kb/301511/ko/
)
ÃֽŠSQL Server 7.0 ¼ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ýSQL Server 6.5´ÙÀ½ Ç¥ÀÇ ¹öÀü ¹øÈ£¸¦ »ç¿ëÇÏ¿© Á¦Ç° ¶Ç´Â ¼ºñ½º ÆÑ ¼öÁØÀ» È®ÀÎÇÕ´Ï´Ù.Ç¥ Ãà¼Ò
ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ ¹®¼ ¹øÈ£¸¦ Ŭ¸¯ÇÏ¿© Microsoft ±â¼ú ÀÚ·á ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. 273914
(http://support.microsoft.com/kb/273914/ko/
)
SQL Server 6.5 ¼ºñ½º ÆÑ 5a ÀÌÈÄ ¾÷µ¥ÀÌÆ®¿¡ ´ëÇÑ Readme.txtÁú¹®°ú ´ë´äÁú¹® 1: SQL Server°¡ ½ÇÇàµÇ°í ÀÖÁö ¾ÊÀ» ¶§ SQL Server ¹öÀüÀ» È®ÀÎÇÏ·Á¸é ¾î¶»°Ô Çմϱî?´ë´ä 1: ÀÌ ¹®¼ÀÇ "½ÇÇà ÁßÀÎ SQL Server µ¥ÀÌÅͺ£À̽º ¿£Áø ¹öÀüÀ» È®ÀÎÇÏ´Â ¹æ¹ý" Àý¿¡ ³ª¿À´Â ¹æ¹ý 2 ¶Ç´Â ¹æ¹ý 5(SQL Server 2008 ÀÌ»ó ¹öÀüÀÇ °æ¿ì)¸¦ »ç¿ëÇÏ¿© SQL Server ¹öÀüÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù. Áú¹® 2: Á¦Ç° ¹öÀü°ú ÀÏÄ¡ÇÏ´Â Á¦Ç° À̸§À» ãÀ¸·Á¸é ¾î¶»°Ô Çմϱî? ´ë´ä 2: ´ÙÀ½ Ç¥¸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. Ç¥ Ãà¼Ò
ÀÚÁÖ »ç¿ëµÇ´Â ¿ë¾î¿Í ¾à¾îCU(´©Àû ¾÷µ¥ÀÌÆ®): Áö±Ý±îÁö Ãâ½ÃµÈ ¸ðµç ÇÊ¿ä ½Ã ±ä±Þ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ·Ñ¾÷ ¾÷µ¥ÀÌÆ®ÀÔ´Ï´Ù. ¶ÇÇÑ CU¿¡´Â ÇÖÇȽº ¼ö¶ô ±âÁØÀ» ÃæÁ·ÇÏ´Â ¹®Á¦¿¡ ´ëÇÑ ¼öÁ¤ ³»¿ëÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ±âÁØ¿¡´Â ÇØ°á ¹æ¹ýÀÇ °¡¿ë¼º, °í°´¿¡ ¹ÌÄ¡´Â È¿°ú, ¹®Á¦ÀÇ Àç¹ß °¡´É¼º, º¯°æÇØ¾ß ÇÏ´Â ÄÚµåÀÇ º¹À⼺ ¹× ±âŸ Ç׸ñÀÌ Æ÷Ç﵃ ¼ö ÀÖ½À´Ï´Ù.ÇÖÇȽº: Á¦Ç°ÀÇ ¹®Á¦¸¦ ÇØ°áÇÏ´Â µ¥ »ç¿ëµÇ´Â Çϳª ÀÌ»óÀÇ ÆÄÀÏÀ» Æ÷ÇÔÇϰí ÀÖ´Â ´ÜÀÏ ´©Àû ÆÐŰÁö·Î, ¹ÙÀ̳ʸ® ¹× ÆÄÀÏ ¼öÁØ¿¡¼ ´©ÀûµË´Ï´Ù. ÇÖÇȽº´Â ƯÁ¤ °í°´ »óȲÀ» ÇØ°áÇÏ¸ç °í°´ Á¶Á÷ ¿ÜºÎ·Î´Â ¹èÆ÷ÇÒ ¼ö ¾ø½À´Ï´Ù. RTM: ÀϹÝÀûÀ¸·Î "release to manufacturing"À» ÀǹÌÇÕ´Ï´Ù. SQL Server°ú °°Àº Á¦Ç°ÀÇ °æ¿ì Á¦Ç°¿¡ Àû¿ëµÈ ¼ºñ½º ÆÑÀ̳ª ÇÖÇȽº°¡ ¾øÀ½À» ³ªÅ¸³À´Ï´Ù. RTW: ÀϹÝÀûÀ¸·Î "release to web"À» ÀǹÌÇÕ´Ï´Ù. À¥¿¡ Ãâ½ÃµÇ¾úÀ¸¸ç °í°´ÀÌ ´Ù¿î·ÎµåÇÒ ¼ö ÀÖ´Â ÆÐŰÁö¸¦ ³ªÅ¸³À´Ï´Ù. ¼ºñ½º ÆÑ: ¸ðµç ÇÖÇȽº, º¸¾È ¾÷µ¥ÀÌÆ®, Áß¿ä ¾÷µ¥ÀÌÆ® ¹× ¾÷µ¥ÀÌÆ®ÀÇ Å×½ºÆ®µÈ ´©Àû ÁýÇÕÀÔ´Ï´Ù. ¼ºñ½º ÆÑÀº Á¦Ç°ÀÌ Ãâ½ÃµÈ ÈÄ ³»ºÎ¿¡¼ ¹ß°ßµÇ´Â ¹®Á¦¿¡ ´ëÇÑ Ãß°¡ ÇȽº¿Í Á¦ÇÑµÈ ¼öÀÇ °í°´ ¿äû ¼³°è º¯°æÀ̳ª ±â´ÉÀ» Æ÷ÇÔÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ À¥ »çÀÌÆ®¸¦ ÂüÁ¶ÇϽʽÿÀ.
Ãß°¡ Á¤º¸SQL Server °øÅë ºôµå ¹øÈ£ ¹× ¼ºñ½º ÆÑÂü°í ´ÙÀ½ Ç¥´Â ´ÙÀ½ Çü½ÄÀ» »ç¿ëÇÏ¸ç ºôµå ¹øÈ£º°·Î Á¤·ÄµË´Ï´Ù.Ç¥ Ãà¼Ò
SQL Server 2012Ç¥ Ãà¼Ò
SQL Server 2008 R2Ç¥ Ãà¼Ò
SQL Server 2008Ç¥ Ãà¼Ò
SQL Server 2005Ç¥ Ãà¼Ò
SQL Server 2000Ç¥ Ãà¼Ò
¼Ó¼º±â¼ú ÀÚ·á: 321185 - ¸¶Áö¸· °ËÅä: 2013³â 4¿ù 26ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 16.0 º» ¹®¼ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
| ±â¼ú ÀÚ·á ¹ø¿ª
|






À§·Î °¡±â








