View source

From GoGrid

You do not have permission to do that, for the following reason:
The action you have requested is limited to users in one of the groups GoGrid, Administrators, Bots, Sysops, Root, GoGridUser, Root Admin.
You can view and copy the source of this page:
<div style="float: right;">__TOC__</div>
==Overview==
This document is still incomplete and pending.

This document will guide you first through creating a [[MyGSI]] from a Windows 2008 Server base image and installing MSSQL 2008.  By default, if you save a [[MyGSI]] with MSSQL installed without any sort of modification to the service, there's a high potential of a BSOD (acronym for Blue Screen of Death) with error code message 0x0000007B meaning there's a unrecoverable driver failure.  This is often caused by MSSQL starting and attempting to mount the block device on a virtual system without the device driver for that block device present, causing an unrecoverable fatal error.  This guide will assist you in saving a [[MyGSI]] to prevent this issue and still have MSSQL available when deployed from a saved image.
<br /><div style="margin-left:20px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif |32px | 32px]]</div>'''NOTE:''' It is always advised you test any saved [[MyGSI]] for operation after saving.  Regardless of previous operation, or previous successful deployments of a working [[MyGSI]] image, GoGrid does not support Windows 2008 with MSSQL integrated within a [[MyGSI]].  This guide is provided as-is and is without any warranty whatsoever.  There may also be typographical errors or assumed steps.  This guide will assume basic system administrator level knowledge and moderate system management level skills.</div>

==Getting Started==
===Requirements===
[[Image:64x64-sandbox.png  | right]]
First you'll need to deploy your Image Sandbox
{|cellpadding="5" cellspacing="0" border="1"
!Name
!Type
!RAM
!Operating System
!Image
!Public IP
|-
|mygsi01
|Web Server
|2GB
|Windows 2008 Server (32-bit) w/ None
|w2k8_32_base
|208.1.1.3
|-
|mygsi02
|Web Server
|2GB
|Windows 2008 Server (64-bit) w/ None
|w2k8_64_base
|208.1.1.4
|}
<br /><div style="margin-left:20px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' Currently there is no Database type for Windows 2008 so the designation for these GSI's will be Web Server.  The bit version of MSSQL you install is recommended to match the bit version of Windows you have deployed, so if you install the 32-bit (x86 or otherwise i386) version of Windows 2008, you should use the same 32-bit version of MSSQL.  While not addressed in this document, these same general outline could be applied to MSSQL 2005.</div>

==Outline==
===[[MyGSI]] BASE Build Phase(Optional)===
[[Image:64x64-sandbox.png  | right]]
It is recommended, but not required, to rebuild the base image provided with the most current updates available.  At the time this document was written, the [[MyGSI]] base images provided by GoGrid were Windows Server 2008 Enterprise SP1.  This optional step is outlined for building a base Windows image and applying all Windows Updates, then using this saved [[MyGSI]] as a foundation for future [[MyGSI]] images.  [[MyGSI]] images can be deployed as sandboxes and modified, then re-saved, making it handy to run updates.
<ol>
<li>Deploy your [[MyGSI]] base server image (5-15m)</li>
<li>Run Windows update to apply all necessary patches (rebooting as necessary) (60-240m)</li>
<li>After all patches/updates apply, reboot one more time for a clean session (2-5m)</li>
<li>Run PREP (2-5m)</li>
<li>Return to my.gogrid.com portal and save the [[MyGSI]] (10-30m)</li>
</ol>

====Making your [[MyGSI]] BASE build====
* Deploy your sandbox from an image that has no addons or integrated roles (should have "w/NONE" in the image title)
[[Image:Mygsi-base-0.png|thumb|none|Deploying sandbox]]

* Log into the system
[[Image:Mygsi-base-1.png|thumb|none|Log into sandbox]]

* Install KB947821 , Windows Update Readiness Tool - ([http://go.microsoft.com/fwlink/?LinkID=183285 32-bit], [http://go.microsoft.com/fwlink/?LinkID=183286 64-bit]), reboot.

* Update to SP2 by downloading from your server the following file (Select the correct update depending on the deployed bit version you choose):
** Windows6.0-KB948465-X86.exe [http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=a4dd31d5-f907-4406-9012-a5c3199ea2b3 32-bit]
** Windows6.0-KB948465-X64.exe [http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=656c9d4a-55ec-4972-a0d7-b1a6fedf51a7 64-bit]

* Run the update from a CMD window with the option /unattend
[[Image:Mygsi-base-2.png|thumb|none|Windows SP2 Update]]

* After the system has been rebooted, you should receive a message that says "Windows Server(R) Service Pack 2 is now installed"

* You should run all necessary Windows Updates as needed by the system
[[Image:Mygsi-base-3.png|thumb|left|Windows Update]]
<br /><div style="margin-left:220px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' I recommend not installing Windows Update '''KB968389''', '''Internet Explorer 8''', '''Windows Malicious Software Removal Tool''', or any '''.Net Framework''' update in conjunction with other updates.  Install them independently for the best results.  To modify the selection of updates you will install while in the Windows Update screen, click the text under "Download and install your selected updates" which will read similar to "27 important updates are available" (the number of updates may varry).  You can check, or un-check any update in that list, or right click to hide updates so they do not re-appear on subsequent checks for available updates.</div><br style="clear: both" />

* After all updates have been applied, reboot your system one last time to ensure you have a clean session

* To have as much free space as possible, remove old updates including the SP2 update file.  This can be done by removing the contents of the directory C:\Windows\SoftwareDistribution\Download\.  The files and folders in this directory are safe to delete.  Where the SP2 Windows update was saved depends on where you saved the file.
<br /><div style="margin-left:20px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif |32px | 32px]]</div>'''NOTE:''' Instead of just pressing the '''Delete''' key on your keyboard or moving files to the Recycle Bin, you can hold the '''Shift''' key and press '''Delete''' to permanently delete files without moving them to the Recycle Bin.</div>

* Run PREP
[[Image:Mygsi-base-4.png|thumb|left|Run PREP]]
<br /><div style="margin-left:220px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' Your remote desktop session will be interrupted once started, this is normal.<br/><br/></div><br style="clear: both" />

* Once the system is offline, return to the GoGrid portal, select the [[MyGSI]] image and SAVE it
[[Image:Mygsi-base-5.png|thumb|none|Save sandbox]]

* Name your [[MyGSI]], add a description as necessary and save

* Wait between 10 and 30 minutes for the save process to complete

===[[MyGSI]] with MSSQL Build Phase===
[[Image:64x64-sandbox.png  | right]]
<ol>
<li>Deploy a new sandbox image of Windows 2008 (5-15m)</li>
<li>Run Windows update to apply all necessary patches (rebooting as necessary) (5-240m)</li>
<li>After all patches/updates apply, reboot one more time for a clean session (2-5m)</li>
<li>Install MSSQL matching the same bit version of Windows you have (i.e. if you have Windows 2008 x64 then install the x64 version of MSSQL) (10-45m)</li>
<li>Reboot (2-5m)</li>
<li>Apply patches to MSSQL if necessary (10-45m)</li>
<li>Reboot (2-5m)</li>
<li>Disable MSSQL (2-5m)</li>
<li>Reboot (2-5m)</li>
<li>Run PREP (2-5m)</li>
<li>Return to my.gogrid.com portal and save the [[MyGSI]] (10-30m)</li>
</ol>

====Making your [[MyGSI]] with MSSQL====
* Deploy your sandbox image
[[Image:Mygsi-base-0.png|thumb|none|Deploying sandbox]]

* Log into the system
[[Image:Mygsi-base-1.png|thumb|none|Log into sandbox]]

* You should run all necessary Windows Updates as needed by the system
[[Image:Mygsi-base-3.png|thumb|left|Windows Update]]
<br /><div style="margin-left:220px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' I recommend not installing Windows Update '''KB968389''', '''Internet Explorer 8''', '''Windows Malicious Software Removal Tool''', or any '''.Net Framework''' update in conjunction with other updates.  Install them independently for the best results.  To modify the selection of updates you will install while in the Windows Update screen, click the text under "Download and install your selected updates" which will read similar to "27 important updates are available" (the number of updates may varry).  You can check, or un-check any update in that list, or right click to hide updates so they do not re-appear on subsequent checks for available updates.</div><br style="clear: both" />

* After all updates have been applied, reboot your system one last time to ensure you have a clean session

* To have as much free space as possible, remove old updates including the SP2 update file.  This can be done by removing the contents of the directory C:\Windows\SoftwareDistribution\Download\.  The files and folders in this directory are safe to delete.  Where the SP2 Windows update was saved depends on where you saved the file.
<br /><div style="margin-left:20px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif |32px | 32px]]</div>'''NOTE:''' Instead of just pressing the '''Delete''' key on your keyboard or moving files to the Recycle Bin, you can hold the '''Shift''' key and press '''Delete''' to permanently delete files without moving them to the Recycle Bin.</div>

* Mount your [[Cloud Storage]]

* Download to [[Cloud Storage]] your MSSQL installation media and start the installation program (usually setup.exe)

* Follow installation procedure, refer to installation documentation should you need assistance
<br /><div style="margin-left:20px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' It is recommend that you choose the '''Mixed Mode (SQL Server authentication and Windows authentication)''' option while under the Database Engine Configuration - Account Provisioning page and specify a SA password for the MSSQL installation.  This is because during installation you will add the local Administrator to the authorized users to use Windows Authentication.  This user's SID and the machine's SID will change when the saved GSI is re-deployed so the Administrator will not be able to log in.</div>

* Reboot your system

* Install any service packs, patches, or updates to MSSQL, these should be ran from the local file system and not [[Cloud Storage]]

* Reboot your system

* Remove any unnecessary installation files or patches, service packs, and updates from your system to conserve space, or copy these files for backup purposes to [[Cloud Storage]] if you wish.
<br /><div style="margin-left:20px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif |32px | 32px]]</div>'''NOTE:''' Instead of just pressing the '''Delete''' key on your keyboard or moving files to the Recycle Bin, you can hold the '''Shift''' key and press '''Delete''' to permanently delete files without moving them to the Recycle Bin.</div>

* Disable MSSQL Services from starting
[[Image:Mygsi-mssql-0.png|thumb|left|Windows Services]]
<br /><div style="margin-left:220px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' There are a number of different ways to disable services in windows.  Before making any changes, note the current default status of all services before you change them so that you can change them back when you deploy this saved image in the future
* You can '''right-click''' a service, choose '''Properties''', and change the '''Startup type''' to '''Disabled'''
* You can use the '''sc''' directive to disable services.  Scripts below are examples which you can use/modify to do this in a batch format quickly

For all services that are in the '''Manual''' or '''Automatic''' startup types you will need to change these to '''Disabled''' before running PREP.  If you do not, the resulting saved [[MyGSI]] image will most likely not deploy correctly.</div><br style="clear: both" />

* Reboot your system

* Check that MSSQL Services did not auto start, troubleshoot as necessary and reboot to check

* Run PREP
[[Image:Mygsi-base-4.png|thumb|left|Run PREP]]
<br /><div style="margin-left:220px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' Your remote desktop session will be interrupted once started, this is normal.<br/><br/></div><br style="clear: both" />

* Once the system is offline, return to the GoGrid portal, select the [[MyGSI]] image and SAVE it
[[Image:Mygsi-base-5.png|thumb|none|Save sandbox]]

* Name your [[MyGSI]], add a description as necessary and save

* Wait between 10 and 30 minutes for the save process to complete

===[[MyGSI]] Deploy Phase===
[[Image:64x64-ws.gif  | right]]
<ol>
<li>Deploy [[MyGSI]] (5-15m)</li>
<li>Log in (< 1m)</li>
<li>Enable MSSQL (2-5m)</li>
<li>Log into MSSQL as SA user (< 1m)</li>
<li>Remove old Administrator account (1m)</li>
<li>Add current machine's Administrator account allowing for Windows Authentication (1m)</li>
<li>Log out of MSSQL (< 1m)</li>
<li>Log into MSSQL using Windows Authentication with the Administrator's account to test (< 1m)</li>
<li>Resume customization as needed (unk.)</li>
</ol>

====Deploying your saved [[MyGSI]]====
* Deploy your saved [[MyGSI]]
[[Image:Mygsi-saved-0.png|thumb|none|Deploy saved MyGSI]]

* Log into the system
[[Image:Mygsi-base-1.png|thumb|none|Log into system]]

* Enable MSSQL Services
[[Image:Mygsi-mssql-0.png|thumb|left|Windows Services]]
<br /><div style="margin-left:220px;" class="note"><div style="float:left; margin-right: 20px;">[[Image:64-warn.gif|32px|32px]]</div>'''NOTE:''' There are a number of different ways to enable services in windows.  You should have noted the previous default status of all services before when building the [[MyGSI]] so that you can change them back here
* You can '''right-click''' a service, choose '''Properties''', and change the '''Startup type''' to '''Manual''' or '''Automatic''' depending on what it originally was
* You can use the '''sc''' directive to disable services.  Scripts below are examples which you can use/modify to do this in a batch format quickly</div><br style="clear: both" />

* Reboot your system

* Check that MSSQL Services did auto start, troubleshoot as necessary and reboot to check

* Once you've confirmed services start automatically as needed, log into your MSSQL instance as the '''SA''' user with the credentials you provided during installation.
[[Image:Mygsi-mssql-2.png|thumb|none|MSSQL login]]

* Once logged in, expand '''Security''', then '''Logins'''

* Right-click on the old '''Administrator''' account, and left-click on Delete.  Follow the steps to confirm
[[Image:Mygsi-mssql-3.png|thumb|none|MSSQL user management]]

* Right-click on '''Logins''' and left-click on '''New Login...'''

* Left-click on '''Search''' and type in '''Administrator''' in the text box, then click '''OK'''

* Make sure '''Windows authentication''' is selected, and click '''OK''' at the bottom.
[[Image:Mygsi-mssql-4.png|thumb|left|MSSQL user management]] [[Image:Mygsi-mssql-5.png|thumb|left|MSSQL user management]]<br style="clear: both" />

* Test Administrator login via Windows Authentication by closing all Microsoft SQL Server Management Studio windows, and starting a new session.

==Testing==
After building any [[MyGSI]] image, it is recommended that you test that image.  To do so, deploy the saved [[MyGSI]] image and wait for it to come online.  You may have to wait up to 30 minutes for it to finish post-deployment requirements before the system is available.  Once online and reachable, log in and check configured settings.  If the system is never available, you may want to submit a support case to inquire about the system's status.  If the system is offline due to a problem in the [[MyGSI]] save process, then you will most likely be required to delete your saved [[MyGSI]] server and start over from the ground up.
<br/>

==Source Code for Scripts==
Suggested fix: Windows UTC/Local time correction

w32tm /config /manualpeerlist:"216.93.160.62 207.46.232.182 192.43.244.18" /reliable:YES /update

==Microsoft® SQL Server® 2008 Express Downloads==
Microsoft® SQL Server® 2008 Express is a free edition of MSSQL.  The downloads provided here were current as of 01/04/2010:

Microsoft® SQL Server® 2008 Express Edition with Service Pack 1
* [http://download.microsoft.com/download/8/E/5/8E53FAA8-1129-4621-903F-3F8DB6D066AC/SQLEXPR32_x86_ENU.exe X86] | [http://download.microsoft.com/download/8/E/5/8E53FAA8-1129-4621-903F-3F8DB6D066AC/SQLEXPR_x64_ENU.exe X64]
 
Microsoft® SQL Server® 2008 Express with Tools
* [http://download.microsoft.com/download/7/9/4/794bfafa-aea7-45d4-a6ea-4e92f09918e3/SQLEXPRWT_x86_ENU.exe X86] | [http://download.microsoft.com/download/7/9/4/794bfafa-aea7-45d4-a6ea-4e92f09918e3/SQLEXPRWT_x64_ENU.exe X64]
 
Microsoft® SQL Server® 2008 Express with Advanced Services
* [http://download.microsoft.com/download/e/9/b/e9bcf5d7-2421-464f-94dc-0c694ba1b5a4/SQLEXPRADV_x86_ENU.exe X86] | [http://download.microsoft.com/download/e/9/b/e9bcf5d7-2421-464f-94dc-0c694ba1b5a4/SQLEXPRADV_x64_ENU.exe X64]

Microsoft® SQL Server® 2008 Management Studio Express
* [http://download.microsoft.com/download/6/7/4/674A281B-84BF-4B49-848C-14873B22F977/SQLManagementStudio_x86_ENU.exe X86] | [http://download.microsoft.com/download/6/7/4/674A281B-84BF-4B49-848C-14873B22F977/SQLManagementStudio_x64_ENU.exe X64]
Return to customer:Windows 2008 and MSSQL 2008 in a MyGSI.
Retrieved from "http://wiki.gogrid.com/wiki/index.php/customer:Windows_2008_and_MSSQL_2008_in_a_MyGSI"
Views

View source

From GoGrid

Personal tools
