Tuesday, May 10, 2011

Rename a SQL server

Check the server name:
Select @@ServerName

For a server with a default instance:
sp_dropserver 'old_name'
GO
sp_addserver 'new_name', 'local'
GO

For a server with a named instance:
sp_dropserver <'old_name\instancename'>
GO
sp_addserver <'new_name\instancename'>, local
GO

Restart the SQL Server instance

Thursday, April 14, 2011

Get list of VMs on physical host

  1. Run the VMM powershell module
  2. Get-VMMServer -ComputerName VMMserver.domain.com
  3. Get-VM -VMHost hostservername.domain.com | Format-List -property Name > output.txt

Tuesday, April 12, 2011

Restore iPhone without passcode

  1. Connect to iTunes
  2. Hold the Power and Home buttons for 10 secs.
  3. Release Power but keep holding Home for another 10 secs.
  4. iTunes should detect the phone in recovery mode, and prompt to restore.

Sunday, March 6, 2011

Event ID: 4007 DNS Server error

The DNS server was unable to open zone _msdcs.nwtraders.msft in the Active Directory from the application directory partition ForestDnsZones.nwtraders.msft. This DNS server is configured to obtain and use information from the directory for this zone and is unable to load the zone without it. Check that the Active Directory is functioning properly and reload the zone. The event data is the error code.

Remove the offending zone entries from:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DNS Server\Zone