Windows 95

As is always useful when making a virtual machine running Windows 95 to test your websites on (yes, there are still users out there running Windows 95!)

Download Windows 95b ISO (ISO-9660)

Some keys:

Windows 95 OEM Version : CD-Key:
12095-OEM-0004226-12233 or
15795-OEM-0001355-07757 or
16595-OEM-0001695-96524

Windows 95 OEM Version (02) :
16595-OEM-0001695-96527 or
30095-OEM-0006161-61513 or
17295-OEM-0001085-48667

Windows 95 OEM Version (03) :
17295-OEM-0001922-52683 or
15395-OEM-0001292-85449 or
11495-OEM-0000052-26220

Windows 95 OEM Version (04) :
10092-OEM-0002302-92097 or
10092-OEM-0002302-93345 or
11195-OEM-0000043-04590

Windows 95 OEM Version (05) :
11195-OEM-0000043-06390 or
27195-OEM-0003272-10122 or
11195-OEM-0000043-05620

Windows 95 OEM Version (06) :
15395-OEM-0001292-85467 or
15395-OEM-0001292-85402 or
15095-OEM-0001175-61439

Windows 95 OEM Version (07) :
11495-OEM-0000052-21091 or
11495-OEM-0000043-11092 or
11195-OEM-0000043-04872

Windows 95 OEM Version (08) :
13995-OEM-0000777-79637 or
15095-OEM-0001175-46652 or
15695-OEM-0001346-00881

Windows 95 OEM Version (09) :
11195-OEM-0000043-11111 or
11195-OEM-0000043-10217 or
24995-OEM-0004361-59221

Windows 95 OEM Version (10) :
13895-OEM-0000716-90166 or
11495-OEM-0000061-97573 or
34095-OEM-0007392-52487

Windows 95 OEM Version (11) :
20795-OEM-0002723-90591 or
16095-OEM-0001535-68203 or
15095-OEM-0001166-90867

Windows 95 OEM Version (12) :
33495-OEM-0007194-19592 or
11495-OEM-0000061-97215 or
35595-OEM-0008492-43325

Windows 95 OEM Version (13) :
11895-OEM-0000194-62506 or
15095-OEM-0001166-90867 or
34895-OEM-0007662-31988

Windows 95 OEM Version (14) :
35295-OEM-0008250-79497 or
31895-OEM-0006654-61329 or
16296-OEM-0012506-78573

Windows 95 OEM Version (15) :
13895-OEM-0000716-68627 or
30195-OEM-0005315-51142 or
12496-OEM-0011212-03586

Windows 95 OEM Version (16) :
13969-OEM-0010166-05693 or
13969-OEM-0010166-05779

How to add an SSL certificate to IIS in Windows Server 2008 R2

Its something I do without really thinking about, just get another certificate and add it to the server so that the website can load with https:// instead of http://

I have used lots of different SSL providers, however I have found that the most reliable and easy to use is www.trustico.co.uk and their customer service and support is exceptional.

I will try to make this as step-by-step as I possibly can so that it’s easy to follow.

Part 1 – Creating the certificate request

1. Open the IIS (Internet Information Services) Manager

Screen Shot 2013-09-12 at 08.35.48

2. Click on the server name on the left hand side and then double-click on Server Certificates

Screen Shot 2013-09-12 at 08.37.10

 

3. On the right-hand-side of the server certificates section, click on Create Certificate Request

Screen Shot 2013-09-12 at 08.42.44

4. The Request Certificate wizard is displayed.  The Common Name is the website URL that you are going to make SSL. In this example, I am creating a certificate for one of our systems, Good Morning Pulse.

There are two main types of certificate, single and wildcard. A single certificate is for a single site (e.g. https://www.google.co.uk), a wildcard certificate is for multiple sub-domains at the same domain (e.g. https://maps.google.co.uk AND https://places.google.co.uk … and as many other sub-domains as you can think of) without having to purchase separate certificates for each sub-domain.

Screen Shot 2013-09-12 at 08.47.08

The only REALLY important part of this is the common name.

Click on Next to continue

 

 

5. Change the Bit length to 2048 or higher. A note of caution on this – if you change it to a really high bit length it means that the volume (size in kb) of all pages being sent to and from your website is significantly increased, but is more secure.

You should not choose any setting lower than 2048. As of October 2013, all 1024-bit certificates have been revoked and 2048 is the new standard.

Screen Shot 2013-09-12 at 08.50.36

6. Next we are choosing a place to put the certificate request (just a plain text file). I normally put this on the Windows Desktop for ease of accessing in a few steps time.

Screen Shot 2013-09-12 at 08.53.11

Click on the  button to choose the location

Screen Shot 2013-09-12 at 08.53.33

Give the file a name. I normally call it “certReq” (Certificate Request) just so I know what it is. If it already exists it will overwrite any existing file.

Click on the Open button to select the file (it will be created if it does not already exist)

Click on Finish to complete the certificate request process

Part 2 – Submitting and creating the SSL certificate

1. Open the certificate request file you created in Part 1

Screen Shot 2013-09-12 at 09.00.32

Select and copy the entire certificate (Ctrl + A or Cmd + A) and then Copy (Ctrl + C or Cmd + C) INCLUDING the —–BEGIN NEW CERTIFICATE REQUEST—— (and end) parts.

2. Visit www.trustico.co.uk

Screen Shot 2013-09-12 at 09.06.41

Click on the Buy Cheap RapidSSL green button

2. Choose the type of SSL certificate you want to order (In this case I am ordered a normal Rapid SSL Certificate for £9.99. Click on the green Order Now button.Screen Shot 2013-09-12 at 09.08.22

3. Choose the length of time you wish the certificate to be valid for. Unless you want to have to go through this process every 12 months (which gets very time-consuming when you have tens or hundreds to purchase), its best to go for the longest time-frame you can afford.

Screen Shot 2013-09-12 at 09.08.57

In this case, I am choosing 48 months, which is only £35.96 at the time of writing.

Issuance Insurance: its your decision whether to keep this or not, and depends on what you need. I always turn Issuance Insurance off, in this case it will save £48 off the bill. If you think you are going to move servers, then keep this on unless you know how to export certificates from one server to another (thats another tutorial in the future).

Screen Shot 2013-09-12 at 09.13.04

Click on Continue

4. Enter all your contact information. Make sure you have access to the email address supplied at this stage otherwise you wont get the certificate at the end. (I have not entered all my details in the screen-shot below yet)

Screen Shot 2013-09-12 at 09.15.40

Click on Continue

5. Click on Submit newly generated certificate signing request (I don’t know why they think every word needs a capital letter, but anyway)

Paste in your certificate that you copied in Step 1

Screen Shot 2013-09-12 at 09.19.39

Click on Continue

6. You are asked to verify the information. Click on Continue

Screen Shot 2013-09-12 at 09.22.02

7. Next you have to confirm that you own the domain name by receiving an email at the domain. If you don’t have a mail server set up, the easiest way to do this is to simply set up a mail forwarder to your own email address (very easy and free if you registered your domain with www.123-reg.co.uk )

Choose the email address to send the approver email to, and click on Continue

Screen Shot 2013-09-12 at 09.25.43

8. Read the subscriber agreement (has anyone ever read these?) Click on Continue

Screen Shot 2013-09-12 at 09.26.16

9. The confirmation details of what you are ordering is shown. Scroll down and click on Continue

10. Pay for the certificate. I always use PayPal, which makes the certificate issuing process very fast indeed. No matter how you pay, it always says thanks for your credit card payment.

Screen Shot 2013-09-12 at 09.31.29

Thats the online (web) part done for now.

11. Check your email (or the email address you choose at step 7 above if it doesnt forward to your own email address). You will have an email from [email protected] that asks you to visit a URL and Approve the certificate. Click on the link and click I APPROVE

12. Go get a cup of tea, coffee or coke, check your email, play Minecraft or whatever takes your fancy. It takes about 10 minutes for your certificate to be created and it is then emailed to you.

 

 Part 3 – Installing the certificate on the server

1. You should have an email from TrustICO (in this example it took 12 minutes to get to me) with the subject RapidSSL Fulfillment E-Mail [certificate name]

Scroll down the email until you get to the —-BEGIN CERTIFICATE—– part. I have (obviously) hashed out my certificate for security reasons.

Screen Shot 2013-09-12 at 09.50.58

Select the whole certificate (including the begin and end lines) and Copy it to the clipboard (Ctrl + C or Cmd+C).

Go back to the server (or if you are already on it, get to the desktop)

2. On the server, Open Notepad

3. Paste in the certificate

Screen Shot 2013-09-12 at 10.02.13

4. Click on FileSave As and choose the Desktop again (or if like me you have a lot of certificates, create a folder to put them all in)

Give the certificate a name you will remember (I always put the years in so that I can distinguish between different years worth of certificates).

IMPORTANT – there MUST be the extension .cer at the end.

IMPORTANT – change the “Save As Type” to All Files (if you forget, it will add a .txt at the end of the file name, which you then have to remove to make it work)

Screen Shot 2013-09-12 at 10.05.38

Click on Save

5. You should now see a certificate on your desktop (or the folder where you saved it)

Screen Shot 2013-09-12 at 10.10.03

6. Open IIS and go to the Server Certificates item

Screen Shot 2013-09-12 at 08.35.48 Screen Shot 2013-09-12 at 08.37.10

 

7. Click on Complete Certificate Request on the right hand side

Screen Shot 2013-09-12 at 08.42.44

8. Choose your certificate for the File Name box

IMPORTANT – Friendly Name – if you ordered a wildcard certificate it is REALLY IMPORTANT that you put the common name of the certificate as the friendly name (e.g. *.goodmorningpulse.co.uk)

In this case, as it was a single certificate, not a wildcard its good to give it a name so that you know which is which on the list.

Screen Shot 2013-09-12 at 10.15.15

Click on OK

IIS Parses the request, and if successful (which it always should be if you have created the certificate correctly) then it will add the certificate to your list.

 Part 4 – Binding the certificate to the website

So you have your certificate on the server, and you now need to tell your website to use it.

1. In IIS, expand the Sites item on the left hand side

2. Right-click on the site you wish to use the SSL certificate for, and click on Edit Bindings

Screen Shot 2013-09-12 at 10.24.35

3. The site bindings are displayed. Click on Add

4. Change the type to https and then Choose your new certificate

Screen Shot 2013-09-12 at 10.25.48

Click on OK and then Click on Close

5. The site will now allow https connections! Its that simple!

 

Success!

If you want to make your site exclusively SSL (re-directing automatically from http to https) then check out this post.

Make your site exclusively SSL (re-directing automatically from http to https) on Windows Server

If you have an SSL certificate on your website, how do you automatically re-direct ALL visitors to the SSL version? Its easy, and with no code required.

1. Open IIS

2. Click on the site you wish to change

Screen Shot 2013-09-12 at 10.31.12

3. Double-click on SSL Settings

4. Check the box Require SSL

Screen Shot 2013-09-12 at 10.33.34

5. Click on Apply (on the top right hand side)

6. Click on Error Pages

7. Double-click on the item with status code 403

Screen Shot 2013-09-12 at 10.37.06

8.  Choose the item to Respond with a 302 redirect and enter the https address

9. Click on OK

10. Stop and re-start the website and hey-presto, anyone who visits (for example) http://www.mywebsitetest.co.uk will be automatically redirected to https://www.mywebsitetest.co.uk

 

Parallels 8 on Mac running Windows 8 – where has the # hash key gone?

Its one of the few issues I have found with moving to using Macs, the lack of a # key.

On the Mac, you press Alt + 3 to show the # key.

Once you have parallels installed, if you are running windows 7, the same combination worked, however if you install Windows 8 it no longer works.

After spending half an hour + searching Google and seeing that lots of other people have the same issue and no results, I contacted Parallels support, who knew the answer (obviously)

The way around this is actually really simple:

Ctrl + Alt + 3 displays a # hash key within Windows 8 on the Virtual Machine!

Mystery solved!

ASP:Chart Colour Palette

In ASP.Net there is a really easy way to create charts, using the asp:chart tag.

There are pre-defined colour palettes that you can use, or you can create your own. Here are the built in ones:

Berry: 8A2BE2,BA55D3,4169E1,C71585,0000FF,8019E0,DA70D6,7B68EE,C000C0,0000CD,800080
Bright: 008000,0000FF,800080,800080,FF00FF,008080,FFFF00,808080,00FFFF,000080,800000,FF3939,7F7F00,C0C0C0,FF6347,FFE4B5
BrightPastel: 418CF0,FCB441,DF3A02,056492,BFBFBF,1A3B69,FFE382,129CDD,CA6B4B,005CDB,F3D288,506381,F1B9A8,E0830A,7893BE
Chocolate: A0522D,D2691E,8B0000,CD853F,A52A2A,F4A460,8B4513,C04000,B22222,B65C3A
EarthTones: 33023,B8860B,C04000,6B8E23,CD853F,C0C000,228B22,D2691E,808000,20B2AA,F4A460,00C000,8FBC8B,B22222,843A05,C00000
Excel: 9999FF,993366,FFFFCC,CCFFFF,660066,FF8080,0063CB,CCCCFF,000080,FF00FF,FFFF00,00FFFF,800080,800000,007F7F,0000FF
Fire: FFD700,FF0000,FF1493,DC143C,FF8C00,FF00FF,FFFF00,FF4500,C71585,DDE221
GrayScale: C8C8C8,BDBDBD,B2B2B2,A7A7A7,9C9C9C,919191,868686,7A7A7A,707070,656565,565656,4F4F4F,424242,393939,2E2E2E,232323
Light: E6E6FA,FFF0F5,FFDAB9,,FFFACD,,FFE4E1,F0FFF0,F0F8FF,F5F5F5,FAEBD7,E0FFFF
Pastel: 87CEEB,32CD32,BA55D3,F08080,4682B4,9ACD32,40E0D0,FF69B4,F0E68C,D2B48C,8FBC8B,6495ED,DDA0DD,5F9EA0,FFDAB9,FFA07A
SeaGreen: 2E8B57,66CDAA,4682B4,008B8B,5F9EA0,38B16E,48D1CC,B0C4DE,8FBC8B,87CEEB
SemiTransparent: FF6969,69FF69,6969FF,FFFF5D,69FFFF,FF69FF,CDB075,FFAFAF,AFFFAF,AFAFFF,FFFFAF,AFFFFF,FFAFFF,E4D5B5,A4B086,819EC1

BWJrU

Usage example (for a bar chart)

<asp:Chart ID=”chartClients” runat=”server” Height=”800px” Width=”1000px” >
<Titles>
<asp:Title Font=”Calibri, 12pt, style=Bold, Italic” Name=”Title1″ Text=”This is the title of the chart”></asp:Title>
</Titles>
<series>
<asp:Series Name=”Series1″ Label=”#VAL” Palette=”Berry” XValueMember=”<Field Name that is text>” YValueMembers=”<Field name that is number>” IsValueShownAsLabel=”False” ChartType=”Column” XValueType=”String” YValueType=”Int32″ />
</series>
<chartareas>
<asp:ChartArea Name=”ChartArea1″ Area3DStyle-Enable3D=”true”>
<AxisX Interval=”1″ LabelAutoFitStyle=”LabelsAngleStep90″>
</AxisX>
<AxisY Interval=”10″ LabelAutoFitStyle=”LabelsAngleStep90″>
</AxisY>
</asp:ChartArea>
</chartareas>
</asp:Chart>

How to stop Windows 7 requiring you to change your password

 

There are no built in tools in Windows 7 to do this, but thankfully its pretty simple. This is especially useful if you are running Windows 7 as part of a Parallels Desktop for Mac installation, as the whole VM freezes when Windows requires a password change!

Follow these instructions and it works every time.

1. Right-click on the desktop and Choose New > Shortcut

Screen Shot 2013-07-15 at 12.03.25

 

2. Type in wmic as the location, and click on Next

Screen Shot 2013-07-15 at 12.03.35

 

3. Just leave the name as WMIC, or you can change it if you want, and then click on Finish

Screen Shot 2013-07-15 at 12.03.42

 

4.Right-click on your newly created shortcut and click on Run as administrator

Screen Shot 2013-07-15 at 12.11.30

 

5. If you have User Account Control turned on (which you most likely will) then you get a dialog box  confirm you wish to run the utility, click on Yes

Screen Shot 2013-07-15 at 12.04.21

 

6. The wmi command line utility opens up. Type in (exactly)

UserAccount where PasswordExpires=TRUE set PasswordExpires=FALSE

and then Press Enter

Screen Shot 2013-07-15 at 12.04.51

7.A message appears with a Y/N option for each user account on the computer. Press Y for each, and then press Enter

Screen Shot 2013-07-15 at 12.05.47

8. You should see the message “Update Successful” – you can now close the command line window, and will never have the annoyance of Windows requiring you to change your passwords again!

Screen Shot 2013-07-15 at 12.05.57

 

Troubleshooting: If you get an error running the command, it most likely means that it cannot write to the accounts and are not running the command as Administrator. Its really important that you do this (see Step 4 above).