{"id":79,"date":"2005-11-21T03:01:16","date_gmt":"2005-11-21T07:01:16","guid":{"rendered":"http:\/\/www.soulhuntre.com\/items\/date\/2005\/11\/21\/upgrading-to-sql-server-express-2005-on-plesk-for-windows\/"},"modified":"2005-11-21T03:01:16","modified_gmt":"2005-11-21T07:01:16","slug":"upgrading-to-sql-server-express-2005-on-plesk-for-windows","status":"publish","type":"post","link":"http:\/\/legacyiamsenseiken.local\/2005\/11\/21\/upgrading-to-sql-server-express-2005-on-plesk-for-windows\/","title":{"rendered":"Upgrading to Sql Server Express 2005 on Plesk for Windows"},"content":{"rendered":"<p>Ok, that was interesting.<\/p>\n<p>I maintain several <a href=\"http:\/\/www.swsoft.com\/\">Plesk<\/a> servers for clients, some <a href=\"http:\/\/www.microsoft.com\/\">Windows<\/a> and some <a href=\"http:\/\/www.linux.org\/\">Linux<\/a>. Under the current version (7.5.4 for Windows) there is a need to support the <a href=\"http:\/\/www.asp.net\/\">Asp.NET 2.0<\/a> framework and the tools that come with it. After much research and holding of breath, I took the leap and did an upgrade.<\/p>\n<p><b><i>I take no responsibility for this information if it screws up your server. That&#8217;s your own problem. Get it? Use this information at your own risk!<\/i><\/b><\/p>\n<p>Here are the steps I took:<\/p>\n<ul>\n<li>Backed up all my data<\/li>\n<li>Installed the <a href=\"http:\/\/msdn.microsoft.com\/netframework\/downloads\/updates\/default.aspx\">ASP.NET 2.0 framework<\/a> runtime<\/li>\n<li>Grabbed the &#8220;sa&#8221; password for the installed MSDE system (I copied the steps to do that to below the fold, but they are <a href=\"http:\/\/forum.swsoft.com\/showthread.php?s=ae186cf30cc44dcc6d0cf830ddf59cb3&amp;threadid=17402&amp;perpage=15&amp;highlight=sql server password&amp;pagenumber=2\">also on the Plesk support forum<\/a>)<\/li>\n<li>Downloaded the <a href=\"http:\/\/www.microsoft.com\/sql\/editions\/express\/default.mspx\">Microsoft SQL Server Express Edition<\/a><\/li>\n<li>Created a machine account to use to run SQL Server&#8230; you can call it anything you want, it need no special access and a regular user account is fine (remember the username and password)<\/li>\n<li>Installed SQL Server Express as an upgrade (when it asks for what user account to run under, pick &#8220;domain account&#8221; and give it your user info from the previous step, you can leave the domain field empty)<\/li>\n<li>Installed <a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&amp;displaylang=en\">Microsoft SQL Server Management Studio Express<\/a><\/li>\n<li>Used Studio Express to verify that my MSDE upgrade went fine (it did)<\/li>\n<li>Checked via Plesk to be sure everything was fine (it was)<\/li>\n<li>Opened (carefully!) the ports needed to connect remotely &#8211; good information <a href=\"http:\/\/blogs.msdn.com\/sqlexpress\/archive\/2005\/05\/05\/415084.aspx\">here<\/a>, <a href=\"http:\/\/www.aquafold.com\/docs-register-express.html\">here<\/a> and <a href=\"http:\/\/download.microsoft.com\/download\/f\/1\/1\/f11aec2c-54d1-4b49-b339-5ccb265a5741\/ReadmeSSMSE2005.htm#connect_sse\">here<\/a><\/li>\n<\/ul>\n<p>Basically, the upgrade was painless and did exactly what it was supposed to do.<\/p>\n<p><!--more--><\/p>\n<blockquote>\n<p><u><b>Big shout out to &#8220;shortcut&#8221; on the Plesk forums!<\/b><i> <\/i><\/u>&nbsp;(<a href=\"http:\/\/forum.swsoft.com\/showthread.php?s=ae186cf30cc44dcc6d0cf830ddf59cb3&amp;threadid=17402&amp;perpage=15&amp;highlight=sql server password&amp;pagenumber=2\">see thread<\/a>)<\/p>\n<p>The latest versions of plesk for windows, 7.5.x have relocated the psa database to a mysql <font color=\"red\">server<\/font> running on port 8306 instead of standard port 3306 mixed up with all the client databases. <\/p>\n<p>This information is in the 8306 database, AS WELL AS the &#8216;admin&#8217; <font color=\"red\">password<\/font> for the standard client database running on port 3306.<\/p>\n<p>cd %plesk_dir%\/mysql\/bin<br \/>mysql -u admin -p &#8220;&lt;Plesk_admin_pwd&gt; &#8221; &#8211;port=8306 psa<\/p>\n<p>Should get you to the mysql prompt for the psa admin database.<\/p>\n<p>From then on the queries:<\/p>\n<p>select * from misc where param like &#8220;%mssql%&#8221;;<\/p>\n<p>and<\/p>\n<p>select * from misc where param like &#8220;%mysql%&#8221;;<\/p>\n<\/blockquote>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ok, that was interesting. I maintain several Plesk servers for clients, some Windows and some Linux. Under the current version (7.5.4 for Windows) there is a need to support the Asp.NET 2.0 framework and the tools that come with it. After much research and holding of breath, I took the leap and did an upgrade. [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":53138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[278],"tags":[],"_links":{"self":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/posts\/79"}],"collection":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/comments?post=79"}],"version-history":[{"count":0,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/posts\/79\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/media\/53138"}],"wp:attachment":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/media?parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/categories?post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/tags?post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}