{"id":3279,"date":"2021-08-25T15:02:23","date_gmt":"2021-08-25T06:02:23","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/?p=3279"},"modified":"2026-01-23T16:00:28","modified_gmt":"2026-01-23T07:00:28","slug":"postgresql%e3%81%8b%e3%82%89mssql%e3%81%b8%e7%a7%bb%e8%a1%8c%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/?p=3279","title":{"rendered":"PostgreSQL\/MySQL\u304b\u3089MSSQL\u3078\u79fb\u884c\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p>\u672c\u30ca\u30ec\u30c3\u30b8\u3067\u306f\u3001ADManager Plus\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092PostgreSQL\u304b\u3089MSSQL\u3078\u79fb\u884c\u3059\u308b\u624b\u9806\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<div class=\"point\">\u203b\u672c\u30ca\u30ec\u30c3\u30b8\u306f\u3001\u672c\u793e\u30da\u30fc\u30b8\uff08<a href=\"https:\/\/www.manageengine.com\/products\/ad-manager\/admanager-kb\/admanager-plus-migration-to-mssql.html\" target=\"_blank\" rel=\"noopener noreferrer\">Steps to migrate ADManager Plus database from PostgreSQL\/MySQL to MS SQL<\/a>\uff09\u3092\u53c2\u7167\u3057\u3066\u304a\u308a\u307e\u3059\u3002<br \/>\n\u203b\u672c\u30da\u30fc\u30b8\u3067\u306f\u3001SQL server 2019\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u307e\u3059\u3002<\/div>\n<p>\uff1c\u76ee\u6b21\uff1e<br \/>\n\u30fb<a href=\"#1\">\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308bMSSQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3<\/a><br \/>\n\u30fb<a href=\"#2\">PostgreSQL\/MySQL\u304b\u3089MSSQL\u3078\u79fb\u884c\u3059\u308b\u624b\u9806<\/a><\/p>\n<h4 id=\"1\">\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308bMSSQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3<\/h4>\n<ul>\n<li>SQL server 2014<\/li>\n<li>SQL server 2016<\/li>\n<li>SQL server 2017<\/li>\n<li>SQL server 2019<\/li>\n<li>SQL server 2022<\/li>\n<\/ul>\n<h4 id=\"2\">PostgreSQL\/MySQL\u304b\u3089MSSQL\u3078\u79fb\u884c\u3059\u308b\u624b\u9806<\/h4>\n<blockquote><p>\uff1c\u624b\u9806\u306e\u6d41\u308c\uff1e<br \/>\n<a href=\"#MSCon\">1. MSSQL Server\u3092\u69cb\u7bc9<\/a><br \/>\n<a href=\"#MSper\">2. MSSQL\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u63a5\u7d9a\u53ef\u80fd\u306a\u6a29\u9650\u3092\u4ed8\u4e0e<\/a><br \/>\n<a href=\"#enable-C\">3. MSSQL Server\u3068\u306e\u63a5\u7d9a\u3092\u6709\u52b9\u5316<\/a><br \/>\n<a href=\"#TCP-FW\">4. UDP\u304a\u3088\u3073TCP\u30dd\u30fc\u30c8\u3092\u958b\u304f(\u203bMSSQL Server\u4e0a\u306e\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u304c\u6709\u52b9\u306a\u5834\u5408\u306e\u307f)<\/a><br \/>\n<a href=\"#migrate\">5. \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u79fb\u884c<\/a><br \/>\n<a href=\"#additional\">\u88dc\u8db3<\/a><\/p><\/blockquote>\n<h5 id=\"MSCon\">1. MSSQL Server\u3092\u69cb\u7bc9<\/h5>\n<ol>\n<li>\u79fb\u884c\u3059\u308b\u5bfe\u8c61\u306eMSSQL\u00a0Server\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u30b5\u30fc\u30d0\u30fc\u4e0a\u3067\u3001<b>SQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\u30fc<\/b>\u3092\u958b\u304f<\/li>\n<li>\u5de6\u30da\u30a4\u30f3\u306b\u3042\u308b[<strong>SQL Server\u306e\u30b5\u30fc\u30d3\u30b9<\/strong>]--&gt;[<strong>SQL Server Browser<\/strong>]\u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d<br \/>\n\uff08\u5b9f\u884c\u3055\u308c\u3066\u306a\u3044\u5834\u5408\u306f\u3001[SQL Server Browser]\u3092\u53f3\u30af\u30ea\u30c3\u30af--&gt;[\u958b\u59cb]\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\uff09<\/li>\n<li>\u5de6\u30da\u30a4\u30f3\u306b\u3042\u308b[<strong>SQL Server \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u69cb\u6210<\/strong>]--&gt;[\uff1c\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\uff1e<strong>\u306e\u30d7\u30ed\u30c8\u30b3\u30eb<\/strong>]--&gt;[<strong>TCP\/IP<\/strong>]\u306b\u3066\u3001TCP\/IP\u3092\u6709\u52b9\u5316<br \/>\n\u203b\u79fb\u884c\u5bfe\u8c61\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u30d7\u30ed\u30c8\u30b3\u30eb\u306b\u5bfe\u3057\u3066\u3001TCP\/IP\u3092\u6709\u52b9\u5316\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<li>[<strong>SQL Native Client\u306e\u69cb\u6210<\/strong>]--&gt;[<strong>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30d7\u30ed\u30c8\u30b3\u30eb<\/strong>]--&gt;[<strong>TCP\/IP<\/strong>]\u306b\u3066\u3001TCP\/IP\u3092\u6709\u52b9\u5316<\/li>\n<li>\u5de6\u30da\u30a4\u30f3\u306b\u3042\u308b[SQL Server\u306e\u30b5\u30fc\u30d3\u30b9]\u3088\u308a\u30b5\u30fc\u30d3\u30b9\u3092\u518d\u8d77\u52d5<\/li>\n<\/ol>\n<h5 id=\"MSper\">2. MSSQL\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u63a5\u7d9a\u53ef\u80fd\u306a\u6a29\u9650\u3092\u4ed8\u4e0e<\/h5>\n[services.msc]--&gt;[ManageEngine ADManager Plus]--&gt;[\u30d7\u30ed\u30d1\u30c6\u30a3]--&gt;[\u30ed\u30b0\u30aa\u30f3]\u30bf\u30d6\u306b\u767b\u9332\u6e08\u307f\u306e\u30e6\u30fc\u30b6\u30fc\u30a2\u30ab\u30a6\u30f3\u30c8\uff08\u4ee5\u4e0b\u3001ADManager Plus\u306e\u30b5\u30fc\u30d3\u30b9\u8d77\u52d5\u30e6\u30fc\u30b6\u30fc\u3068\u3057\u307e\u3059\uff09\u306b\u5bfe\u3057\u3001\u6b21\u306e\u6a29\u9650\u304c\u5fc5\u8981\u3067\u3059\u3002<br \/>\n\u30fb\u79fb\u884c\u5148\u306eMSSQL\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u6a29<br \/>\n\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306b\u5341\u5206\u306a\u6a29\u9650<\/p>\n<div class=\"point\">\n<p>\u79fb\u884c\u6642\u306b\u4f7f\u7528\u3059\u308b\u8a8d\u8a3c\u306b\u3088\u308a\u3001\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b\u65b9\u6cd5\u306f\u7570\u306a\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li>SQL Server\u8a8d\u8a3c\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\uff1aMSSQL\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3068\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u304c\u81ea\u52d5\u7684\u306b\u63d0\u4f9b\u3055\u308c\u307e\u3059\u3002<br \/>\n--&gt;\u7d9a\u3044\u3066\u3001<a href=\"#enable-C\">3. MSSQL Server\u3068\u306e\u63a5\u7d9a\u3092\u6709\u52b9\u5316<\/a> \u306e\u624b\u9806\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/li>\n<li>Windows\u8a8d\u8a3c\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\uff1a<a href=\"#win-per\">\u6a29\u9650\u306e\u4ed8\u4e0e\u65b9\u6cd5\uff08Windows\u8a8d\u8a3c\uff09<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ul>\n<\/div>\n<h6 id=\"win-per\">\u6a29\u9650\u306e\u4ed8\u4e0e\u65b9\u6cd5\uff08Windows\u8a8d\u8a3c\uff09<\/h6>\n<ol>\n<li>sysadmin\u306e\u6a29\u9650\u3092\u6301\u3064\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3001<b>Microsoft SQL Server Management Studio<\/b>\u3092\u958b\u304d\u3001\u4ee5\u4e0b\u306e\u70b9\u3092\u78ba\u8a8d<br \/>\n<blockquote><p>\u30fb\u79fb\u884c\u5148\u306e\u30b5\u30fc\u30d0\u30fc\u3092\u9078\u629e\u3057\u3066\u3044\u308b\u3053\u3068<br \/>\n\u30fbADManager Plus\u306e\u30b5\u30fc\u30d3\u30b9\u8d77\u52d5\u30e6\u30fc\u30b6\u30fc\u304c\u30ea\u30b9\u30c8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u3053\u3068<br \/>\n--&gt;\u4e0a\u8a18\u30e6\u30fc\u30b6\u30fc\u304c\u30ea\u30b9\u30c8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001[\u30ed\u30b0\u30a4\u30f3]\u3092\u53f3\u30af\u30ea\u30c3\u30af--&gt;[\u65b0\u3057\u3044\u30ed\u30b0\u30a4\u30f3]\u3092\u30af\u30ea\u30c3\u30af\u3057\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\n<\/p><\/blockquote>\n<\/li>\n<li>\u30e6\u30fc\u30b6\u30fc\u3092\u53f3\u30af\u30ea\u30c3\u30af--&gt;[<b>\u30d7\u30ed\u30d1\u30c6\u30a3<\/b>]--&gt;[<b>\u30b5\u30fc\u30d0\u30fc\u30ed\u30fc\u30eb<\/b>]\u306b\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u306bsysadmin\u306e\u6a29\u9650\u304c\u4e0e\u3048\u3089\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\n<div class=\"point\">\u203b\u6a29\u9650\u3092\u4e0e\u3048\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001[sysadmin]\u306b\u30c1\u30a7\u30c3\u30af\uff08<a href=\"#minper\">*1<\/a>\uff09\u3092\u5165\u308c\u3066\u304f\u3060\u3055\u3044\u3002\n<\/div>\n<\/li>\n<\/ol>\n<h5 id=\"enable-C\">3. MSSQL Server\u3068\u306e\u63a5\u7d9a\u3092\u6709\u52b9\u5316<\/h5>\n<p>ADManager Plus\u304a\u3088\u3073MSSQL\u00a0Server\u304c\u5225\u306e\u30b5\u30fc\u30d0\u30fc\u4e0a\u3067\u8d77\u52d5\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u6b21\u306e\u624b\u9806\u3092\u5b9f\u65bd\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"point\">\u203bADManager Plus\u304a\u3088\u3073MSSQL\u00a0Server\u304c\u540c\u4e00\u30b5\u30fc\u30d0\u30fc\u4e0a\u306b\u3042\u308b\u5834\u5408\u306f\u3001\u4e0b\u8a18\u3044\u305a\u308c\u304b\u306e\u3046\u3061\u8a72\u5f53\u3059\u308b\u624b\u9806\u3078\u9032\u3093\u3067\u304f\u3060\u3055\u3044\u3002<br \/>\n\u30fbMSSQL Server\u4e0a\u306e\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u304c\u6709\u52b9\u306a\u5834\u5408\uff1a<a href=\"#TCP-FW\">4. UDP\u304a\u3088\u3073TCP\u30dd\u30fc\u30c8\u3092\u958b\u304f<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<br \/>\n\u30fbMSSQL Server\u4e0a\u306e\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u304c\u7121\u52b9\u306a\u5834\u5408\uff1a<a href=\"#migrate\">5. \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u79fb\u884c<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/div>\n<ol>\n<li>ADManager Plus\u304c\u8d77\u52d5\u3057\u3066\u3044\u308b\u30b5\u30fc\u30d0\u30fc\u4e0a\u306b\u3001<strong>SQL native client<\/strong>\u3001<strong>command line utilities<\/strong>\u3001<strong>ODBC Driver<\/strong>\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/li>\n<li>MSSQL Server\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u4ee5\u4e0b2\u3064\u3092\u30b3\u30d4\u30fc\u3057\u3001ADManager Plus\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\bin\u3078\u914d\u7f6e<br \/>\n\u30fb<strong>bcp.exe<\/strong>\u30d5\u30a1\u30a4\u30eb\uff1a<\/p>\n<blockquote><p>Microsoft SQL Server\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\Client SDK\\ODBC\\\uff1c\u30d0\u30fc\u30b8\u30e7\u30f3\uff1e\\Tools\\Binn\\bcp.exe<\/p><\/blockquote>\n<p>\u30fb<strong>bcp.rll<\/strong>\u30d5\u30a1\u30a4\u30eb\uff1a<\/p>\n<blockquote><p>Microsoft SQL Server\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\Client SDK\\ODBC\\\uff1c\u30d0\u30fc\u30b8\u30e7\u30f3\uff1e\\Tools\\Binn\\Resources\\1033\\bcp.rll<\/p><\/blockquote>\n<p>\u203b\uff1c\u30d0\u30fc\u30b8\u30e7\u30f3\uff1e\u3067\u306f\u3001\u3054\u5229\u7528\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u30d5\u30a9\u30eb\u30c0\u30fc\u540d\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u203b\u3054\u5229\u7528\u74b0\u5883\u3054\u3068\u306b\u4e0a\u8a18\u306e\u30d1\u30b9\u3068\u4e00\u90e8\u7570\u306a\u308b\u5834\u5408\u304c\u3054\u3056\u3044\u307e\u3059\u3002\u4e88\u3081\u3054\u4e86\u627f\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ol>\n<h6>SQL native client\u3001command line utilities\u3001ODBC Driver\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h6>\n<table class=\"pdContent\" style=\"height: 417px\" width=\"1176\" cellspacing=\"2px\">\n<tbody>\n<tr class=\"table_decoration11\">\n<td width=\"20%\">SQL server\u306e\u30d0\u30fc\u30b8\u30e7\u30f3<\/td>\n<td width=\"20%\">command line utilities<\/td>\n<td width=\"20%\">Native Client<\/td>\n<td width=\"20%\">ODBC Driver<\/td>\n<\/tr>\n<tr>\n<td class=\"table_decoration11\">2014<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53591\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53591<\/a><\/td>\n<td class=\"table_decoration10\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/www.microsoft.com\/en-US\/download\/details.aspx?id=57606\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.microsoft.com\/en-US\/download\/details.aspx?id=57606<\/a><\/td>\n<\/tr>\n<tr>\n<td class=\"table_decoration11\">2016<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/www.microsoft.com\/ja-JP\/download\/details.aspx?id=56833\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.microsoft.com\/ja-JP\/download\/details.aspx?id=56833<\/a><\/td>\n<td class=\"table_decoration10\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=56833\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=56833<\/a><\/td>\n<\/tr>\n<tr>\n<td class=\"table_decoration11\">2017<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53591\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=53591<\/a><\/td>\n<td class=\"table_decoration10\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=56833\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=56833<\/a><\/td>\n<\/tr>\n<tr>\n<td class=\"table_decoration11\">2019<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/go.microsoft.com\/fwlink\/?linkid=2230791\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/go.microsoft.com\/fwlink\/?linkid=2230791<\/a><\/td>\n<td class=\"table_decoration10\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093<\/td>\n<td class=\"table_decoration10\"><a href=\"https:\/\/go.microsoft.com\/fwlink\/?linkid=2223304\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/go.microsoft.com\/fwlink\/?linkid=2223304<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5 id=\"TCP-FW\">4. UDP\u304a\u3088\u3073TCP\u30dd\u30fc\u30c8\u3092\u958b\u304f<\/h5>\n<p>\u203bMSSQL Server\u4e0a\u306e\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u304c\u6709\u52b9\u306a\u5834\u5408\u306e\u307f\u3001\u30d5\u30a1\u30a4\u30e4\u30fc\u30a6\u30a9\u30fc\u30eb\u306b\u3066UDP\u304a\u3088\u3073TCP\u30dd\u30fc\u30c8\u3092\u958b\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<ul>\n<li>UDP\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30dd\u30fc\u30c8\u756a\u53f7\uff1a1434<\/li>\n<li>TCP\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30dd\u30fc\u30c8\u756a\u53f7\uff1a1433<\/li>\n<li>TCP\u306e\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u624b\u9806\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<br \/>\n1. SQL Server Configuration Manager\u3092\u958b\u304f<br \/>\n2. [SQL Server \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u69cb\u6210]--&gt;[\uff1c\u79fb\u884c\u3059\u308bMSSQL Server\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\uff1e\u306e\u30d7\u30ed\u30c8\u30b3\u30eb]--&gt;[TCP\/IP]--&gt;\u00a0[\u30d7\u30ed\u30d1\u30c6\u30a3]\u3092\u53f3\u30af\u30ea\u30c3\u30af<br \/>\n3. [IP\u30a2\u30c9\u30ec\u30b9]\u30bf\u30d6--&gt;[IPALL]--&gt;[TCP\u30dd\u30fc\u30c8]\u306b\u3066\u78ba\u8a8d<\/li>\n<\/ul>\n<h5 id=\"migrate\">5. \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u79fb\u884c<\/h5>\n<ol>\n<li>ADManager Plus\u3092\u505c\u6b62<\/li>\n<li>ADManager Plus\u306e\u30b5\u30fc\u30d3\u30b9\u8d77\u52d5\u30e6\u30fc\u30b6\u30fc\u3068\u3057\u3066\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u958b\u304f<\/li>\n<li>ADManager Plus\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\bin\u3078\u79fb\u52d5<\/li>\n<li>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c<br \/>\n<blockquote><p><strong>ChangeDB.bat<\/strong><\/p><\/blockquote>\n<\/li>\n<li>\u8868\u793a\u3055\u308c\u305f\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u753b\u9762\u3067\u3001\u4ee5\u4e0b\u306e\u9805\u76ee\u3092\u8a2d\u5b9a<br \/>\n\u30fb\u30b5\u30fc\u30d0\u30fc\u30bf\u30a4\u30d7\uff1aMSSQL\u00a0Server\u3092\u9078\u629e\u3057\u307e\u3059\u3002<br \/>\n\u30fb\u30db\u30b9\u30c8\u540d\uff1aMS SQL server\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f\u30b5\u30fc\u30d0\u30fc\u540d\u307e\u305f\u306fIP\u30a2\u30c9\u30ec\u30b9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n\u30fb\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\uff1acmd &gt;<b>sc query | find \/i \"sql\"<\/b>\u306b\u3088\u308a\u3001\u3054\u78ba\u8a8d\u3044\u305f\u3060\u3051\u307e\u3059\u3002<br \/>\n\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\uff1aSQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u306e[\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9]\u914d\u4e0b\u306e\u30ea\u30b9\u30c8\u3088\u308a\u3001\u3054\u78ba\u8a8d\u3044\u305f\u3060\u3051\u307e\u3059\u3002<\/p>\n<div class=\"point\">[\u81ea\u52d5\u691c\u51fa]\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001MS SQL Server\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3092\u624b\u52d5\u3067\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n(\u4efb\u610f)SSL\u8a3c\u660e\u66f8\u3092\u9069\u7528\u3059\u308b\u5834\u5408\u306f\u3001<a href=\"#SSL\">SSL\u8a3c\u660e\u66f8\u306e\u9069\u7528\u65b9\u6cd5<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/li>\n<li>\u8a8d\u8a3c\u30bf\u30a4\u30d7\u3092\u9078\u629e<br \/>\n\u30fbWindows\u8a8d\u8a3c\u3092\u9078\u629e\u3057\u305f\u5834\u5408\uff1a\u8cc7\u683c\u60c5\u5831\u304c\u81ea\u52d5\u5165\u529b\u3055\u308c\u307e\u3059\u3002<br \/>\n\u30fbSQL Server\u8a8d\u8a3c\u3092\u9078\u629e\u3057\u305f\u5834\u5408\uff1a\u5fc5\u8981\u306a\u8cc7\u683c\u60c5\u5831\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<li>[\u63a5\u7d9a\u30c6\u30b9\u30c8]\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u8cc7\u683c\u60c5\u5831\u304c\u6b63\u3057\u3044\u3053\u3068\u3092\u78ba\u8a8d<\/li>\n<li>\u8a2d\u5b9a\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<br \/>\n\u79fb\u884c\u624b\u9806\u304c\u958b\u59cb\u3055\u308c\u3001\u5b8c\u4e86\u3059\u308b\u307e\u3067\u306b\u6570\u5206\u304b\u304b\u308a\u307e\u3059\u3002<\/li>\n<\/ol>\n<h5 id=\"additional\">\u88dc\u8db3<\/h5>\n<ul>\n<li><a href=\"#minper\">\u6700\u5c0f\u9650\u306e\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b\u5834\u5408<\/a><\/li>\n<li><a href=\"#SSL\">SSL\u8a3c\u660e\u66f8\u306e\u9069\u7528\u65b9\u6cd5<\/a><\/li>\n<\/ul>\n<h6 id=\"minper\">*1: \u6700\u5c0f\u9650\u306esysadmin\u306e\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b\u5834\u5408<\/h6>\n<p>sysadmin\u306e\u5f79\u5272\u306e\u4ed8\u4e0e\u304c\u96e3\u3057\u304f\u3001\u6700\u5c0f\u9650\u306e\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b\u5834\u5408\u306f\u3001\u6b21\u306e\u624b\u9806\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<ol>\n<li>\u30e6\u30fc\u30b6\u30fc\u3092\u53f3\u30af\u30ea\u30c3\u30af--&gt;[<b>\u30d7\u30ed\u30d1\u30c6\u30a3<\/b>]--&gt;[<b>\u30e6\u30fc\u30b6\u30fc\u30de\u30c3\u30d4\u30f3\u30b0<\/b>]\u306b\u3066\u3001\u4ee5\u4e0b3\u70b9\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b<br \/>\n<b>\u30fbdb_datareader<\/b><br \/>\n<b>\u30fbdb_datawriter<\/b><br \/>\n<b>\u30fbdb_ddladmin<\/b>\n<\/li>\n<li>\u30e6\u30fc\u30b6\u30fc\u3092\u53f3\u30af\u30ea\u30c3\u30af--&gt;[<b>\u30d7\u30ed\u30d1\u30c6\u30a3<\/b>]--&gt;[<b>\u72b6\u614b<\/b>]--&gt;[<b>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u306b\u63a5\u7d9a\u3059\u308b\u6a29\u9650<\/b>]\u306b\u3066\u3001[<b>\u8a31\u53ef<\/b>]\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\n<\/li>\n<li>\u753b\u9762\u4e0a\u90e8\u306b\u3042\u308b[<b>\u65b0\u3057\u3044\u30af\u30a8\u30ea<\/b>]\u306b\u3066\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c<br \/>\n<blockquote><p><b>GRANT CONTROL ON CERTIFICATE::[ZOHO_CERT] TO [newly_created_user]<\/b><br \/>\n\u30fb[ZOHO_CERT]\u306b\u306f\u3001\u8a3c\u660e\u66f8\u540d\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n\u30fb[newly_created_user]\u306b\u306f\u3001\u65b0\u898f\u4f5c\u6210\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u3092\u5165\u529b\u3057\u307e\u3059\u3002\n<\/p><\/blockquote>\n<\/li>\n<\/ol>\n<h6 id=\"SSL\">SSL\u8a3c\u660e\u66f8\u306e\u9069\u7528\u65b9\u6cd5<\/h6>\n<p>SSL\u8a3c\u660e\u66f8\u3092\u9069\u7528\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u624b\u9806\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<br \/>\n<b>\u203bSSL\u8a3c\u660e\u66f8\u306e\u9069\u7528\u524d\u306b\u3001\u4e0a\u8a18\u624b\u9806(\u624b\u98068\u307e\u3067)\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/b><br \/>\n<a href=\"#SSL1\">1. \u4f5c\u6210\u3057\u305fSSL\u8a3c\u660e\u66f8\u3092ADManager Plus\u306b\u9069\u7528<\/a><br \/>\n<a href=\"#SSL2\">2. MSSQL Server\u3067SSL\u3092\u6709\u52b9\u5316<\/a><\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li id=\"SSL1\">\u4f5c\u6210\u3057\u305fSSL\u8a3c\u660e\u66f8\u3092ADManager Plus\u306b\u9069\u7528<br \/>\n\u672c\u793e\u30da\u30fc\u30b8\uff08<a href=\"https:\/\/www.manageengine.com\/products\/ad-manager\/admanager-kb\/how-to-install-ssl-certificate-in-admanager-plus.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to install an SSL certificate in ADManager Plus<\/a>\uff09\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/li>\n<li id=\"SSL2\">MSSQL Server\u3067SSL\u3092\u6709\u52b9\u5316\n<ol>\n<li>SQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u3092\u958b\u304f<\/li>\n<li>[<strong>SQL Server\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u69cb\u6210<\/strong>]--&gt;[\uff1c\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\uff1e<strong>\u306e\u30d7\u30ed\u30d1\u30c6\u30a3<\/strong>]--&gt;[<strong>\u30d7\u30ed\u30d1\u30c6\u30a3<\/strong>]\u3092\u958b\u304f<\/li>\n<li>[<strong>\u8a3c\u660e\u66f8<\/strong>]\u30bf\u30d6--&gt;[<strong>\u30a4\u30f3\u30dd\u30fc\u30c8<\/strong>]--&gt;\u8868\u793a\u3055\u308c\u305f\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u753b\u9762\u306b\u3066\u8a3c\u660e\u66f8\u3092\u30a4\u30f3\u30dd\u30fc\u30c8<\/li>\n<li>[<strong>\u30d5\u30e9\u30b0<\/strong>]\u30bf\u30d6--&gt;[<strong>\u5f37\u5236\u7684\u306b\u6697\u53f7\u5316<\/strong>]--&gt;[<strong>\u306f\u3044]<\/strong>\u3092\u9078\u629e--&gt;\u9069\u7528<\/li>\n<li><span class=\"highlight\"><b>-Djsse.enableCBCProtection=false<\/b><\/span>\u3092\u3001\u4ee5\u4e0b\uff12\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u8ffd\u8a18<br \/>\n<blockquote><p>\u30fb<strong>run.bat\u30d5\u30a1\u30a4\u30eb<\/strong>\uff1aADManager Plus\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\bin\u306b\u3054\u3056\u3044\u307e\u3059\u3002<br \/>\n<\/a><br \/>\n\u30fb<strong>wrapper.conf\u30d5\u30a1\u30a4\u30eb<\/strong>\uff1aADManager Plus\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\conf\u306b\u3054\u3056\u3044\u307e\u3059\u3002\n<\/p><\/blockquote>\n<\/li>\n<li><span class=\"highlight\"><b>ssl\\=require<\/b><\/span>\u3092\u3001<strong>database_params.conf<\/strong>\u30d5\u30a1\u30a4\u30eb\u306b\u8ffd\u8a18<br \/>\n<b>database_params.conf\u30d5\u30a1\u30a4\u30eb<\/b>\uff1aADManager Plus_\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc\\conf\u306b\u3054\u3056\u3044\u307e\u3059\u3002\n<\/li>\n<li>MSSQL Server\u304a\u3088\u3073ADManager Plus\u3092\u305d\u308c\u305e\u308cWindows\u30b5\u30fc\u30d3\u30b9\u3068\u3057\u3066\u518d\u8d77\u52d5<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<div class=\"point\">\n<p>\u63a5\u7d9a\u304c\u6697\u53f7\u5316\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<blockquote><p><b>select * from sys.dm_exec_connections where client_net_address='';<\/b><\/p><\/blockquote>\n<p>\u6697\u53f7\u5316\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001encrypt_option\u5217\u306e\u5024\u306f\u300cTRUE\u300d\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u30ca\u30ec\u30c3\u30b8\u3067\u306f\u3001ADManager Plus\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092PostgreSQL\u304b\u3089MSSQL\u3078\u79fb\u884c\u3059\u308b\u624b\u9806\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u203b\u672c\u30ca\u30ec\u30c3\u30b8\u306f\u3001\u672c\u793e\u30da\u30fc\u2026 <a href=\"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/?p=3279\" class=\"more\">\uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-3279","post","type-post","status-publish","format-standard","hentry","category-config-sdp"],"modified_by":"kosei","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=\/wp\/v2\/posts\/3279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3279"}],"version-history":[{"count":66,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=\/wp\/v2\/posts\/3279\/revisions"}],"predecessor-version":[{"id":6448,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=\/wp\/v2\/posts\/3279\/revisions\/6448"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ADManager_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}