{"id":106,"date":"2022-01-15T12:13:24","date_gmt":"2022-01-15T11:13:24","guid":{"rendered":"https:\/\/pohoda-mustek.cz\/navod\/?page_id=106"},"modified":"2022-10-12T22:47:04","modified_gmt":"2022-10-12T20:47:04","slug":"pohoda-mssql-win-auth","status":"publish","type":"page","link":"https:\/\/pohoda-mustek.cz\/navod\/pohoda-mssql-win-auth\/","title":{"rendered":"P\u0159ipojen\u00ed k MSSQL serveru \u2013 Win autentizace"},"content":{"rendered":"\n

M\u016fstek: Nastaven\u00ed > \u00da\u010detn\u00ed jednotky<\/p>\n\n\n\n

V m\u016fstku m\u00e1te k dispozici templ\u00e1t p\u0159ipojovac\u00edho \u0159et\u011bzce. V n\u011bm je pot\u0159eba dosadit spr\u00e1vn\u00fd datasource a n\u00e1zev datab\u00e1ze. N\u00e1zev datab\u00e1ze najdete na kart\u011b \u00fa\u010detn\u00ed jednotky. Zji\u0161t\u011bn\u00ed datasource a p\u0159\u00edpadn\u011b u\u017eivatele pod kter\u00fdm je pot\u0159eba m\u016fstek instalovat z\u00e1le\u017e\u00ed na tom kde Pohodu provozujete.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Hostovan\u00e1 Pohoda<\/strong><\/p>\n\n\n\n

Pokud pou\u017e\u00edv\u00e1te profesion\u00e1ln\u011b hostovanou Pohodu, bude v\u0161e pravd\u011bpodobn\u011b p\u0159edem nastaveno a p\u0159ipojen\u00ed pomoc\u00ed Windows autentizace je snadn\u00e9.<\/p>\n\n\n\n

P\u0159\u00edklad connection string hostovan\u00e9 Pohody<\/p>\n\n\n\n

Provider=SQLOLEDB;Data Source=Firma01\\POHODA;Initial Catalog=StwPh_01331209_2022;Integrated Security=SSPI<\/em><\/p>\n\n\n\n

I tak se ale vyplat\u00ed p\u0159ipojen\u00eds hostingem konzultovat. Nap\u0159. iPodnik zakl\u00e1d\u00e1 speci\u00e1ln\u00edho u\u017eivatele pro spou\u0161t\u011bn\u00ed mServeru a je v\u00fdhodn\u00e9 vy\u017e\u00e1dat si p\u0159ipojovac\u00ed \u0159et\u011bzec tohoto u\u017eivatele a m\u016fstek pod t\u00edmto u\u017eivatelem instalovat.<\/p>\n\n\n\n

Pohoda ve firemn\u00ed s\u00edti<\/strong><\/p>\n\n\n\n

Kl\u00ed\u010dov\u00e9 je instalovat m\u016fstek pod u\u017eivatelem s dostate\u010dn\u00fdmi pr\u00e1vy. V p\u0159\u00edkladu n\u00ed\u017ee se jedn\u00e1 o u\u017eivatele info <\/em>kter\u00fd je administr\u00e1torem dan\u00e9ho PC, v prost\u0159ed\u00ed Win serveru sp\u00ed\u0161e najdete u\u017eivatele admin <\/em>nebo adminstrator<\/em>. Sta\u010d\u00ed ale i m\u00e9n\u011b privilegovan\u00fd u\u017eivatel pokud m\u00e1 pot\u0159ebn\u00e1 pr\u00e1va (viz Server Roles na spodn\u00edm obr\u00e1zku).<\/p>\n\n\n\n

Na otestov\u00e1n\u00ed m\u016f\u017eete vyu\u017e\u00edt program Microsoft Server Management Studio, s velkou pravd\u011bpodobnost\u00ed je ji\u017e je instalov\u00e1n a nab\u00eddne V\u00e1m p\u0159ihl\u00e1\u0161en\u00ed.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

P\u0159i p\u0159ihl\u00e1\u0161en\u00ed do Microsoft Server Management Studia je vid\u011bt jm\u00e9no serveru kter\u00e9 pou\u017eijete v p\u0159ipojovac\u00edm \u0159et\u011bzci. Pou\u017eijte Windows Authentication<\/em>.<\/p>\n\n\n\n

Pokud m\u00e1 dan\u00fd Windows u\u017eivatel pot\u0159ebn\u00e1 pr\u00e1va (sysadmin), bude fungovat p\u0159ipojen\u00ed z Pohoda-m\u016fstku instalovan\u00e9ho pod dan\u00fdm u\u017eivatelem.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

P\u0159\u00edklad connection string k lok\u00e1ln\u011b instalovan\u00e9mu MSSQL<\/p>\n\n\n\n

Provider=SQLOLEDB;Data Source=DESKTOP-19LCR3M;Initial Catalog= StwPh_73483460_2020 ;Integrated Security=SSP<\/em><\/p>\n\n\n\n

V\u0161im\u011bte si \u017ee p\u0159i Win Authentizaci nemus\u00edte zad\u00e1vat \u017e\u00e1dn\u00e1 hesla – u\u017eivatel ji\u017e byl rozpozn\u00e1n a ov\u011b\u0159en Windows.<\/p>\n","protected":false},"excerpt":{"rendered":"

M\u016fstek: Nastaven\u00ed > \u00da\u010detn\u00ed jednotky V m\u016fstku m\u00e1te k dispozici templ\u00e1t p\u0159ipojovac\u00edho \u0159et\u011bzce. V n\u011bm je pot\u0159eba dosadit spr\u00e1vn\u00fd datasource a n\u00e1zev datab\u00e1ze. N\u00e1zev datab\u00e1ze najdete na kart\u011b \u00fa\u010detn\u00ed jednotky. Zji\u0161t\u011bn\u00ed datasource a p\u0159\u00edpadn\u011b u\u017eivatele pod kter\u00fdm je pot\u0159eba m\u016fstek instalovat z\u00e1le\u017e\u00ed na tom kde Pohodu provozujete. Hostovan\u00e1 Pohoda Pokud pou\u017e\u00edv\u00e1te profesion\u00e1ln\u011b hostovanou Pohodu, bude … Pokra\u010dov\u00e1n\u00ed textu P\u0159ipojen\u00ed k MSSQL serveru \u2013 Win autentizace<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-106","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages\/106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/comments?post=106"}],"version-history":[{"count":16,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages\/106\/revisions"}],"predecessor-version":[{"id":442,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages\/106\/revisions\/442"}],"wp:attachment":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/media?parent=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}