{"id":3914,"date":"2020-07-29T14:30:30","date_gmt":"2020-07-29T14:30:30","guid":{"rendered":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/?post_type=ht_kb&#038;p=3914"},"modified":"2021-04-26T09:56:20","modified_gmt":"2021-04-26T09:56:20","slug":"gdzie-ustawic-recznie-nazwe-serwera-sql","status":"publish","type":"ht_kb","link":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/dokumentacja\/gdzie-ustawic-recznie-nazwe-serwera-sql\/","title":{"rendered":"Gdzie ustawi\u0107 r\u0119cznie nazw\u0119 serwera SQL?"},"content":{"rendered":"<p>Aby ustawi\u0107 r\u0119cznie nazw\u0119 serwera SQL nale\u017cy w pliku <strong><em>appsettings.json\u00a0<\/em><\/strong>(znajduj\u0105cym si\u0119 w lokalizacji\u00a0<em>%ProgramData%<\/em>\\<em>Comarch PPK<\/em>) w sekcji<em>\u00a0AppConfig<\/em> doda\u0107 wpis <strong>&#8222;<\/strong><b>ServerOverride&#8221;: <\/b>wskazuj\u0105c nazw\u0119 odpowiedniego serwera.<\/p>\n<section class=\"msp-alert-box msp-alert-example\"><div class=\"msp-alert-icon\"><svg width=\"16\" height=\"16\" class=\"kb-icon kb-icon--bulb\" aria-hidden=\"true\" focusable=\"false\" viewBox=\"0 0 32 32\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\">\r\n    <g id=\"[AP]-Iconography\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\">\r\n        <g id=\"Iconography_sortowanie-po-kategorii\" transform=\"translate(-1193.000000, -12329.000000)\" fill=\"currentColor\">\r\n            <g id=\"Group-8\" transform=\"translate(286.000000, 548.000000)\">\r\n                <g id=\"Iconography-Card-\" transform=\"translate(859.000000, 11741.000000)\">\r\n                    <g id=\"0-Icons\/-24-\/-Things-\/-Bulb\" transform=\"translate(48.000000, 40.000000)\">\r\n                        <path d=\"M16.9993333,20.6593333 L16.9993333,18.2126667 C18.554,17.7726667 19.702,16.3566667 19.702,14.6633333 C19.702,14.1113333 19.254,13.6633333 18.702,13.6633333 C18.1486667,13.6633333 17.702,14.1113333 17.702,14.6633333 C17.702,15.6033333 16.938,16.3673333 15.9993333,16.3673333 C15.0606667,16.3673333 14.298,15.6033333 14.298,14.6633333 C14.298,14.1113333 13.85,13.6633333 13.298,13.6633333 C12.7446667,13.6633333 12.298,14.1113333 12.298,14.6633333 C12.298,16.3566667 13.446,17.7726667 14.9993333,18.2126667 L14.9993333,20.6593333 C10.8686667,20.1633333 7.65666667,16.6433333 7.65666667,12.382 C7.65666667,7.782 11.3993333,4.03933333 15.9993333,4.03933333 C20.5993333,4.03933333 24.3433333,7.782 24.3433333,12.382 C24.3433333,16.6433333 21.13,20.1633333 16.9993333,20.6593333 L16.9993333,20.6593333 Z M15.9993333,27.9606667 C14.8833333,27.9606667 13.95,27.2126667 13.6433333,26.194 L18.3553333,26.194 C18.05,27.2126667 17.1153333,27.9606667 15.9993333,27.9606667 L15.9993333,27.9606667 Z M12.7406667,24.194 L19.258,24.194 L19.258,23.002 L12.7406667,23.002 L12.7406667,24.194 Z M26.3433333,12.382 C26.3433333,6.678 21.702,2.03933333 15.9993333,2.03933333 C10.2966667,2.03933333 5.65666667,6.678 5.65666667,12.382 C5.65666667,16.366 7.92333333,19.8246667 11.2326667,21.5513333 C10.93,21.8686667 10.742,22.2953333 10.742,22.7673333 L10.742,24.43 C10.742,25.0593333 11.0753333,25.6086667 11.574,25.9206667 C11.794,28.182 13.6833333,29.9606667 16.0006667,29.9606667 C18.3166667,29.9606667 20.206,28.182 20.426,25.9206667 C20.9233333,25.6086667 21.258,25.0593333 21.258,24.43 L21.258,22.7673333 C21.258,22.2953333 21.07,21.8686667 20.766,21.5513333 C24.0753333,19.8246667 26.3433333,16.366 26.3433333,12.382 L26.3433333,12.382 Z\" id=\"Color\"><\/path>\r\n                    <\/g>\r\n                <\/g>\r\n            <\/g>\r\n        <\/g>\r\n    <\/g>\r\n<\/svg><\/div><div class=\"msp-alert-body\"><div class=\"msp-alert-title\">Przyk\u0142ad<\/div><div class=\"msp-alert-content\"><p>W poni\u017cszym przyk\u0142adzie u\u017cyto serwera &#8222;SQL_2016&#8221;. Dodatkowo nale\u017cy pami\u0119ta\u0107 o dodaniu przecinka na ko\u0144cu zmiennej powy\u017cej dodanego wpisu.<br \/>\n<code>\"AppConfig\": {<br \/>\n\"UseExternalProvider\": false,<br \/>\n\"ExternalProviderFilePath\": \"\",<br \/>\n\"UseExtraFieldForLogin\": false,<br \/>\n\"ExtraFieldLabel\": \"\",<br \/>\n\"ExtraFieldSelectValues\": [],<br \/>\n\"Port\": \"\",<br \/>\n\"DatabaseFolder\": \"\",<br \/>\n\"MLServerUri\": \"\"<strong>,<\/strong><br \/>\n<strong>\"ServerOverride\": \"SQL_2016\"<\/strong><br \/>\n}<\/code><\/div><\/div><\/section>\n<p><strong>W przypadku, gdy dost\u0119p do serwera SQL jest mo\u017cliwy tylko poprzez jego adres IP to zamiast jego nazwy nale\u017cy poda\u0107 jego adres IP.<\/strong><\/p>\n<section class=\"msp-alert-box msp-alert-example\"><div class=\"msp-alert-icon\"><svg width=\"16\" height=\"16\" class=\"kb-icon kb-icon--bulb\" aria-hidden=\"true\" focusable=\"false\" viewBox=\"0 0 32 32\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\">\r\n    <g id=\"[AP]-Iconography\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\">\r\n        <g id=\"Iconography_sortowanie-po-kategorii\" transform=\"translate(-1193.000000, -12329.000000)\" fill=\"currentColor\">\r\n            <g id=\"Group-8\" transform=\"translate(286.000000, 548.000000)\">\r\n                <g id=\"Iconography-Card-\" transform=\"translate(859.000000, 11741.000000)\">\r\n                    <g id=\"0-Icons\/-24-\/-Things-\/-Bulb\" transform=\"translate(48.000000, 40.000000)\">\r\n                        <path d=\"M16.9993333,20.6593333 L16.9993333,18.2126667 C18.554,17.7726667 19.702,16.3566667 19.702,14.6633333 C19.702,14.1113333 19.254,13.6633333 18.702,13.6633333 C18.1486667,13.6633333 17.702,14.1113333 17.702,14.6633333 C17.702,15.6033333 16.938,16.3673333 15.9993333,16.3673333 C15.0606667,16.3673333 14.298,15.6033333 14.298,14.6633333 C14.298,14.1113333 13.85,13.6633333 13.298,13.6633333 C12.7446667,13.6633333 12.298,14.1113333 12.298,14.6633333 C12.298,16.3566667 13.446,17.7726667 14.9993333,18.2126667 L14.9993333,20.6593333 C10.8686667,20.1633333 7.65666667,16.6433333 7.65666667,12.382 C7.65666667,7.782 11.3993333,4.03933333 15.9993333,4.03933333 C20.5993333,4.03933333 24.3433333,7.782 24.3433333,12.382 C24.3433333,16.6433333 21.13,20.1633333 16.9993333,20.6593333 L16.9993333,20.6593333 Z M15.9993333,27.9606667 C14.8833333,27.9606667 13.95,27.2126667 13.6433333,26.194 L18.3553333,26.194 C18.05,27.2126667 17.1153333,27.9606667 15.9993333,27.9606667 L15.9993333,27.9606667 Z M12.7406667,24.194 L19.258,24.194 L19.258,23.002 L12.7406667,23.002 L12.7406667,24.194 Z M26.3433333,12.382 C26.3433333,6.678 21.702,2.03933333 15.9993333,2.03933333 C10.2966667,2.03933333 5.65666667,6.678 5.65666667,12.382 C5.65666667,16.366 7.92333333,19.8246667 11.2326667,21.5513333 C10.93,21.8686667 10.742,22.2953333 10.742,22.7673333 L10.742,24.43 C10.742,25.0593333 11.0753333,25.6086667 11.574,25.9206667 C11.794,28.182 13.6833333,29.9606667 16.0006667,29.9606667 C18.3166667,29.9606667 20.206,28.182 20.426,25.9206667 C20.9233333,25.6086667 21.258,25.0593333 21.258,24.43 L21.258,22.7673333 C21.258,22.2953333 21.07,21.8686667 20.766,21.5513333 C24.0753333,19.8246667 26.3433333,16.366 26.3433333,12.382 L26.3433333,12.382 Z\" id=\"Color\"><\/path>\r\n                    <\/g>\r\n                <\/g>\r\n            <\/g>\r\n        <\/g>\r\n    <\/g>\r\n<\/svg><\/div><div class=\"msp-alert-body\"><div class=\"msp-alert-title\">Przyk\u0142ad<\/div><div class=\"msp-alert-content\"><p>W poni\u017cszym przyk\u0142adzie u\u017cyto serwera o IP: 10.100.1.10.<\/p>\n<p><code>\"AppConfig\": {<br \/>\n\"UseExternalProvider\": false,<br \/>\n\"ExternalProviderFilePath\": \"\",<br \/>\n\"UseExtraFieldForLogin\": false,<br \/>\n\"ExtraFieldLabel\": \"\",<br \/>\n\"ExtraFieldSelectValues\": [],<br \/>\n\"Port\": \"\",<br \/>\n\"DatabaseFolder\": \"\",<br \/>\n\"MLServerUri\": \"\",<br \/>\n\"ServerOverride\": \"10.100.1.10\"<br \/>\n}<br \/>\n<\/code><\/div><\/div><\/section>\n<p>W przypadku, gdy serwer SQL posiada nazwan\u0105 instancj\u0119 nale\u017cy j\u0105 poprzedzi\u0107 dwoma znakami &#8222;\\&#8221;<\/p>\n<section class=\"msp-alert-box msp-alert-example\"><div class=\"msp-alert-icon\"><svg width=\"16\" height=\"16\" class=\"kb-icon kb-icon--bulb\" aria-hidden=\"true\" focusable=\"false\" viewBox=\"0 0 32 32\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\">\r\n    <g id=\"[AP]-Iconography\" stroke=\"none\" stroke-width=\"1\" fill=\"none\" fill-rule=\"evenodd\">\r\n        <g id=\"Iconography_sortowanie-po-kategorii\" transform=\"translate(-1193.000000, -12329.000000)\" fill=\"currentColor\">\r\n            <g id=\"Group-8\" transform=\"translate(286.000000, 548.000000)\">\r\n                <g id=\"Iconography-Card-\" transform=\"translate(859.000000, 11741.000000)\">\r\n                    <g id=\"0-Icons\/-24-\/-Things-\/-Bulb\" transform=\"translate(48.000000, 40.000000)\">\r\n                        <path d=\"M16.9993333,20.6593333 L16.9993333,18.2126667 C18.554,17.7726667 19.702,16.3566667 19.702,14.6633333 C19.702,14.1113333 19.254,13.6633333 18.702,13.6633333 C18.1486667,13.6633333 17.702,14.1113333 17.702,14.6633333 C17.702,15.6033333 16.938,16.3673333 15.9993333,16.3673333 C15.0606667,16.3673333 14.298,15.6033333 14.298,14.6633333 C14.298,14.1113333 13.85,13.6633333 13.298,13.6633333 C12.7446667,13.6633333 12.298,14.1113333 12.298,14.6633333 C12.298,16.3566667 13.446,17.7726667 14.9993333,18.2126667 L14.9993333,20.6593333 C10.8686667,20.1633333 7.65666667,16.6433333 7.65666667,12.382 C7.65666667,7.782 11.3993333,4.03933333 15.9993333,4.03933333 C20.5993333,4.03933333 24.3433333,7.782 24.3433333,12.382 C24.3433333,16.6433333 21.13,20.1633333 16.9993333,20.6593333 L16.9993333,20.6593333 Z M15.9993333,27.9606667 C14.8833333,27.9606667 13.95,27.2126667 13.6433333,26.194 L18.3553333,26.194 C18.05,27.2126667 17.1153333,27.9606667 15.9993333,27.9606667 L15.9993333,27.9606667 Z M12.7406667,24.194 L19.258,24.194 L19.258,23.002 L12.7406667,23.002 L12.7406667,24.194 Z M26.3433333,12.382 C26.3433333,6.678 21.702,2.03933333 15.9993333,2.03933333 C10.2966667,2.03933333 5.65666667,6.678 5.65666667,12.382 C5.65666667,16.366 7.92333333,19.8246667 11.2326667,21.5513333 C10.93,21.8686667 10.742,22.2953333 10.742,22.7673333 L10.742,24.43 C10.742,25.0593333 11.0753333,25.6086667 11.574,25.9206667 C11.794,28.182 13.6833333,29.9606667 16.0006667,29.9606667 C18.3166667,29.9606667 20.206,28.182 20.426,25.9206667 C20.9233333,25.6086667 21.258,25.0593333 21.258,24.43 L21.258,22.7673333 C21.258,22.2953333 21.07,21.8686667 20.766,21.5513333 C24.0753333,19.8246667 26.3433333,16.366 26.3433333,12.382 L26.3433333,12.382 Z\" id=\"Color\"><\/path>\r\n                    <\/g>\r\n                <\/g>\r\n            <\/g>\r\n        <\/g>\r\n    <\/g>\r\n<\/svg><\/div><div class=\"msp-alert-body\"><div class=\"msp-alert-title\">Przyk\u0142ad<\/div><div class=\"msp-alert-content\">W poni\u017cszym przyk\u0142adzie u\u017cyto instancji OPTIMA:<\/p>\n<p><strong>SQL_2016\\\\OPTIMA<\/strong><\/p>\n<p><strong>10.100.1.10\\\\OPTIMA<\/strong><\/p><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"<p>Aby ustawi\u0107 r\u0119cznie nazw\u0119 serwera SQL nale\u017cy w pliku appsettings.json\u00a0(znajduj\u0105cym si\u0119 w lokalizacji\u00a0%ProgramData%\\Comarch PPK) w sekcji\u00a0AppConfig doda\u0107 wpis &#8222;ServerOverride&#8221;: wskazuj\u0105c nazw\u0119 odpowiedniego serwera. W przypadku, gdy dost\u0119p do serwera SQL jest mo\u017cliwy tylko poprzez jego adres IP to zamiast jego nazwy nale\u017cy poda\u0107 jego adres IP. W przypadku, gdy serwer SQL posiada nazwan\u0105 instancj\u0119 nale\u017cy [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_ht_kb_usefulness":1,"_ht_kb_post_views_count":3439,"_ht_kb_article_order":0,"_ht_kb_reading_time":1,"footnotes":""},"ht_kb_category":[2],"ht_kb_tag":[],"class_list":["post-3914","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-instalacja-i-aktualizacje"],"_links":{"self":[{"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb\/3914","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/comments?post=3914"}],"version-history":[{"count":12,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb\/3914\/revisions"}],"predecessor-version":[{"id":4227,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb\/3914\/revisions\/4227"}],"wp:attachment":[{"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/media?parent=3914"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb_category?post=3914"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb_tag?post=3914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}