{"id":1114,"date":"2011-04-12T13:50:02","date_gmt":"2011-04-12T05:50:02","guid":{"rendered":"http:\/\/www.alfredivy.per.sg\/blogger\/?p=1114"},"modified":"2015-11-15T21:35:56","modified_gmt":"2015-11-15T13:35:56","slug":"sql-express-2008","status":"publish","type":"post","link":"https:\/\/www.alfredivy.sg\/blogger\/2011\/04\/sql-express-2008\/","title":{"rendered":"SQL Express 2008"},"content":{"rendered":"<p>This is the first time I used SQL Server 2008 Express.\u00a0 A most interesting experience.\u00a0 First off there are several types, database only, management tools only, both\u00a0 and Advanced Services that comes with reporting services.\u00a0 I installed the database only and tried to reinstall it with Advanced Services and got no where.\u00a0 In the end I removed it and installed the Advanced Services package.<\/p>\n<p>The SQL Server 2008 Express by default on startup will dynamically bind to a random port.\u00a0 If connecting remotely, you need to change this to a static port.\u00a0 You need to configure the port number the database engine is going to listen and enable the interface.\u00a0 Surface Area Configuration Tool?\u00a0 This has been discontinued.<\/p>\n<p>Lastly connecting to Server Express using Management Studio requires you to specify the instance name.\u00a0 For a full SQL Server, you specify the &lt;server name&gt; in the management studio.\u00a0 For SQL Server Express, you have to specify &lt;servername\\instance name&gt;.<\/p>\n<p><a href=\"http:\/\/www.microsoft.com\/express\/Database\/InstallOptions.aspx\" target=\"_blank\">Types of SQL Express<\/a>, <a href=\"http:\/\/support.microsoft.com\/kb\/914277\" target=\"_blank\">Enabling remote access<\/a> <a href=\"http:\/\/sqlblog.com\/blogs\/denis_gobo\/archive\/2007\/11\/20\/3441.aspx\" target=\"_blank\">Surface Area Config<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the first time I used SQL Server 2008 Express.\u00a0 A most interesting experience.\u00a0 First off there are several types, database only, management tools only, both\u00a0 and Advanced Services that comes with reporting services.\u00a0 I installed the database only&hellip; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[213,372],"class_list":["post-1114","post","type-post","status-publish","format-standard","hentry","category-work","tag-sql","tag-work"],"_links":{"self":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/1114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/comments?post=1114"}],"version-history":[{"count":3,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/1114\/revisions"}],"predecessor-version":[{"id":3552,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/1114\/revisions\/3552"}],"wp:attachment":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/media?parent=1114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/categories?post=1114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/tags?post=1114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}