Here is the article on how to make it happen!
http://blogs.technet.com/b/exchange/archive/2006/12/28/3397620.aspx
How to setup open relay for a specific server in Exchange
Leave a reply
PowerShell Script To Create Folders From CSV
This script will read in a csv named users.csv and create a bunch of directories from it. A log file will be written named logfile.log
###########################################################
# MODIFIED: Jack Stromberg
# DATE : 7/19/2012
# COMMENTS: $_.FirstName and $_.LastName are the column names in the csv file
###########################################################
# Get current directory and set import file in variable
$path = Split-Path -parent $MyInvocation.MyCommand.Definition
$newpath = $path + "\users.csv"
# Define variables
$log = $path + "\logfile.log"
$date = Get-Date
# FUNCTIONS
Function createDirs
{
"Created following directories (on " + $date + ") " | Out-File $log -append
"--------------------------------------------" | Out-File $log -append
Import-CSV $newpath | ForEach-Object {
$dir = $path + "\" + $_.FirstName + "." + $_.LastName + "\"
$dir = $dir.ToLower()
New-Item $dir -type directory
}
}
# RUN SCRIPT
createDirs
#FinishedHow to power off a hanging VM in ESXi
So to do this in ESXi, see this tutorial: http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=1014165
I found out that the commands from ESX are completely different, so if you are receiving the “vmware-cmd” not recognized, you are probably running ESXi and need to use the commands from the KB article above.
How to redirect to HTTPS OWA on Exchange 2010
Here is an excellent article on how to do it: http://briandesmond.com/blog/redirecting-owa-urls-in-exchange-2010/
PowerShell – Disabled Execution
If you see an error like this in PowerShell:
File ****************** cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details.
Execute the following command:
Set-ExecutionPolicy RemoteSigned
Windows cannot access the specified device, path, or file.
If you try to run an executable and you receive this dialog box:
“Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item.”
Here is the fix. Right click on the executable, and click on the Unblock button.
Done! 🙂
VMWare Lockdown Mode
Here is how to enable it:
To enable Lockdown mode via console:
Log in directly to the ESXi host.
Open DCUI on the host.
Press F2 for Initial Setup.
Toggle the Configure Lockdown Mode setting.
To enable Lockdown mode via vSphere:
Log in to vSphere
Click on the Home->Inventory->Hosts and Clusters
Click on the host you want to manage
Click on the Configuration manager
Click on “Security Profile” on the left side
Click the Edit… link next to Lockdown Mode
Enable it!
Delete everything from a msSQL table
Here is the command!
TRUNCATE TABLE mytablePreparing Server 2008 R2 for vCenter Server 5
If you are installing VMware vCenter5 and you notice that their are no connectors for connecting to a remote msSQL database, here is how to add a new ODBC connector to get things up and running.
- 1. Install .NET framework tools 3.5 (Can be done by adding a Feature and in the Server Manager of Server 2008 R2)
- Download and install the Microsoft SQL Server Native Client for Server 2008
- Create a new ODBC connection
- To do this, try installing the ODBC connection through the control panel by going to: Control Panel ->Administrative Tools -> Data Sources (ODBC)
- NOTE: If you notice later on that vServer doesn’t find an ODBC source, try opening the configuration manager with an elevated command prompt and type in
- c:\Windows\SysWOW64\odbcad32.exe
- NOTE: If you notice later on that vServer doesn’t find an ODBC source, try opening the configuration manager with an elevated command prompt and type in
- To do this, try installing the ODBC connection through the control panel by going to: Control Panel ->Administrative Tools -> Data Sources (ODBC)
- Click on the System DSN tab
- Click Add
- Click on SQL Server Native Client 10.0
- Click Finish
- Type in the name, description, and server to connect to.
- Click Next
- Fill out how you want to authenticate
- Click Next
- Change the default database to whateveryourdatabaseiscalled
- Click Next
- Click Next
- Finish
- Test Data Source…
–You should see “TESTS COMPLETED SUCCESSFULLY!”
Enabling remote SQL connections for Server 2008
Here is how to enable remote SQL connections for Server 2008:
Open up SQL Server Configuration Manager
Click on SQL Server Network Configuration
–Enable Named Pipes
–Enable TCP/IP
Protocols for SQLEXPRESS (OR YOUR INSTANCE)
-Double click on TCP/IP
Find the IP addresses with your IP and IP of 127.0.0.1
–TCP Dyanmic Ports (Remove the 0 and leave empty)
–TCP Port 1433
Open up Windows Firewall with Advanced Security
-Click on Inbound Rules
–Create the following rules
SQL
1433 – TCP – Check if you want Domain, Private, and Public Access
SQL
1434 – UDP – Check if you want Domain, Private, and Public Access
Transact-SQL debugger (Used for Visual Studio)
135 – TCP – Check if you want Domain, Private, and Public Access