How to completely remove/uninstall an instance of SQL Server 2008 R2 x64 from Windows 8
http://blogs.msdn.com/blogfiles/mvplead/WindowsLiveWriter/UpdatedSQLServer2008R2TrainingKitAvailab_115AC/image_3.png
 
หลังจากหาวิธีถอนรากถอนโคน เจ้าตัวนี้อยู่สักพัก ก็ได้ผลละประการฉะนี้
*** อันดับแรกเหนือสิ่งอื่นใด…ไป Stop Service ที่เป็นของ SQL Server ให้หมดก่อนทีเดียวเชียว

1. Click Start | Control Panel | Add or Remove Programs. In the Add or Remove Programs windows select Microsoft SQL Server 2008 as shown in the snippet below and Click Change/Remove button.
Add or Remove Programs


2. Once you click on Change/Remove button it will popup SQL Server 2008 windows as shown in the snippet below. There are three options basically available and they are Add, Repair and Remove.
  • Add:- This option can be used by database administrators if they want to add any new feature of SQL Server 2008 which you may not have installed previously. The different features can be adding Analysis Services, Integration Services , Reporting Services or Replication etc.
  • Repair:-This option can be used by database administrators if they want to repair SQL Server 2008 product.
  • Remove:- This option can be used by database administrators if they want to remove SQL Server 2008 product. This is the option which you need to select to Uninstall SQL Server 2008.

SQL Server 2008 Add, Repair or Remove Screen
3. Once you click on Remove option, you will see a popup screen informing you to wait for a while till SQL Server 2008 Setup is processing the current user request.

4. In SQL Server 2008 Setup Support Rules screen SQL Server setup program identifies problem which can occur when you uninstall SQL Server. If there are no issues encountered they you will see Passed message against each rule. Click OK to continue with the uninstallation.


SQL Server 2008 Setup Support Rules Screen

5. In Select Instance screen select the SQL Server Instance from where you need to remove features. This can be done by selecting the instance name from the drop down list as shown in the snippet below. Click Next to continue with the uninstallation process.

Select SQL Server Instance From where you want to uninstall features

6. In the Select Features screen choose the feature which needs to be removed and click Next to continue with the uninstallation process.



7. In the Removal Rules screen you could see that SQL Server setup program is checking internally whether the uninstallation process will be successful or not. You will be able to see the status for Removal architecture mismatch as true if there are no issues in uninstalling SQL Server 2008. Click Next to continue with the uninstallation process.



8. In the Ready to Remove screen SQL Server 2008 setup will ask you to verify the SQL Server 2008 features which will be removed. click Next to continue with the uninstallation process.


9. Once the requested features are removed, the Removal Progress screen which will have the Success or Failure message for each and every single feature which it has removed. Click Next to complete the uninstallation process.


10. In the Complete screen you will be able to see “Your SQL Server 2008 removal completed successfully”. Click Close to exit Remove SQL Server 2008 setup.




2:25 PM | Category: | 0 comments

How to removing Expired GTE CyberTrust Solution Certificate Glassfish 3.1.2


"รำคราญตา" เมื่อวันนึงต้องมานั่งไล่ logs หา Err. ตาก็มัวแต่ไปสะดุดเอาแต่ WARNING เรื่องนี้อยู่นั่น ชักเริ่มสงสัย...มันคือไรหว่า...พอนับๆดูเท่านั้นแหละ....ห่านนนนน เยอะไปมั้ย วันๆนึงเกิดขึ้นเป็นร้อยๆครั้ง แก้เถอะ....

SEC5054: Certificate has expired: [
[
  Version: V3
  Subject: CN=GTE CyberTrust Root 5, OU="GTE CyberTrust Solutions, Inc.", O=GTE Corporation, C=US
  Signature Algorithm: SHA1withRSA, OID = 1.2.840.113549.1.1.5

  Key:  Sun RSA public key, 2048 bits
  modulus: 23741889829347261660812437366387754385443431973861114865490414153884050331745811968523116847625570146592736935209718565296053386842135985534863157983128812774162998053673746470782252407673402238146869994438729551246768368782318393878374421033907597162218758024581735139682087126982809511479059100617027892880227587855877479432885604404402435662802390484099065871430585284534529627347717530352189612077130606642676951640071336717026459037542552927905851171460589361570392199748753414855675665635003335769915908187224347232807336022456537328962095005323382940080676931822787496212635993279098588863972868266229522169377
  public exponent: 65537
  Validity: [From: Fri Aug 14 21:50:00 ICT 1998,
               To: Thu Aug 15 06:59:00 ICT 2013]
  Issuer: CN=GTE CyberTrust Root 5, OU="GTE CyberTrust Solutions, Inc.", O=GTE Corporation, C=US
  SerialNumber: [    01b6]

Certificate Extensions: 4
[1]: ObjectId: 2.5.29.19 Criticality=true
BasicConstraints:[
  CA:true
  PathLen:5
]

[2]: ObjectId: 2.5.29.32 Criticality=false
CertificatePolicies [
  [CertificatePolicyId: [1.2.840.113763.1.2.1.3]
[]  ]
]

[3]: ObjectId: 2.5.29.15 Criticality=true
KeyUsage [
  Key_CertSign
  Crl_Sign
]

[4]: ObjectId: 2.5.29.14 Criticality=false
SubjectKeyIdentifier [
KeyIdentifier [
0000: 76 0A 49 21 38 4C 9F DE   F8 C4 49 C7 71 71 91 9D  v.I!8L....I.qq..
]
]

]
  Algorithm: [SHA1withRSA]
  Signature:
0000: 41 3A D4 18 5B DA B8 DE   21 1C E1 8E 09 E5 F1 68  A:..[...!......h
0010: 34 FF DE 96 F4 07 F5 A7   3C F3 AC 4A B1 9B FA 92  4.......<..J....
0020: FA 9B ED E6 32 21 AA 4A   76 C5 DC 4F 38 E5 DF D5  ....2!.Jv..O8...
0030: 86 E4 D5 C8 76 7D 98 D7   B1 CD 8F 4D B5 91 23 6C  ....v......M..#l
0040: 8B 8A EB EA 7C EF 14 94   C4 C6 F0 1F 4A 2D 32 71  ............J-2q
0050: 63 2B 63 91 26 02 09 B6   80 1D ED E2 CC B8 7F DB  c+c.&...........
0060: 87 63 C8 E1 D0 6C 26 B1   35 1D 40 66 10 1B CD 95  .c...l&.5.@f....
0070: 54 18 33 61 EC 13 4F DA   13 F7 99 AF 3E D0 CF 8E  T.3a..O.....>...
0080: A6 72 A2 B3 C3 05 9A C9   27 7D 92 CC 7E 52 8D B3  .r......'....R..
0090: AB 70 6D 9E 89 9F 4D EB   1A 75 C2 98 AA D5 02 16  .pm...M..u......
00A0: D7 0C 8A BF 25 E4 EB 2D   BC 98 E9 58 38 19 7C B9  ....%..-...X8...
00B0: 37 FE DB E2 99 08 73 06   C7 97 83 6A 7D 10 01 2F  7.....s....j.../
00C0: 32 B9 17 05 4A 65 E6 2F   CE BE 5E 53 A6 82 E9 9A  2...Je./..^S....
00D0: 53 0A 84 74 2D 83 CA C8   94 16 76 5F 94 61 28 F0  S..t-.....v_.a(.
00E0: 85 A7 39 BB D7 8B D9 A8   B2 13 1D 54 09 34 24 7D  ..9........T.4$.
00F0: 20 81 7D 66 7E A2 90 74   5C 10 C6 BD EC AB 1B C2   ..f...t\.......
]|#]

Solution 
  1. Go to the ${GLASSFISH_INSTALLATION_DIRECTORY}/glassfish/domains/domain1/config/ directory. You will need to repeat this if you have multiple domains.
  1. Execute the following command:
$ keytool -delete -v -alias gtecybertrust5ca -keystore cacerts.jks
Enter keystore password:  changeit
[Storing cacerts.jks]
  1. Restart server, and the expired certificate warning will disappear.
11:24 AM | Category: | 0 comments