page contents

Just Another Microsoft Enthusiast's Blog

Fixed an issue *removing* SQL Server 2008r2

I had an issue tonight where I was unable to remove Microsoft SQL Server 2008r2. The setup was just hanging at this step SqlEngineConfigAction_remove_validation_Cpu64. I first tried to remove it by Add/Remove Programs and then tried it by the command line: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2>setup.exe /ACTION=uninstall /FEATURES=SQL,AS,BOL,SSMS/INSTANCENAME=MSSQLSERVER Neither action would work and it was […]

Continue Reading →

HOW TO FIX: Clock Drift in Cloud Environments (not joined to AD domain)

This is really an outdated bit of information, please see the better method to resolve clock drift in this post by me. I have been slammed lately with moving from one place to another and taking on a new job, so I was not actively monitoring my web server that hosts this site. I checked […]

Continue Reading →

Wow! Amazon EC2 is lowering prices again…

Sorry all, that I missed this earlier and I meant to post this on Thursday, but I got tied up with work. This news listed below from Amazon’s web site is really good news. Last month, I was hosting this site on EC2 and since I wanted to run Windows 2008 R2 (which is 64 […]

Continue Reading →

New adventures and challenges

Today marks my last day as an Amazonian with Amazon Web Services. I have enjoyed my time here and will miss the friendships that have formed since I joined them. I will still continue to blog about AWS and encourage others to use their features and services. As I have one foot out the door, […]

Continue Reading →

Had an amazing time at SQL Saturday in Redmond!

If you have never been to a SQL Saturday event, I highly suggest that you do! You can find an upcoming event here: http://sqlsaturday.com/ and https://twitter.com/#!/search/%23sqlsat108 As stated earlier in one of my posts (http://www.smattie.com/my-small-attempt-to-give-back-to-the-it-community/) this community is really one of the bright spots in the IT field. I was so happy to meet and talk with a […]

Continue Reading →

Video: AWS Fault Tolerance strategies

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Continue Reading →

Video: Configuring EC2Config Service to Capture Event Viewer information for Windows 2003/2008. (Get System Log)

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Continue Reading →

Seizing FSMO Roles in Windows 2008 using ntdsutil

How can I forcibly transfer (seize) some or all of the FSMO Roles from one DC to another? Keep in mind bad things can happen at times 🙁 Windows 2000/2003 Active Directory domains utilize a Single Operation Master method called FSMO (Flexible Single Master Operation), as described in Understanding FSMO Roles in Windows Active Directory. […]

Continue Reading →

Transferring FSMO Roles in Windows 2008 using ntdsutil

How can I transfer some or all of the FSMO Roles from one DC to another using the command line? Great question! NOTE: For doing this task in the GUI, please see this blog: Transferring FSMO Roles in Windows Server 2008 (Has some great screen-shots) Windows 2008 Active Directory domains utilize a Single Operation Master method called FSMO […]

Continue Reading →

Understanding FSMO Roles in Windows Active Directory

FSMO stands for Flexible Single Master Operations, and these roles (also known as operations master roles) help you prevent conflicts in your Active Directory. In an Active Directory environment, some of your domain controllers (DCs) must be assigned certain special roles for your network to function properly. These special roles are called flexible single master […]

Continue Reading →

HOW TO: Move SQL Server transaction log files to a different location via TSQL and SSMS

This information is NOT recommended and I strongly suggest you follow this article instead. HOW TO: Move SQL Server transaction log files to a different location via TSQL and SSMS Problem Moving the log file of a production SQL Server database to separate physical drive is a Microsoft SQL Server best practice to optimize the […]

Continue Reading →

Different Ways to Find the Recovery Model for a SQL Server Database

Perhaps, the best thing about SQL Server and Microsoft products as a whole is that most of the tasks can be executed in more than one way. At times, it is might be useful to know about the various methods of performing a single task. Today, we will observe four different methods to find out […]

Continue Reading →

Video: Detaching root volumes for both versions of Windows 2008 to Windows 2008 to resolve EC2 connectivity issues. (Part 2 of 2)

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Goals: To successfully detach and attach root drive to EC2 Windows 2008 […]

Continue Reading →

Video: Detaching root volumes for both version of Windows 2008 to Windows 2003 to resolve EC2 connectivity issues. (Part 1 of 2)

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Goals: To successfully detach and attach root drive to EC2 Windows 2003 […]

Continue Reading →

Video: Keeping Volume Drive Letters the same with an EC2 Windows instance.

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Continue Reading →

Video: Manually Set Key Management Server for Windows Activation in EC2

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Amazon KMS Server Information as of 26 JAN 2012 VPC (all regions, […]

Continue Reading →

Video: Remotely Reset Windows Password via EC2 Config service.

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Continue Reading →

Video: Gathering helpful information to assist with Windows issues within EC2.

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Tools needed: tracetcp: http://tracetcp.sourceforge.net/ wincap: http://www.winpcap.org/install/default.htm tcping: http://www.elifulkerson.com/projects/tcping.php Commands: ipconfig /all >C:\tools\tshoot.txt […]

Continue Reading →

Video: Recovering EC2 Windows 2008/2008r2 instance due to Windows Firewall issues

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Continue Reading →

EC2 Windows 2008/2008r2 loss of connectivity due to Windows Firewall

Happy New Year to everyone and I hope you had a great holiday! I have update this information in the form of a video, which can be found here. Today, I am going to talk about an issue where you might be connecting to a server remotely and all of a sudden you are no […]

Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.