Tech for Techs

PROBLEM:
How to Limit Memory Usage from Exchange and SQL on Microsoft Small Business Server 2008 / 2011?
How to limit Exchange 2010 memory usage?
How to limit SQL Server 2005/2008 memory usage?

SOLUTION:

EXCHANGE SERVER (Part 1)
1.)Open ADSIedit by navigating to Start > All Programs > Administrative Tools > ADSI Edit.
2.) Right click the root of the tree and select "Connect To"
3.) Under "Connection Point" > Select a well known Naming Context > Select, "Configuration"



4.) Click OK.
5.) Once connected to the Configuration Naming Context, navigate to the following item:

Configuration -> Services -> Microsoft Exchange -> "Organization Name" -> Administrative Groups > "Administrative Group" -> Servers -> "Server Name" -> InformationStore

6.) Right click Information Store and choose properties.
7.) Scroll down to msExchESEParamCacheSizeMin attribute and set the value according to your requirements.
8.) Scroll down to msExchESEParamCacheSizeMax attribute and set the value according to your requirements.



9.) Restart Exchange Information Store Service.

NOTE: Exchange 2007 works with 8kB pages and Exchange 2010 works with 32kB pages.
So if you want to limit the size of memory used to 4GB, you will need the following calculations:

Exchange 2007: 4 GB = 4.194.304 KB / 8 KB => 524288
Exchange 2010: 4 GB = 4.194.304 KB / 32 KB => 131072


EXAMPLES:

Exchange 2010:
Min – 1GB: msExchESEParamCacheSizeMin = 32768
Max – 4GB: msExchESEParamCacheSizeMax = 131072

other - 512MB: = 16384

Exchange 2007:
Min – 1GB: msExchESEParamCacheSizeMin = 131072
Max – 4GB: msExchESEParamCacheSizeMax = 524288

other - 512MB = 65536


SQL SERVER (Part 2)
1.) Open "SQL Server Management Studio". Note: Right Click and Run-as Administrator.
2.) Login to the following instances.

• <SERVERNAME>\SBSMONITORING
• <SERVERNAME>\SHAREPOINT
• <SERVERNAME>\MICROSOFT##SSEE

Note: In order to log in to "MICROSOFT##SSEE" you have to use the following as the "Server Name".

\\.\pipe\mssql$microsoft##ssee\sql\query

3.) Right click on the root and choose properties.
4.) Under "Memory" change the Maximum Server Memory to desired amount.
5.) Restart SQL services.

PROBLEM:
Configure "Dynamic Recipient Verification" for SpamTitan.
How to Enable "Dynamic Recipient Verification" for Exchange 2007 / 2010 / 2013?

SOLUTIONS:
SPAMTITAN (Part 1)
1.) In the SpamTitan Dashboard.
2.) Go to, System Setup > Mail Rely > example.com and click on edit.
3.) Under "Recipient Verification" choose "Dynamic Recipient Verification".
4.) Save.

EXCHANGE (Part 2)
5.) In the Microsoft Exchange Management Console.
6.) Go to, Organization Configuration > Hub Transport.
7.) Enable "Recipient Filtering".

PROBLEM:
Windows 7 Image Activated but, windows still not genuine

SOLUTION:
1.) Click Start button.
2.) Type: CMD.exe into the 'Search programs and files' field
3.) Right-Click on CMD.exe and select 'Run as Administrator'
4.) Type: net stop sppsvc   (It may ask you if you are sure, select yes)

Note: the Software Protection service may not be running, this is ok.

5.) Type: cd %windir%\ServiceProfiles\NetworkService\AppData\Roaming\Microsoft\SoftwareProtectionPlatform
6.) Type: rename tokens.dat tokens.bar
7.) Type: cd %windir%\system32
8.) Type: net start sppsvc
9.) Type: slui.exe
10.) Re-enter product key and activate.
11.) Restart the computer.

If the below process fails with the following error:

"Configuration of SharePoint Products failed.  Configuration must be performed before you use SharePoint Products.  For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\PSCDiagnostics***.log and the application event log. " in Both Wizard and Powershell.

Run this command:

stsadm -o setproperty -pn command-line-upgrade-running -pv Yes

Then run the original command again:

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

PROBLEM:
Windows 2008 R2 - Setup was unable to create a new system partition.
Windows 2008 - Setup was unable to create a new system partition.

SOLUTION:
Remove all drives except the one windows is installing on.

Error: "Oops! We having a temporary issue completing this download. Please check back again later to see if these hissups have gone away."*

---

Resolution:

• Unhide Files and Folders
• Delete the "Cache" folder located C:\ProgramData\Oberon Media\Initiator\3.0.0.0\Cache
• Run the installation file as an administrator

*Please note, this is the exact error message and spelling/grammatical errors are intentional.

PROBLEM:
How to uninstall Microsoft Security Essentials using Command Line (CMD)?
How to uninstall Microsoft Security Essentials using a script?

SOLUTION:
Uninstall using command line.

1.) Open a command prompt in administrator mode.
2.) Copy and paste the following command.

"C:\Program Files\Microsoft Security Client\Setup.exe" /x /s

PROBLEM:
How to upgrade Ubiquiti Airvision NVR from 2.x to UniFi Video 3.0.5?
Upgrade Firmware and Linux Debian OS on Ubiquiti NVR.

SOLUTION:
1.) Download and Run Putty.
Run Once: http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe
Install: http://the.earth.li/~sgtatham/putty/latest/x86/putty-0.63-installer.exe

2.) Connect to NVR's IP address using SSH.

3.) Login using either the Default Username and Password or root and the password you created at setup.
Default: Username: root    Password: ubnt

4.) Run the following commands in order.

sudo apt-get update
sudo apt-get remove --purge airvision
wget http://dl.ubnt.com/firmwares/unifi-video/3.0.5/unifi-video_3.0.5~Debian7_amd64.deb

dpkg -i unifi-video_3.0.5~Debian7_amd64.deb

PROBLEM:
Opening MDI Intellefile causes Internet Explore 8 to crash.
MDI Intellefile has stopped working

SOLUTION:
Windows XP SP3 machines should have a combination of the follow software version in order for the Intellefile to work.

• Microsoft Windows XP SP3
• Microsoft Silverlight
• Microsoft .net Framework 3.5
• Adobe Acrobat Reader X

Notes: Make sure .net 4 and all other version of adobe are removed.

PROBLEM:
How to Backup Windows 8 and 8.1 with System Image?
Windows 8 "Backup and Restore" missing.
Windows 8 and 8.1 system image with Powershell Script.
ERROR - The file 'C: D:' is invalid while trying to run script.

SOLUTION:
There are two option to backup windows with a system image.

MANUALLY
To make a system image backup in Windows 8.1, you must navigate to the File History control panel (and not the main File History interface, which is in the Metro-style PC Settings.) Using Smart Search, be sure to choose the right entry.



In the File History control panel that appears, look in the lower left corner. The option you're looking for is System Image Backup. Click that, and the familiar Create a System Image wizard appears and you're good to go.



AUTOMATIC / SCHEDULE / SCRIPT
1.) Create a powershell script:
Create the script in a plain text editor such as Notepad and save with a .PS1 file extension (for example, myscript.ps1).

2.) Paste one of the following commands inside the script and save it:

wbAdmin start backup -backupTarget:Z: -allCritical -quiet
(System Image of all Critical OS Volumes)

wbAdmin start backup -backupTarget:Z: -include:D:,F: -allCritical -quiet
(System Image of all Critical OS Volumes plus D: Drive and F: Drive)

wbAdmin start backup -backupTarget:\\remoteComputer\\Folder -include:D: -allCritical -quiet
(System Image of all Critical OS Volumes plus D: Drive and F: Drive, Save to Network Share)

3.) Schedule the script using "Task Scheduler" in Windows. Make sure to "Run with Highest Privilege"