TwitterFacebookGoogle
formats

Complete Remote System Administration – IIS Exchange AD DHCP DNS SQL

Posted on by
Toolbox-icon

This guide shows how you can manage all of your major server roles remotely without ever logging into the servers themselves.

To use these tools you will need Windows 7 Pro or higher, I prefer Windows 7 Pro 64bit.

If you have a 32bit version of Windows you will be limited on which tools you can use.

First lets cover Microsoft IIS Management

Open your Control Panel and select Programs and Features, From here select Turn Windows Features On or Off

Select Internet Information Services – Web Management Tools

From here you can select IIS 6 Management Tools for management of a 2003 Server running IIS and you can select the Standard IIS Management Tools for management of a modern 2008-2012 server.

Man-Tools-01

 

From here you can also select Telnet Client and TFTP Client

Man-Tools-02

Now we can grab the Windows Server Remote Management Tools, these tools will allow you to manage everything you see in the Administrative Tools menu on your server including Active Directory, DHCP, DNS and more.

http://www.microsoft.com/en-us/download/details.aspx?id=7887

To manage Microsoft SQL you can download the latest SQL Management Studio Software here

http://www.microsoft.com/en-us/download/details.aspx?id=29062

After you select the download button you will be presented with some options, Select ENU\x64\SQLManagementStudio_x64_ENU.exe or ENU\x86\SQLManagementStudio_x86_ENU.exe based on your Processor Architecture.

Exchange Management Console and Shell

or you can use your Microsoft Exchange installation CD

You will need 64bit Windows to manage Exchange

Microsoft Exchange 2007 Management Tools

http://www.microsoft.com/en-us/download/details.aspx?id=11876

Microsoft Exchange 2010 Management Tools

http://www.microsoft.com/en-us/download/details.aspx?id=21570

Additional Installation Instructions for Microsoft Exchange Management Tools

http://exchangeserverpro.com/exchange-2010-install-management-tools/

If you would like to manage Windows Server with Powershell commands you will need to download the proper shells for each service such as the Exchange Shell and then either use that Shell to manage Exchange or load the Exchange commandlets into the standard Powershell window.

Microsoft PowerShell Tools and Commands

Execution Policy
Set-ExecutionPolicy Unrestricted -Force

Modules
Get-Module -ListAvailable
Import-Module ActiveDirectory -ErrorAction SilentlyContinue

Snapins
Get-PSSnapin -registered | add-pssnapin -passthru
Add-PSSnapin Microsoft.Exchange,Microsoft.Windows.AD
Add-PSSnapin Quest.ActiveRoles.ADManagement
Add-PSSnapin Microsoft.SharePoint.PowerShell
Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100
Add-PSSnapin Windows.ServerBackup
Add-PSSnapin Microsoft.SqlServer.Management.Smo

 

Microsoft® SQL Server® 2012 Native Client
http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409 x64
http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409 x86
Microsoft® System CLR Types for Microsoft® SQL Server® 2012
http://go.microsoft.com/fwlink/?LinkID=239644&clcid=0x409 x64
http://go.microsoft.com/fwlink/?LinkID=239643&clcid=0x409 x86
Microsoft® SQL Server® 2012 Command Line Utilities
http://go.microsoft.com/fwlink/?LinkID=239650&clcid=0x409 x64
http://go.microsoft.com/fwlink/?LinkID=239649&clcid=0x409 x86
Microsoft® SQL Server® 2012 Shared Management Objects
http://go.microsoft.com/fwlink/?LinkID=239659&clcid=0x409 x64
http://go.microsoft.com/fwlink/?LinkID=239658&clcid=0x409 x86
Microsoft® Windows PowerShell Extensions for Microsoft® SQL Server® 2012
http://go.microsoft.com/fwlink/?LinkID=239656&clcid=0x409 x64
http://go.microsoft.com/fwlink/?LinkID=239655&clcid=0x409 x86

To load these modules use the following commands

Set-ExecutionPolicy Unrestricted -Force

Import-Module servermanager -ErrorAction SilentlyContinue
Import-Module grouppolicy -ErrorAction SilentlyContinue
Import-Module “sqlps” -DisableNameChecking -ErrorAction SilentlyContinue

Add-WindowsFeature -Name backup-features -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue
Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue

 

 

 

 

 

 

 

 

Related posts:

  1. Hyper-V & Core Must Have’s – Core Configurator & PowerShell Management Library !!!!!! Click HERE for NEW Updated Article for Server Core 2008 R2 & Server Core 2012 + Hyper-V Core !!!!!! I thought I would share a couple links to some must have Server 2008 Core and Hyper-V Software. Core Configurator 2.0 & PowerShell Management Library for Hyper-V. Core Configurator 2.0...
  2. Check Exchange Version Easily From the Exchange Management Shell Run the following command GCM exsetup |%{$_.Fileversioninfo} Note the ProductVersion number Check against Microsoft Exchange version referrence http://technet.microsoft.com/en-us/library/hh135098.aspx...
  3. Resize Partitions when a server is out of space This is a quick guide to resizing partitions when a server is out of space and has multiple partitions on 1 hard drive. First verify the amount of free space on the separate partitions that exist on the hard drive you would like to resize. As you can see here...
  4. Configure Windows as a Local NTP Time Server Open the Registry and navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time Nearly all of the configuration will take place here   First setup the AnnounceFlag to tell the network you are a time server HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time\Config Edit AnnounceFlags Edit Hexadecimal, Value = 5 (This value announces there is an NTP Time Server on the Network)...
  5. Disk Optimization for SQL Servers & Databases One of the easiest ways to improve the lifetime performance of a SQL Server database is proper setup of the physical and logical drives. While it’s an easy technique, proper disk subsystem configuration is often overlooked or handled by a member of the IT staff other than a SQL Server...

Leave a Reply

CyberChimps