Ivan Versluis June 8th, 2008
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored. SQL Server 2008 enables you to consume your data within custom applications developed using Microsoft .NET and Visual Studio and within your service-oriented architecture (SOA) and business process through Microsoft BizTalk Server while information workers can access data directly in the tools they use every day, such as the 2007 Microsoft Office system. SQL Server 2008 delivers a trusted, productive, and intelligent data platform for all your data needs.
Before you evaluate and install Microsoft SQL Server 2008 on a Windows Server 2003 server please make sure the following requirements are available:
If you are ok with those than go and install the SQL server 2008. My installation took me 15 minutes and the performance was awesome within a Virtual Server 2005 R2 virtual machine. Check out my screencast with installation screenshots.
Tags: 2008, installation, machine, Screencast, server, sql, virtual
Ivan Versluis April 27th, 2008
Couple minutes ago I initiated the remove of Active Directory and forced the demotion of a virtual machine domain controller. The domain controller exceed the 60day not being able to replicate and I was not able to get the replication working. It took me more than 90 minutes to troubleshoot and fix the problem. Since Windows 2003 there is option in the dcpromo tool to force the Active Directory removal.
| 1. |
By default, Windows Server 2003 domain controllers support forced demotion. Click Start, click Run, and then type the following command:
dcpromo /forceremoval
|
| 2. |
Click OK. |
| 3. |
At the Welcome to the Active Directory Installation Wizard page, click Next. |
| 4. |
At the Force the Removal of Active Directory page, click Next. |
| 5. |
In Administrator Password, type the password and confirmed password that you want to assign to the Administrator account of the local SAM database, and then click Next. |
| 6. |
In Summary, click Next. |
| 7. |
Perform a metadata cleanup for the demoted domain controller on a surviving domain controller in the forest. |
|
Reboot the server and cleanup the metadata with ntdsutil. I hate to use workaround like this, but there is not quick and dirty fix for me now. I am planning and testing to upgrade my Exchange 2007 server to SP1, but because the replication to the second dc did not take place for more than 60days the replication stopped.
One of the Errors on my primary domain controller. Demote didn’t work with force removal and option 3 also did not fix the problem when using the registry fix.
Event Type: Error
Event Source: NTDS Replication
Event Category: Replication
Event ID: 2042
Date: 4/27/2008
Time: 5:18:39 PM
User: NT AUTHORITY\ANONYMOUS LOGON
Computer: NET-DC-01
Description:
It has been too long since this machine last replicated with the named source machine. The time between replications with this source has exceeded the tombstone lifetime. Replication has been stopped with this source.
The reason that replication is not allowed to continue is that the two machine’s views of deleted objects may now be different. The source machine may still have copies of objects that have been deleted (and garbage collected) on this machine. If they were allowed to replicate, the source machine might return objects which have already been deleted.
Time of last successful replication:
2008-01-26 20:26:04
Invocation ID of source:
01dcf6c8-f6b8-01dc-0100-000000000000
Name of source:
e02a9b21-b7e0-4be6-9cc9-971b00325f65._msdcs.Networknet.nl
Tombstone lifetime (days):
60
The replication operation has failed.
User Action:
Determine which of the two machines was disconnected from the forest and is now out of date. You have three options:
1. Demote or reinstall the machine(s) that were disconnected.
2. Use the “repadmin /removelingeringobjects” tool to remove inconsistent deleted objects and then resume replication.
3. Resume replication. Inconsistent deleted objects may be introduced. You can continue replication by using the following registry key. Once the systems replicate once, it is recommended that you remove the key to reinstate the protection.
Registry Key:
HKLM\System\CurrentControlSet\Services\NTDS\Parameters\Allow Replication With Divergent and Corrupt Partner
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
For more information check the knowledge base article.
Tags: Error, fix, guest, kb332199, machine, replication, virtual
Ivan Versluis April 16th, 2008
How many of us have Windows Updates automatically configured and Virus Protection installed when using client OS virtual machines for test environments? I hope most of you because unprotected virtual machine in your enterprise environment has the same risk as a physical machine. There is no difference between a virtual or physical installation of Windows XP.
Recently I installed Symantec AntiVirus 10.2 on my Windows XP virtual machine. Hopefully the attach as shown below did protect me against the Adware which was installed on my virtual machine.
I was using couple of Internet Explorer sessions and searching for my phpmyadmin issues on one of my virtual machines. I used google and opened top 10 of the results. At some point I’ve got a popup of downloading a exe file when closing all Internet Explorer instances and then my Auto-Protect results came up with threads being found. I definitely did not install anything. After the reboot the “AntiSpyware Master” application was installed without my permission; believe as an IT and Security pro I am not going to install programs which I don’t trust.
Continue Reading »
Tags: machine, Security, tips, virtual, Virtualization
Ivan Versluis March 10th, 2008
Doing some research and going through my del.icio.us links I hit the blog of Virtual PC Guy from MSDN. He had a web link to one of the latest cookbooks "Deployment Cookbook: Backup and Recovery with Microsoft® Virtual Server 2005 R2 Service Pack 1 and Acronis® True Image 9.1 Enterprise Edition"
![clip_image002[5]](http://www.networknet.nl/apps/wp/wp-content/uploads/BackupandRecoverycookbookwithAcronisandM_129EC/clip_image0025.jpg)
Spending 30 minutes to read this document is worth the time to see how things work with Acronis True Image Enterprise Server.
Tags: Acronis, cookbook, enterprise, image, server, true, virtual
