{"id":589,"date":"2013-07-06T16:46:28","date_gmt":"2013-07-06T16:46:28","guid":{"rendered":"http:\/\/piatkosia.k4be.pl\/wordpress\/?p=589"},"modified":"2013-07-06T16:52:53","modified_gmt":"2013-07-06T16:52:53","slug":"polaczenie-sql-z-c-da-sie","status":"publish","type":"post","link":"https:\/\/piatkosia.k4be.pl\/wordpress\/2013\/07\/06\/polaczenie-sql-z-c-da-sie\/","title":{"rendered":"Po\u0142\u0105czenie sql z C#? Da si\u0119."},"content":{"rendered":"<p>Pisz\u0119 sobie aplikacj\u0119 u\u017cywaj\u0105c\u0105 baz\u0119 danych. Robi\u0119 add-> new item -> Service-based Database, i czekam, a\u017c Visual Studio zareaguje (na razie ma brak odpowiedzi). Aj\u0107&#8230;.<\/p>\n<p>Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.<\/p>\n<p>Kopiuj\u0119 swoim zwyczajem do google, a tam ka\u017c\u0105 usun\u0105\u0107<\/p>\n<p>C:\\Users\\uzyszkodnik\\AppData\\Local\\Microsoft\\Microsoft SQL Server Data\\SQLEXPRESS<br \/>\nNiestety, po usuni\u0119ciu mia\u0142am b\u0142\u0105d  &#8222;Timeout expired blablabla&#8221; a po ponownym uruchomieniu b\u0142\u0105d wy\u017cej.<\/p>\n<p>Rozwi\u0105zanie:<br \/>\nWej\u015b\u0107 w SQL Server Configurator Manager (wpisa\u0107 to w pole startu) otworzy si\u0119 wam mmc, wybra\u0107 pod prawym przyciskiem myszy SQL Server (SQLEXPRESS), w karcie w\u0142a\u015bciwo\u015bci da\u0107 &#8222;log on as: built-in account: &#8222;Local system&#8221;&#8221;, zaakceptowa\u0107, a nast\u0119pnie uruchomi\u0107 ponownie serwer (nie ca\u0142y system &#8211; wystarczy restart serwera bazodanowego).<br \/>\nOd tej pory, dzia\u0142aj\u0105 bazy danych z poziomu visual studio.<\/p>\n<p>SOA #1 &#8211; u mnie dzia\u0142a:) A przynajmniej zadzia\u0142a\u0142o.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pisz\u0119 sobie aplikacj\u0119 u\u017cywaj\u0105c\u0105 baz\u0119 danych. Robi\u0119 add-> new item -> Service-based Database, i czekam, a\u017c Visual Studio zareaguje (na razie ma brak odpowiedzi). Aj\u0107&#8230;.&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/piatkosia.k4be.pl\/wordpress\/2013\/07\/06\/polaczenie-sql-z-c-da-sie\/\">Lecim dalej<span class=\"screen-reader-text\">Po\u0142\u0105czenie sql z C#? Da si\u0119.<\/span> <i class=\"fas fa-angle-right\"><\/i><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,148],"tags":[222],"class_list":["post-589","post","type-post","status-publish","format-standard","hentry","category-c_sharp","category-sql","tag-sql","entry"],"_links":{"self":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts\/589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/comments?post=589"}],"version-history":[{"count":4,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts\/589\/revisions"}],"predecessor-version":[{"id":593,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/posts\/589\/revisions\/593"}],"wp:attachment":[{"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/media?parent=589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/categories?post=589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piatkosia.k4be.pl\/wordpress\/wp-json\/wp\/v2\/tags?post=589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}