{"id":3748,"date":"2020-04-01T13:41:17","date_gmt":"2020-04-01T13:41:17","guid":{"rendered":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/?post_type=ht_kb&#038;p=3748"},"modified":"2020-11-24T15:31:45","modified_gmt":"2020-11-24T15:31:45","slug":"gdzie-ustawic-port-wykorzystywany-w-komunikacji-z-serwerem-sql","status":"publish","type":"ht_kb","link":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/dokumentacja\/gdzie-ustawic-port-wykorzystywany-w-komunikacji-z-serwerem-sql\/","title":{"rendered":"Gdzie ustawi\u0107 port wykorzystywany w komunikacji z serwerem SQL?"},"content":{"rendered":"<p>Komunikacja aplikacji z serwerem SQL mo\u017ce odbywa\u0107 si\u0119 poprzez port podany przez U\u017cytkownika. Aby ustawi\u0107 w\u0142asny port, za pomoc\u0105 kt\u00f3rego b\u0119dzie odbywa\u0142a si\u0119 komunikacja nale\u017cy w pliku <strong><em>appsettings.json <\/em><\/strong>(znajduj\u0105cym si\u0119 w lokalizacji <em>%ProgramData%<\/em>\\<em>Comarch PPK<\/em>) w sekcji<em> AppConfig<\/em> doda\u0107 pole <strong>CustomPortForSQL<\/strong> wskazuj\u0105c odpowiedni port.<\/p>\n<p>Informacj\u0119, jak odnale\u017a\u0107 port, po kt\u00f3rym powinna nast\u0119powa\u0107 komunikacja aplikacji z serwerem SQL\u00a0 mo\u017cna odnale\u017a\u0107 w pytaniu <a href=\"https:\/\/pomoc.comarch.pl\/optima\/pl\/2019\/index.php\/dokumentacja\/nie-moge-sie-polaczyc-z-serwerem-sql-co-zrobic\/\" target=\"_blank\" rel=\"noopener noreferrer\">Nie mog\u0119 si\u0119 po\u0142\u0105czy\u0107 z serwerem SQL &#8211; co zrobi\u0107?<\/a><\/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 zastosowano port 1433. 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>\"CustomPortForSql\": 1433<\/strong><br \/>\n}<\/code><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"<p>Komunikacja aplikacji z serwerem SQL mo\u017ce odbywa\u0107 si\u0119 poprzez port podany przez U\u017cytkownika. Aby ustawi\u0107 w\u0142asny port, za pomoc\u0105 kt\u00f3rego b\u0119dzie odbywa\u0142a si\u0119 komunikacja nale\u017cy w pliku appsettings.json (znajduj\u0105cym si\u0119 w lokalizacji %ProgramData%\\Comarch PPK) w sekcji AppConfig doda\u0107 pole CustomPortForSQL wskazuj\u0105c odpowiedni port. Informacj\u0119, jak odnale\u017a\u0107 port, po kt\u00f3rym powinna nast\u0119powa\u0107 komunikacja aplikacji z serwerem [&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":3144,"_ht_kb_article_order":0,"_ht_kb_reading_time":1,"footnotes":""},"ht_kb_category":[2],"ht_kb_tag":[],"class_list":["post-3748","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\/3748","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=3748"}],"version-history":[{"count":7,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb\/3748\/revisions"}],"predecessor-version":[{"id":4041,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb\/3748\/revisions\/4041"}],"wp:attachment":[{"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/media?parent=3748"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb_category?post=3748"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/pomoc.comarch.pl\/ppk\/pl\/wp-json\/wp\/v2\/ht_kb_tag?post=3748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}