This tip is on databases. Here you go — free on us — compliments of and also compliments of :

Installing SQL Server 2008 R2 on your Windows Virtual Private Server

1) Ask SoZo to load the .iso file to your c: drive on your server as SQL Server 2008 will be an additional monthly charge

2) Go to Microsoft download center and download the free file called ISO Mount and save the file to your c: drive

3) Install the ISO Mount file and read the instructions to place the 1 file in the windows/system32 folder adding a desktop icon called ISO Mount

4) Start up this new ISO Mount program and click on the Add drive button and a row in the top window will appear starting with z: drive for mapping to a drive not used

5) Click on the Mount Drive button and select the location of the ISO file in step 1 and just click on the ok button for the pop up as no need to select the 3 check boxes

6) If you open windows explorer now you will see a z:drive (your mapping in step 4) and the files for the install on this drive

7) Start up the setup.exe file for the SQL Server 2008 R2 Install and run the upgrade advisor first to see what issues you will have in upgrading sql server 2000 and 2005 databases

8) Select a new install or a New Server standalone (if not upgrading) or the Upgrade option to upgrade existing older databases on your VPS server

9) Select the default instance or different instance if you have more than 1 instance on your server

10) If you are installing the reporting services select NT Authority/System for the account name and you don’t need to enter a password on that row. You can configure the reporting services later

11) Complete the install

12) You can add on to the install more features after you have installed SQL Server 2008 R2 if you did not install all the features the first time through

13) Click on the ISO Mount program, select the z: drive you added on step 4 above and click on the Remove Mount button

Categories: Uncategorized ,Web Hosting ,Web Hosting and Database Tips

Leave a Reply

You must be logged in to post a comment.