- Äɲ䵤줿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
- ºï½ü¤µ¤ì¤¿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
- MSDE¥á¥â ¤Ø¹Ô¤¯¡£
¢ªSQL Server´ØÏ¢
¢ªSQL Server 2005
¢ª¥Ç¡¼¥¿¥Ù¡¼¥¹´ØÏ¢
#contents
*Tips [#uc18f167]
-[[WSS>http://www.microsoft.com/japan/windowsserver2003/techinfo/sharepoint/wss.mspx]]¤ËÉÕ°¤·¤Æ¤¤¤ëWMSDE¤Ë¤Ï2GBYTEÀ©¸Â¤¬¤Ê¤¤¤é¤·¤¤¡£¤¿¤À¤·¥µ¡¼¥Ð¤¬2003¥µ¡¼¥Ð¤Ç¤¢¤ëɬÍפ¬¤¢¤ë
-[[Vista¤Ç¤ÏMSDE2000¤Ï¥µ¥Ý¡¼¥È¤µ¤ì¤Ê¤¤·ï:http://www.microsoft.com/japan/sql/howtobuy/sqlonvista.mspx]]
--SQL Server 2005 Express¤Ë°Ü¹Ô¤¹¤ëɬÍפ¬¤¢¤ë¡£
-[[Installing MSDE with .NET Application:http://www.codeproject.com/cs/database/msdeinstaller.asp]]
-[[SQL Server 2000 ¥í¡¼¥«¥ë ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Í¥Ã¥È¥ï¡¼¥¯Àܳ¤ò¥»¥¥å¥ê¥Æ¥£¤ÇÊݸ¤ëÊýË¡:http://support.microsoft.com/default.aspx?scid=kb;ja;814130]]
-[[¤¢¤¤¤½¤Ó¤Î³«È¯¥Î¡¼¥È¤è¤ê:http://isobe.exblog.jp/11934]]
--sp3a¤«¤é¡¢¥»¥¥å¥ê¥Æ¥£¶¯²½¤Î¤¿¤á¡¢¥¹¥¿¥ó¥É¥¢¥í¡¼¥ó°Ê³°¤ÎÀܳ¤¬Ìµ¸ú¤Ë¤µ¤ì¤Æ¤¤¤ë¤¬¡¢¤³¤ì¤ò¥ê¥â¡¼¥È¤«¤éÀܳ¤Ç¤¤ë¤è¤¦¤ËÀßÄꤹ¤ëÊýË¡
--¡MSDE¦¤ÎPC¤Ç¡¢¡Ösvrnetcn.exe¡×¤ò¼Â¹Ô¡£
--TCP/IP ¤« ¥Þ¥ë¥Á¥×¥í¥È¥³¥ë ¤« ̾Á°ÉÕ¤¥Ñ¥¤¥× ¤ò͸ú¤Ë¤¹¤ë¡£
--¢¥¯¥é¥¤¥¢¥ó¥È¦¤Ç¡¢Ž¢cliconfg.exeŽ£¤ò¼Â¹Ô¡£
--Ʊ¤¸¤¯¡¢TCP/IP ¤« ¥Þ¥ë¥Á¥×¥í¥È¥³¥ë ¤« ̾Á°ÉÕ¤¥Ñ¥¤¥× ¤ò͸ú¤Ë¤¹¤ë¡£
*¥é¥¤¥»¥ó¥¹¤Ë¤Ä¤¤¤Æ [#c2a2e96d]
-MSDE¤Ï¡¢Windows¤ÎProfessional·Ï¤ÎOS¤Ç¤âÆ°ºî¤·¤Þ¤¹¤¬¡¢OS¼«ÂΤ˳°Éô¤«¤é¤ÎÀܳ¤¹¤ë¤¿¤á¤Î¥é¥¤¥»¥ó¥¹¤¬Ç§¤á¤é¤ì¤Æ¤¤¤Þ¤»¤ó¤Î¤Ç¡¢MSDE¤Ë¤Ä¤¤¤Æ¤â¡¢¥ê¥â¡¼¥È¤«¤éÀßÄꡦÊݼé¤Ê¤É¤¬¶Ø»ß¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
-MSDE¤Ë¸Â¤é¤º¡¢Windows 2000¤äXP¤ÎProfessional¤Ç¤Ï¡¢Web¥µ¡¼¥Ð¡¼¤äWindows¥Í¥Ã¥È¥ï¡¼¥¯¡¢¥ê¥â¡¼¥ÈÀܳ¤À¤±¤Î¤´¤¯¸Â¤é¤ì¤¿ÍÑÅӰʳ°¤Î¥µ¡¼¥Ð¡¼Î©¤Á¾å¤²¡Ê¤È¤¤¤¦¤«¥Í¥Ã¥È¥ï¡¼¥¯Àܳ¼«ÂΤ¬¡Ë¤¬»ö¼Â¾å¶Ø»ß¤µ¤ì¤Æ¤¤¤ë
-[[¥½¡¼¥¹¡§¤¢¤¤¤½¤Ó:http://isobe.exblog.jp/11934]]
-¤Á¤Ê¤ß¤ËASP.NET¤Ê¤ó¤«¤ÇWindowsXP¾å¤ÎIIS¤ËƱ»þ¥¢¥¯¥»¥¹¤¹¤ë¤È£µ¤Ä¤¯¤é¤¤¤Ä¤Ê¤¤¤À¤È¤³¤í¤Ç¥¨¥é¡¼¤Ë¤Ê¤ëÌÏÍÍ
*MS·Ï¥µ¥¤¥È [#p5261a51]
-[[MSDE¥È¥Ã¥×@MS:http://www.microsoft.com/japan/sql/msde/]]
-[[MSDE¤Î¥À¥¦¥ó¥í¡¼¥É¥Ú¡¼¥¸:http://www.microsoft.com/downloads/details.aspx?FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=ja]]
--[[¥ê¥ê¡¼¥¹¥Î¡¼¥È:http://download.microsoft.com/download/a/1/7/a175bc7f-eb81-4f5b-8f4e-0fcbef954140/ReadmeMSDE2000A.htm]]
-[[SQL Server Books online:http://msdn.microsoft.com/library/?url=/library/en-us/startsql/portal_7ap1.asp?frame=true]]
-[[SQL server ¼«½¬½ñ:http://www.microsoft.com/japan/SQL/techinfo/selfstudy/Self_doc.asp]]
--[[MSDE Tutorial MSDE¤ò»È¤ª¤¦:http://www.microsoft.com/japan/sql/msde/techinfo/usemsde.mspx]]
-[[SQL server system table map:http://www.microsoft.com/japan/sql/techinfo/productdoc/2000/systables.asp]]
**¥µ¡¼¥Ó¥¹¥Ñ¥Ã¥¯ [#k9e5dafa]
-[[SQL Server SP4:http://www.microsoft.com/japan/sql/downloads/2000/sp4.mspx]]
*ÈóMS·Ï¥µ¥¤¥È [#z5061be8]
-[[Winsystem:http://www.winsystem.jp/community.html]] MSDE¥Ð¥Ã¥¯¥¢¥Ã¥×¡¢¥¤¥ó¥¹¥È¡¼¥é¤¬¤¢¤ë
-[[1¥Ç¡¼¥¿¥Ù¡¼¥¹2GB¤Î¾å¸Â¤Ë¤Ä¤¤¤Æ@int21:http://www.int21.co.jp/pcdn/vb/noriolib/vbmag/0004/msde/]]
--£±¥Ç¡¼¥¿¥Ù¡¼¥¹Åö¤¿¤ê£²£Ç£Â¤Ç¤¢¤ê¡¢Ê£¿ô¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò»ý¤¿¤»¤ì¤ÐÁ´ÂΤȤ·¤Æ2GB¤òĶ¤¨¤ë¤³¤È¤Ï²Äǽ¡£
--£±¥¤¥ó¥¹¥¿¥ó¥¹¤Ç¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¤¤¤¯¤Ä¤Þ¤Ç¤â¤Æ¤ë¤Î¤«¤Ë¤Ä¤¤¤Æ¤Ï¾ðÊ󤬤ʤ¤¡£À©¸Â¤Ê¤·¡©
--¤Þ¤¿¡¢Ê̥ǡ¼¥¿¥Ù¡¼¥¹¤Ë¤¢¤ë¥Æ¡¼¥Ö¥ë¤Èɽ·ë¹ç¤ò¤¹¤ë¤³¤È¤â²Äǽ¡£¤¿¤À¤·SQL¤Î¥Æ¡¼¥Ö¥ë̾¤Î»ØÄê¤ÏŤ¯¤Ê¤ë¡£
-[[MSDE ¥Õ¥¡¥ó¥¯¥é¥Ö:http://www.horikawa.ne.jp/msde/]]
*Tool [#z08b3bb8]
-[[SQL Web Data Administrator:http://www.microsoft.com/downloads/details.aspx?familyid=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en]]
--¤³¤Î¥Ä¡¼¥ë¤Ç²Äǽ¤Ê¤Î¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¡¦¥Õ¥¡¥¤¥ë¤Î´ÉÍý¤Î¤ß¤Ç¡¢¥Ç¡¼¥¿¤Î»²¾È¤ä¹¹¿·¤Ê¤É¤Ï¤Ç¤¤Ê¤¤
-OSQL¤Îµ¯Æ°¥Ñ¥é¥á¡¼¥¿
c:\>osql -?
»ÈÍÑË¡ : osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-X[1] disable commands [and exit with warning]]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
¥³¥ó¥½¡¼¥ëÉý¤Î¼«Æ°¥¹¥±¡¼¥ê¥ó¥°
Ť¤¥á¥Ã¥»¡¼¥¸
´ûÄê¤Î¥¨¥é¡¼ ¥ì¥Ù¥ë¤Ï -1 : 1
[-? ¹½Ê¸¤ÎÍ×Ìó¤òɽ¼¨]
*¥¤¥ó¥¹¥È¡¼¥ë¥á¥â [#ued528ba]
-[[MSDE¤ò¥»¥Ã¥È¥¢¥Ã¥×¤¹¤ëÊýË¡@IT:http://www.atmarkit.co.jp/fwin2k/win2ktips/583msde/msde.html]]
-''MSDE¤ò¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤¿¤á¤Ë¤Ï¡¢¤¢¤é¤«¤¸¤á¥¤¥ó¥¹¥È¡¼¥ëÂоݤΥ³¥ó¥Ô¥å¡¼¥¿¤Ë¤ª¤¤¤Æ¡¢¥Õ¥¡¥¤¥ë¤È¥×¥ê¥ó¥¿¤Î¶¦Í¥µ¡¼¥Ó¥¹¤ò͸ú¤Ë¤·¤Æ¤ª¤¯É¬Íפ¬¤¢¤ë''¡ÊWindows 98¡¿Me¤Î¾ì¹ç¤Ï̵¸ú¤Ç¤â²Ä¡Ë
-¥»¥¥å¥ê¥Æ¥£¡¦¥Ý¥ê¥·¡¼¤Î³Îǧ
--¡Î´ÉÍý¥Ä¡¼¥ë¡Ï¤Î¡Î¥í¡¼¥«¥ë ¥»¥¥å¥ê¥Æ¥£ ¥Ý¥ê¥·¡¼¡Ï¤òµ¯Æ°¤·¡¢¡Î¥»¥¥å¥ê¥Æ¥£¤ÎÀßÄê¡Ï¤Ë¤¢¤ë¡Î¥í¡¼¥«¥ë ¥Ý¥ê¥·¡¼¡Ï¡Ý¡Î¥»¥¥å¥ê¥Æ¥£¥ª¥×¥·¥ç¥ó¡Ï¤Ç¡¢¡Î½ð̾¤µ¤ì¤Æ¤¤¤Ê¤¤¥É¥é¥¤¥Ð°Ê³°¤Î¥¤¥ó¥¹¥È¡¼¥ë»þ¤ÎÆ°ºî¡Ï¡ÊWindows XP¡¿Windows Server 2003¤Ç¤Ï¡Î¥Ç¥Ð¥¤¥¹: ½ð̾¤µ¤ì¤Æ¤¤¤Ê¤¤¥É¥é¥¤¥Ð°Ê³°¤Î¥¤¥ó¥¹¥È¡¼¥ë»þ¤ÎÆ°ºî¡Ï¡Ë¤ÎÀßÄê¤ò³Îǧ¤¹¤ë¡£¤³¤ì¤¬¡Î·Ù¹ð¤Ê¤·¤Çµö²Ä¤¹¤ë¡Ï¤«¡Î·Ù¹ð¤¹¤ë¤¬¥¤¥ó¥¹¥È¡¼¥ë¤Ïµö²Ä¤¹¤ë¡Ï¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤³¤È¤ò³Îǧ¤¹¤ë¡£É¬Íפʤé¤ÐÀßÄê¤òÊѹ¹¸å¡¢¥¤¥ó¥¹¥È¡¼¥ë¸å¤Ë¸µ¤ËÌ᤻¤Ð¤è¤¤¡£
-Setup.ini¤Ë°Ê²¼¤Î¤è¤¦¤Ë½ñ¤«¤Ê¤¤¤È¥Ñ¥¹¥ï¡¼¥É¤¬¤É¤¦¤³¤¦¸À¤ï¤ì¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤Ç¤¤Ê¤¤¡£
[Options]
SECURITYMODE=SQL
SAPWD=<¥Ñ¥¹¥ï¡¼¥ÉŬµ¹>
DISABLENETWORKPROTOCOLS=0
¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤é»ØÄꤷ¤Æ¤â¤è¤¤¤¬ini¤ò½ñ¤´¹¤¨¤ëÊý¤¬³Î¼Â¤È»×¤ï¤ì¤ë¡£DISABLENETWORKPROTOCOLS¤ò0¤Ë¤·¤Ê¤¤¤È³°Éô¤«¤éEnterprise Manager¤Ê¤É¤ÇÀܳ¤Ç¤¤Ê¤¤¤Î¤ÇÃí°Õ¡£
-[[¥¤¥ó¥¹¥È¡¼¥ë¤Î»²¹Í¤Ë¤Ê¤ë¥Ú¡¼¥¸:http://www.spencernetwork.com/windows-sp8.php]]
--Enterprise Manager¤Î¥¤¥ó¥¹¥È¡¼¥ë
-MSDE´ÉÍýÍѤËSQL Enterprise Manager¤À¤±Æþ¤ì¤ë¡£
--http://www.microsoft.com/japan/sql/evaluation/trial/2000/
---http://www.microsoft.com/japan/sql/prodinfo/previousversions/trial/2000/download.mspx
--ɾ²ÁÈǤÎSQL¥µ¡¼¥Ð¡¼¤Ë¤Ï´ü¸Â¤¬¤¢¤ê¤Þ¤¹¤¬¡¢SQL Enterprise Manager¤Ë¤Ï´ü¸Â¤¬¤¢¤ê¤Þ¤»¤ó¡£
--¥Õ¥¡¥¤¥ë¤ò¥À¥¦¥ó¥í¡¼¥É¤¹¤ë¤Ë¤Ï¡¢HOTMAIL¥¢¥«¥¦¥ó¥È¤¬É¬Íפˤʤê¤Þ¤¹¤Î¤ÇÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£
--¥Õ¥¡¥¤¥ë¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤¿¤é¤½¤Î¤Þ¤Þ¼Â¹Ô¤·¤Þ¤¹¡£¼Â¹Ô¤¹¤ë¤È¡¢
C:\SQLEVAL
¤Ë¥Õ¥¡¥¤¥ë¤¬²òÅव¤ì¤Þ¤¹¡£SQL Enterprise Manager¤À¤±¤ò¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¾ì¹ç¤Ï¡¢
C:\SQLEVAL\x86\setup\setupsql.exe
¤ò¼Â¹Ô¤·¤Æ¼¡¡¹¤Ë¥Ç¥£¥Õ¥©¥ë¥È¤Î¤Þ¤Þ¿Ê¤ó¤Ç¤¤¤¤Þ¤¹¡£
--ÅÓÃæ¤Ç¡¢[¥¯¥é¥¤¥¢¥ó¥È¤È¥µ¡¼¥Ð¡¼]¤È[¥¯¥é¥¤¥¢¥ó¥È¤Î¤ß]¤òÁª¤ÖÉôʬ¤¬¤¢¤ê¤Þ¤¹¤Î¤Ç¡¢ ¤½¤³¤Ç¡¢[¥¯¥é¥¤¥¢¥ó¥È¤Î¤ß]¤òÁªÂò¡£
--SQL Enterprise Manager¤òµ¯Æ°
--SQL SErver Group¤ò±¦¥¯¥ê¥Ã¥¯¤·¡¢New Server Registration¤òÁªÂò¡£
--Available servers:¤ËIP¥¢¥É¥ì¥¹¤òµÆþ¤·¡¢Add¤ò¥¯¥ê¥Ã¥¯
--Windowsǧ¾Ú¤Ç¤Ï¤Ê¤¯¡¢SQL Server Authentication¤Î¤Û¤¦¤òÁª¤ó¤Ç¡¢MSDE¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿»þ¤ËÀßÄꤷ¤¿¥Ñ¥¹¥ï¡¼¥É¤òÆþÎÏ
--¥í¥°¥¤¥ó̾¤Ïsa¤È¤Ê¤ê¤Þ¤¹¡£¤³¤³¤«¤é¤Ï¡¢³§ÍͤÎÃΤäƤ¤¤ëSQL¥µ¡¼¥Ð¡¼¤ÈƱ¤¸¤Ç¤¹¡£
**¥¤¥ó¥¹¥¿¥ó¥¹¤òÄɲä·¤¿¤¤¤È¤¤Ï [#g789b5d4]
-setup.ini¤Ë°Ê²¼¤Î¤è¤¦¤Êµ½Ò¤òÄɲ乤ë
[Options]
INSTANCENAME=<Äɲä·¤¿¤¤¥¤¥ó¥¹¥¿¥ó¥¹Ì¾>
¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¾Êά¡£¤Ä¤±¤¿¤±¤ì¤Ð¤Ä¤±¤ë¡Ë
-¤â¤¦°ìÅÙsetup.exe¤òµ¯Æ°¤·¤Æ¥»¥Ã¥È¥¢¥Ã¥×¤¹¤ë
-°Ê¾å¤Ç¥¤¥ó¥¹¥¿¥ó¥¹¤¬Äɲ䵤ì¤ë¤Ï¤º
-¥¤¥ó¥¹¥È¡¼¥ëľ¸å¤Ï¥µ¡¼¥Ó¥¹¥Þ¥Í¡¼¥¸¥ã¤Ê¤É¤Çµ¯Æ°¤µ¤»¤Ê¤¤¤È»È¤¨¤Ê¤¤¤Î¤ÇÃí°Õ
**¥¤¥ó¥¹¥¿¥ó¥¹ºï½ü¤·¤¿¤¤¾ì¹ç¤Ï [#hc0d87a3]
-¥³¥ó¥È¥í¡¼¥ë ¥Ñ¥Í¥ë¤Î [¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤ÎÄɲäȺï½ü] ¤ò¥À¥Ö¥ë¥¯¥ê¥Ã¥¯
-SQL Server 2000 ¤Î¥¤¥ó¥¹¥¿¥ó¥¹Ì¾¤òÁªÂò¤·¡¢[Êѹ¹/ºï½ü] ¤ò¥¯¥ê¥Ã¥¯