Advertisements

vCenter 5: The FQDN cannot be resolved. What to try after you set up a reverse dns lookup

http://blog.coildomain.com/2011/08/vcenter-5-the-fqdn-cannot-be-resolved/

 

I had the same problem, but my reverse lookup record was fine. It took 30 minutes of hair-pulling, but I figured out that the binding order of the NICs on my vCenter server was causing it. I have one NIC on the server network and another for iSCSI connectivity. Since the iSCSI adapter was bound first, the FQDN check kept failing since the iSCSI network is isolated from the server networks, and of course, the DNS server.

To fix this if you have a similar situation, goto the Change Adapter Settings screen where it lists your local area connections. Hold the ALT key for a second and then goto advanced and advanced settings. Under Connections, move the connection that has access to the DNS server to the top.

 

http://theregime.wordpress.com/2008/03/04/how-to-setview-the-nic-bind-order-in-windows/

Advertisements

Equallogic PortForwarding and Server 2008 R2

Well, previously https://michaelellerbeck.com/2009/11/30/so-you-bought-an-equallogic-san-now-what-part-two/

I would use the venerable rinetd to handle portforwarding on windows. But alas, along comes server 2008 R2 and it doesn’t working anymore (actually I never tested, it might work)

But, Server 2008 R2 has built in functionality for port forwarding (nifty!)

http://www.rickwargo.com/2011/01/08/port-forwarding-port-mapping-on-windows-server-2008-r2/

So I just gave it a

netsh interface portproxy add v4tov4 listenport=25 listenaddress=10.10.50.51 connectport=25 connectaddress=192.168.1.1

Now I point the equallogic to 10.10.50.51 (an address reachable on the san network) (It requires two nics on the ‘bridge’ server of course one on each network)

And now I can get the email alerts out! Nifty

How to unistall KB 968930

1) Start regedit

2) Find “968930” minus “”

3) Eventually finds HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\KB968930\SP10\KB968930

4) Copy the value data of “UninstallCommand”

5) Paste into a cmd prompt

6) Wait for “Windows Management Framework Core has been successfully removed. [Finish]

7) (Windows de rigeur cliche) reboot

8) Reinstall WMFC

Database Collation and trying to detect changes

–Test 1 If database collation is case insenstive and you are trying to detect changes on a column where only the case has changed, this will not detect

SELECT A.*

FROM (SELECT ‘SQLSERVERCASECOLLATIONTEST’ AS COLA,’COLLATIONA’ AS COLB) A

LEFT JOIN (SELECT ‘sqlservercasecollationtest’ AS COLA,’COLLATIONA’ AS COLB) B ON A.COLA=B.COLA

WHERE B.COLA IS NULL

–Test 2 If database collation is case insenstive and you are trying to detect changes on a column, this will detect

SELECT A.*

FROM (SELECT ‘SQLSERVERCASECOLLATIONTEST’ AS COLA,’COLLATIONA’ AS COLB,BINARY_CHECKSUM(‘SQLSERVERCASECOLLATIONTEST’,’COLLATIONA’) AS COLC ) A

LEFT JOIN (SELECT ‘sqlservercasecollationtest’ AS COLA,’COLLATIONA’ AS COLB,BINARY_CHECKSUM(‘sqlservercasecollationtest’,’COLLATIONA’) AS COLC ) B ON A.COLC=B.COLC

WHERE B.COLC IS NULL

How to schedule a vCheck (PowerShell) for vmware

I just created a .bat file with the following

C:\WINDOWS\system32\windowspowershell\v1.0\powershell.exe -PSConsoleFile “%ProgramFiles%\VMware\Infrastructure\vSphere PowerCLI\vim.psc1” -File “C:\vCheck\vCheck.ps1”

Watch those stupid quotation marks, WP tends to mangle them