Apr 18 2012

How to export the relay list from an Exchange 2003 server

It’s always a good idea to export your relay list regularly in case of server crash or failures. Yes there’s other ways to restore this but if you have a txt document then it’s a lot quicker to import the list to a rebuilt or new server.

In order to do this download IPsec.vbs from here.

After you have downloaded the package unzip it and then register the exipsec.dll by opening the command prompt and using the syntax “regsvr32 pathtoexipsecurityexipsec.dll” and pressing enter.

After registering the dll open the command prompt again and change to the ExIpSecurity folder. Then type “cscript ipsec.vbs -s (servername) -i (instance id like 1 or 2 or 3) -o e -d (domaincontroller name) -r relay >c:relaytable.txt

After running the script you should see a text document in c: named relaytable.txt which will contain all the allowed IP’s in the relay list.

For more information on ipsec.vbs just run cscript ipsec.vbs to get all the switches that are available for you to use. You are also able to import the list to a new server etc.

Apr 16 2012

How to verify your SQL Server Version

I had a query today from auditors that needed a SQL server’s version details and for some reason using help=>about does not show if it’s the Standard or Enterprise version.

To get this info open your SQL Management Studio, click on new query, in the query field type “select @@version” without the quotation marks, then click execute.
This will show you the SQL version details as per below screen shot.