For some reason Microsoft SQL express 2017 and 2019 requires TLS 1.0 during installation.

Here is the registry settings [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0]:

The same is for Server and Client

Make sure to revert it back to DisableByDefault =1 and Enabled =0

Splashtop on Windows computer name update

There are three options:

• 1. Rename it manually on the managed computer using splashtop client:

• 2. Rename it remotely using Splashtop Business:

• 3. Rename it using registry key delete:
  you can delete the key using remote management or by editing the registry on the remote machine directly using regedit by
  deleting this key and restarting the computer:
  HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Splashtop Inc.\Splashtop Remote Server\CloudComputerName

Exchagne 2016 update address books using EMS

 Open EMS:

Get-AddressList | Update-AddressList
Get-GlobalAddressList | Update-GlobalAddressList
Get-OfflineAddressBook | Update-OfflineAddressBook

Restart outlook or update outlook offline address book under Send/ Receive Groups:

Windows 10 remove System Drive after 1803 upgrade

This is what worked for me:

1. start; CMD right click select Run As Administrator
2. mountvol <Letter of the Drive> /d

 

resource:

https://support.microsoft.com/en-us/help/4337524/windows-10-april-update-new-partition-appears-after-installing

Add FROM: in outlook 2016

 

1. click on “New Email”
2. select options from the tabs on top.
3. click on From icon

that  is all

 

Remove Printer Driver on Windows 10

 To completely uninstall driver after printer has been removed and deleted:

run this command using windows + R

printui /s /t2

this will bring up a list of installed drivers.

Select the one which need to be removed and delete it.

office 2016 remove repeated activation

 this fix is for VLC activation:

Close the activation window and all Office apps.

Open regedit (using run or type it at the start menu)

It is always very important to make backup of registry or the registry key you are changing or deleting first.(use export under file menu)

navigate to:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\16.0\Common\OEM

Edit>Delete.

Do the same with this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\OEM

Close the Registry Editor and start Office again.

 

resources:

https://support.office.com/en-us/article/Office-repeatedly-prompts-you-to-activate-on-a-new-PC-a9a6b05f-f6ce-4d1f-8d49-eb5007b64ba1

 

windows 10 system recovery drive remove drive letter

 From elevated command prompt:

diskpart

list volume

In my case the drive letter for the system partition was D

select volume D

remove letter=D

Close Command Prompt and restart your PC

Wired 802.1x authentication with MS RADIUS server and Meraki switch

 Group policy:

1. 
2. 

 

NPS configuration:

1. add all switches under RADIUS clients
   
   You will have to use the same shared secret on switch RADIUS authentication
2. Create new (or edit existing) Connection Request Policy
   Use all default only add condition NAS Port Type “Ethernet”
   
3. Create new Network Policy:
   
   
   
   * under NAS Port Type select ETHERNET
   
   
4. On the Meraki switch access control configure new policy:
   
5. Assign the policy to individual ports:
   

Posted in Network, Servers, WindowsTagged wired 802.1xEdit 

Windows server service will not stop

 Force quit windows service which failed to stop using service.msc

1. find service name using service.msc / properties
2. using command prompt enter sc queryex [servicename] (and note PID number)
3. enter taskkill /pid [pid number] /f

Outlook 2016 to Exchange 2016 mapi connection problems.

 During my exchange 2010 to exchange 2016 migration I run in to outlook connectivity problem which made it impossible to connect.

There are hundreds of similar issues on google unfortunately none of them solved the problem until I found two solutions on separate blogs and combined them and here is my final fix:

1. Set-MapiVirtualDirectory -identity “exchange2016\mapi (Default Web site)” -IISAuthenticationMethods NTLM
2. this requires editing Autodiscover and EWS virtual directory using IIS server interface on the exchange 2016 server.
   Remove negotiate provider from Windows Authentication.
   

 

References:

1. this is the first blog thanks to which I was able to get outlook 2016 working unfortunately only with exchange cached mode disable.
2. this is the send blog (last post have the solution) which helped me to get outlook 2016 working on the local LAN and behind the firewall as well as with or without using exchange cached mode.
3. In addition you need to have MAPI enabled on the exchange 2016 server which is the default but just in case here is the MS link with instructions.

change pwdLastSet to reset user password last set in AD

 what worked for me was to change it to 0 first and then change it to -1

If set to 0 it will force user to change password on next login. (If user doesn’t have flag set to Don’t Expire Password)

If set to -1 the password change date will be set to current date and time.

 

reference:

http://ldapwiki.com/wiki/Pwd-Last-Set%20attribute

exchange 2010 remove users emails before specific date

If user has a lot of emails which they need to delete here is a command which can help at the server end:

 

Search-Mailbox -Identity “User Name” -SearchQuery “Received:<$(’12/31/2013′)” -DeleteContent

 

ref: https://social.technet.microsoft.com/Forums/exchange/en-US/6114adb8-7e65-46e0-b54f-704ad15ef723/command-to-delete-all-the-items-from-a-mailbox-till-a-specific-date?forum=exchange2010

exchange 2010 failed to create new GAL

error when trying to create new GAL using:

New-GlobalAddresslist “new GAL” –ConditionalCustomAttribute1 “STAFF” –IncludedRecipients “AllRecipients”

WARNING: One or more global address lists were missing from the Active Directory attribute. This is likely caused by
using legacy Exchange management tools to create global address lists.
Active Directory operation failed on server1.domain.local. This error is not retriable. Additional information: The name ref
erence is invalid.
This may be caused by replication latency between Active Directory domain controllers.
Active directory response: 000020B5: AtrErr: DSID-03152C47, #1:
0: 000020B5: DSID-03152C47, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 907ff (globalAddressList2)
+ CategoryInfo : NotSpecified: (0:Int32) [New-GlobalAddressList], ADConstraintViolationException
+ FullyQualifiedErrorId : 8E376CCD,Microsoft.Exchange.Management.SystemConfigurationTasks.NewGlobalAddressList

 

the most likely problem is corupted entry.

This can be tested using power shell script on AD server:

---

$ad = [ADSI]"LDAP://rootDSE";
$domain = $ad.rootDomainNamingContext;
$obj = New-Object System.DirectoryServices.DirectoryEntry("LDAP://CN=Microsoft Exchange,CN=Services,CN=Configuration,$domain"); 

$count = 0;
$Gals1= $obj.GlobalAddressList;
foreach($g in $Gals1)
{
   $g= $g.ToString().ToLower(); 
   if($g.Contains("cn=deleted objects"))
   {
      Write-Host $g;
      $count= $count +1;  
   }
}

Write-Host "$Count corrupted GAL entries found in property GlobalAddressList";

$count = 0;
$Gals2= $obj.GlobalAddressList2;
foreach($g in $Gals2)
{  
   $g= $g.ToString().ToLower();
   if($g.Contains("cn=deleted objects"))  
   {
      Write-Host $g;          
      $count= $count +1;  
   }
}
Write-Host "$Count corrupted GAL entries found in property GlobalAddressList2";

---

you will get output something like this:

cn=default global address list\0adel:cc665233-b490-477a-a972-60fdd6d991ef,cn=deleted objects,cn=configuration,dc=domain,dc=
local
1 corrupted GAL entries found in property GlobalAddressList
0 corrupted GAL entries found in property GlobalAddressList2

If you find corrupted entries (make sure to have full system backup) you will have to remove them using ADSI edit on domain controller.

Using ADSI edit connect to configuration:

configuration\ Services\ Microsoft Exchange (right click / properties)

depending on the listed corruption look for GlobalAddressList or GlobalAddressList2 and click edit.

Remove corrupted entries.

This helped me to fix creating new GAL.

 

reference:

https://social.technet.microsoft.com/Forums/exchange/en-US/52854856-f517-4827-b3d3-3e589a422672/exchange-2010-sp-2-cant-create-second-gal?forum=exchange2010hosters

https://social.msdn.microsoft.com/Forums/en-US/3210af54-d8b4-490f-9f5f-f4fc3209d324/newglobaladdresslist-fails-ad44a06f?forum=os_exchangeprotocols&forum=os_exchangeprotocols

 

https://www.experts-exchange.com/articles/12458/Failed-to-create-New-Global-Address-List-on-Exchange-2010.html

Compress folder on macOS Sierra and windows 10

 macOS Sierra:

1. Create folder and place all the files you want to compress in it.

2. Right click on the folder and click on Compress.

 

Windows 10:

1. Create folder and place all the files you want to compress in it.
2. Right click on the folder and select Send to > Compressed (zipped) folder.

Posted in Apple, WindowsTagged compressedEdit 

Find email address on exchange 2010 server

 

1. Get-Recipient -Identity user@domain.com
you can use this to find user associated with a specific email address 
2. Get-Recipient -ANR user
or by using -ANR (Ambiguous Name Resolution) to find using part of a user name

Purge disconnected mailbox on exchange 2010

One option is to wait for the mailbox to be purged automatically (default 30 days)

or to use Cmdlet:

Remove-StoreMailbox -Database <mailboxDatabaseName> -Identity <DisplayName> -Mailbox

Format HDD for exchange 2016 using ReFS

windows disk management:

1. Initialize,GPT
2. Format ReFS, 64K, Quick format
3. assign drive letter: R

PowerShell: (to disable integrity streams)

1. Format-Volume -DriveLetter r -FileSystem ReFS -AllocationUnitSize 65536 -SetIntegrityStreams $false

 

Links:
http://www.careexchange.in/creating-refs-volumes-for-exchange-20132016/

https://www.veeam.com/blog/advanced-refs-integration-coming-veeam-availability-suite.html

https://www.vladan.fr/veeam-and-refs-best-practices-and-benefits/

vSphere shrink hard drive on windows OS

1. shrink HDD using windows disk management.
2. connect to host using SSH
3. turn off windows computer
4. cd /vmfs/volumes/<datastore name>/<VM foldername>
5. use cat “VM name.vmdk” (not the flat one) to make a note of the RW number#
6. calculate new size 128GB= 128 * 1024 * 1024 * 1024 /512 = 268435456
7. vi “VM name.vmdk” replace RW with the new number
8. vi edit shift I is to edit text; ESC to end editing; exit and save changes shift :x; shift:q! is to exit without changes
9. use vSphere to migrate or move VM to a temporary host (this will resize the HDD to the new size)
10. be patient depending on the HDD size it can take some time
11. verify size in temporary location using vSphere
12. move back to original location

 

Links:

https://www.experts-exchange.com/articles/12938/HOW-TO-Shrink-a-VMware-Virtual-Machine-Disk-VMDK-in-15-minutes.html

Exchange 2010 add user permissions on other user calendar

 add-MailboxFolderPermission -Identity smith@contoso.com:\calendar -User novak@contoso.com -AccessRights Reviewer

Here is MS link with additional information: https://technet.microsoft.com/en-us/library/bb124097(v=exchg.160).aspx