CARVIEW

MOTORHOMES

Select Language

HTTP/2 301 date: Mon, 06 Oct 2025 21:03:55 GMT content-type: text/html content-length: 162 location: https://atmarkit.itmedia.co.jp/ait/articles/1707/24/news007.html server: nginx strict-transport-security: max-age=31536000 HTTP/2 200 date: Mon, 06 Oct 2025 21:03:56 GMT content-type: text/html server: nginx vary: Accept-Encoding x-frame-options: SAMEORIGIN strict-transport-security: max-age=31536000 content-encoding: gzip ?h???C???Q????ASQL Server???N?????Ȃ??Ȃ????i?N???g???u???j?FSQL Server?g???u???V???[?e?B???O?i54?j?i1/2 ?y?[?W?j - ??IT

?h???C???Q????ASQL Server???N?????Ȃ??Ȃ????i?N???g???u???j?FSQL Server?g???u???V???[?e?B???O?i54?j?i1/2 ?y?[?W?j

?{?A?ڂ́A?uMicrosoft SQL Server?v?Ŕ???????g???u?????u?ǂ?ȕ??@?Łv?u?ǂ̂悤?Ɂv???????Ă??????A???????Ώ??̂??߂̃m?E?n?E???Љ?܂??B????́A?u?h???C???Q?????SQL Server???N?????Ȃ??Ȃ????ꍇ?̑Ώ????@?v????????܂??B

» 2017?N07??24?? 05??00?? ???J

[?Ŗ????j?C???j?A?f?b?N?X???????]

?A?ڃo?b?N?i???o?[

?@?{?A?ڂł́A?uMicrosoft SQL Server?i?ȉ??ASQL Server?j?v?Ŕ???????g???u???ɂ??āA?u?Ȃ??N?????????v?̗??R?ƂƂ??ɋ?̓I?ȑΏ????@???Љ?Ă????܂??B

?g???u?? 41?i?J?e?S???[?F?N???g???u???j?F?h???C???Q????ASQL Server???N?????Ȃ??Ȃ???

?ڎ?

?g???u???̎???
?g???u???̌???
???????@

?@?uWindows Server 2012 R2?v??ɁuSQL Server 2016 RTM?v???C???X?g?[??????????z?肵?ĉ?????܂??B

?g???u???̎????F?V?K??SQL Server???̗p?????V?X?e?????\?z???B???n?ł̎???Ǝ??Ԃ?Z?k???邽?߂ɁA???O?ɐݒu?\??̃T?[?o??SQL Server???C???X?g?[?????Ă????A???n?։^??ł???h???C???ɎQ???????邱?Ƃɂ????B

?@???n?Ńh???C???ɎQ???????A????̋N???͊????????B???????T?[?o???ċN??????ƁASQL Server?̋N???i?K?ŃG???[?????????A????ȍ~?ASQL Server???N?????Ȃ??Ȃ??Ă??܂????B

?g???u???̌?????T??

?@????̓V?X?e???\?z???ɂ????āA????͐???ɋN???????̂ɁA?Ȃ???2??ڂ???SQL Server???N?????Ȃ??Ȃ??Ă??܂????g???u??????ł??B

?@?܂??́AWindows?̃C?x???g???O???m?F???܂??傤?BWindows?C?x???g?r???[?A?[?ŁAOS???O?́u?V?X?e???v???ڂ??m?F????ƁA?u?G???[7000?v???L?^????Ă??܂????i?}1?j?B

?}1?@Windows?C?x???g?r???[?A?[?Ɂu?G???[7000?v???o?͂???Ă???

?@???́u?G???[7000?v?ɂ́A?uSQL Server (MSSQLSERVER) ?T?[?r?X???A???̃G???[???????ŊJ?n?ł??܂???ł???: ???O?I???Ɏ??s???????߁A?T?[?r?X???J?n?ł??܂???ł????v?ƋL?ڂ???Ă??܂????B?܂??A???̒??O?̃??O?u?G???[7041?v?ɂ??A?uMSSQLSERVER ?T?[?r?X?ŁA???ݍ\??????Ă???p?X???[?h?? NT Service\MSSQLSERVER ?Ƃ??ă??O?I???ł??܂???ł????B???̃G???[???????ł?: ???O?I???̎??s: ???̃??[?U?[?ɂ́A?v?????ꂽ???O?I???̎?ނ????̃R???s???[?^?[??ŋ?????Ă??܂???B?T?[?r?X ?A?J?E???g?ɁA?K?v?ȃ??[?U?[?????ł??? "?T?[?r?X?Ƃ??ă??O?I??" ??????܂???v?ƋL?ڂ???Ă??܂????i?}2?j?B

?}2?@???O?̃??O?ɂ́A?u?G???[7041?v???o?͂???Ă???

?@?????2?̃A???[?g???O????ASQL Server?̋N???A?J?E???g?ł???uNT Service\MSSQLSERVER?v?ɃT?[?r?X?Ƃ??ă??O?I?????錠?????Ȃ????????߂ɁA?T?[?r?X???N???ł??Ȃ??????Ɛ???ł??܂??B

?@SQL Server???C???X?g?[??????΁A?????Ƃ??Ă??̃V?X?e???ł̋N???ɕK?v?Ȍ??????????I?ɕt?^????܂??i*1?j?B?A???[?g???O?ɂ??????u?T?[?r?X?Ƃ??ă??O?I???v?̌??????????ŕt?^????錠????1?ł??i?}3?j?B

*1?FConfigure Windows Service Accounts and Permissions?iMicrosoft Developer Network?j

?}3?@SQL Server?C???X?g?[??????̐ݒ?i?T?[?r?X?Ƃ??ă??O?I?????????ꂽ?A?J?E???g?j

?@?ł͍???̎???ł́A?Ȃ????̕K?v?Ȍ??????t?^????Ă??Ȃ??????̂ł??傤?B???́A?O?????ăC???X?g?[????Ƃ????T?[?o?́A?K???ȃ??[?N?O???[?v???̃l?b?g???[?N???ōs???Ă??܂????B

?@?T?[?o??V???Ƀh???C???ɎQ????????ꍇ?A?h???C???Őݒ肵???|???V?[?????ɑ??݂???ꍇ?ɂ́u?????̃|???V?[???㏑???v????܂??B?????Ƃ??A????̍?Ƃɂ????Ă̓T?[?r?X?Ƃ??ă??O?I???̃|???V?[??????`?ł??邽?߂ɁA?h???C???ɎQ???????Ƃ??Ă??|???V?[???㏑??????邱?Ƃ͂???܂???B??????????̏ꍇ?́A?T?[?r?X?Ƃ??ă??O?I???̃|???V?[?????O??Ƃɂ???Ċ??ɒ?`????Ă??܂????B???̂??Ƃ???A?h???C???ɎQ???????}?V???ɑ΂??Č????̑???Ȃ??|???V?[???K?p????Ă??܂??????ƂɂȂ?܂??i?}4?j?B

?}4?@?h???C???Q????̐ݒ?ł́A?T?[?r?X?Ƃ??ă??O?I??????????A?J?E???g???ς???Ă???

?@?Ȃ??u?ŏ??????v?N???????̂́A?h???C???Q????̍ŏ??̋N???ɂ????āA?g?h???C???̃|???V?[???K?p?????O?h??SQL Server???N?????????߂Ɛ??肳??܂??B???????ǂ???ɂ???A?h???C???̃|???V?[???K?p???ꂽ2??ڈȍ~?̋N?????ɂ́A???̃|???V?[??SQL Server?̋N???A?J?E???g???܂܂?Ă??Ȃ????Ƃ???A?u?N???ł??Ȃ??v?ƂȂ??Ă??܂??܂??B

???????@

?֘A?L??

?uSQL Server 2016?v?ɓ??ڂ????V???ȃZ?L?????e?B?΍??ǂ?
?p?u???b?N?v???r???[?????J????Ă???}?C?N???\?t?g??RDB?????ŁuSQL Server 2016?v?B??????1?Ƃ???Z?L?????e?B?΍?@?\?̃|?C???g?Ɩڎw???Ƃ?????L?[?p?[?\???ɕ??????B
?????????A?????[?V???i???f?[?^?x?[?X?Ƃ͉????H
?f?[?^?x?[?X????b????׋?????????[?߂Ă??????Ƃ͊ȒP?Ȃ??Ƃł͂???܂???B?{?A?ڂł́A?f?[?^?x?[?X?ɑ΂???n?[?h?????????ł??Ⴍ???邽?߂ɁA???S?҂̕??ɕK?v?ȃf?[?^?x?[?X?̊?{????A??Q?΍??`???[?j???O?Ƃ????????H?ɑ????????e?܂ł𕝍L????????Ă????܂??B????́A?f?[?^?x?[?X?̖????ƁA??????Ǘ?????\?t?g?E?F?A?ł???DBMS?̊?{?@?\?ɂ??ĉ?????܂??B?y?X?V?z
?f?[?^?̓o?^???s??INSERT??
?????̏??????w?肵??SELECT???????s????
?O??́ASELECT???̏????̏???????????܂????B????́A?????̏??????w?肵?āA?ړI?̃f?[?^?????o?????@????????܂??i?ҏW???j
$Oracle?^?p?̊?{?u???O?v?𗝉????悤$ Oracle?^?p?̊?{?u???O?v?𗝉????悤
?{?A?ڂł́AOracle Database?^?p?̌??ƂȂ?g???u???Ώ??@?ɂ??ďЉ?Ă????܂??B??1??A??2??ł͏????W?̗v?ƂȂ郍?O?ɂ??Č??Ă????܂??B???O?̏o?͏???10g??11g?Ƃł͑傫???قȂ?_??????܂??̂ŁA???ꂼ??ɂ??Ă??m?F???Ă????܂??傤?B