{"id":18,"date":"2014-11-10T15:23:00","date_gmt":"2014-11-10T15:23:00","guid":{"rendered":""},"modified":"2016-01-30T23:23:00","modified_gmt":"2016-01-30T23:23:00","slug":"fixing-empty-sql-server-list-in-entity-data-model-wizard","status":"publish","type":"post","link":"https:\/\/tpodolak.com\/blog\/2014\/11\/10\/fixing-empty-sql-server-list-in-entity-data-model-wizard\/","title":{"rendered":"Fixing empty SQL server list in “Entity Data Model Wizard”"},"content":{"rendered":"

I consider myself as a quite experienced user of Nhibernate, that is why I decided to check what is going on on the other side of barricade and started playing with Entity Framework. I followed the steps of some tutorial and I stuck at the very beginning of it. I was about to generate model classes using “Entity Data Model Wizard” but it turned out that the wizard could not find my SQL server (despite the fact that server itself was up and running).
\n\"empty<\/a>
\nI remember having similar issue a while back, but at that time I wasn’t able to solve it (I ended up creating connections string manually). This time I wanted to give this issue a closer look. After a bit of digging I found the problem – the SQL server wasn’t broadcasting information about itself. In order to fix it and make the server visible to other computers and applications it is necessary to start SQL Server Browser<\/i> service. To do that go to Start -> Run<\/i> and type Services.msc<\/i>
\n\"runservices\"<\/a>
\nThen in newly opened window find SQL Server Browser<\/i> service
\n\"SqlServerBrowser\"<\/a>
\nDouble click it and set up startup type to Automatic<\/i>. You can also click Start<\/i> button to make sure that service starts immediately
\n\"automaticserverbrowser\"<\/a>
\nFrom now on SQL servers should be visible in “Entity Data Model Wizard”
\n\"filledserverlist\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

I consider myself as a quite experienced user of Nhibernate, that is why I decided to check what is going on on the other side of barricade and started playing with Entity Framework. I followed the steps of some tutorial and I stuck at the very beginning of it. I was about to generate model […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,39,36,37,38],"tags":[182,183,184,185,186],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-ef","category-entity-framework","category-mssql","category-sql","category-visual-studio","tag-ef","tag-entity-framework","tag-mssql","tag-sql","tag-visual-studio"],"_links":{"self":[{"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/comments?post=18"}],"version-history":[{"count":4,"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/posts\/18\/revisions"}],"predecessor-version":[{"id":530,"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/posts\/18\/revisions\/530"}],"wp:attachment":[{"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/media?parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/categories?post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tpodolak.com\/blog\/wp-json\/wp\/v2\/tags?post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}