Granikos, nikos one, Enterprise Ecommerce, Enterprise Services, Exchange Migration, Office 365, Hybrid, Email Security, Mcommerce, M2M, Industry 4.0
Granikos GmbH & Co KG - Ecommerce Solutions and Enterprise Services
Exchange Server Workshop
Office 365 Workshop
Granikos Consulting Solutions
Support (external link)
I Just Can't Get Enough of IT
Email and Cloud Solutions
Granikos is a Microsoft Master Level Technology Organization with a solid track record of Enterprise architecture, design, programme definition | planning | delivery.
Set-UserPictures now supports Exchange Online
The PowerShell script Set-UserPictures now supports uploading resized user pictures to Exchange On-Premises and Exchange Online. Read more about the new functionality here: https://www.granikos.eu/en/justcantgetenough/PostId/307/add-resized-user-photos-automatically Download the updated script here: Github: https://github.com/Apoc70/Set-UserPictures TechNet: https://gallery.technet.microsoft.com/Bulk-resize-and-adding-of-1e74d85e Enjoy!
Cannot connect to SharePoint Online with PowerShell
Problem: When you try to connect to SharePoint Online using PowerShell you receive an Access Denied error as follows: PS C:\> Connect-SPOService -Url https://tenant-admin.sharepoint.com -credential $credential Connect-SPOService : Cannot contact web site 'https://tenant-admin.sharepoint.com/' or the web site does not support SharePoint Online credentials. The response status code is 'Unauthorized'. The response headers are 'X-SharePointHealthScore=0, SPRequestGuid=310ce59d-002b-3000-ef1a-70e5fe7eaf72, request-id=310ce59d-002b-3000-ef1a-70e5fe7eaf72, X-MSDAVEXT_Error=917656; Acces s+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the +web+site+and+select+the+option+to+login+automatically., Solution Connecto to the SPO Service without the previously entered credentials ($credential) and enable the LegacyAuthProtocolsEnabled attribute. Set-SPOTenant -LegacyAuthProtocolsEnabled $True Enjoy SharePoint Online.
Access Services Custom web app deployment fails in SharePoint 2013
Problem After configuring Access Services you cannot deploy Access custom web apps from Access 2013 - an error with a Correlation ID occurs. Reason As if it´s not inconvenient enough to configure the SharePoint Access Services Requirements (e.g. AppStore with DNS), the SQL Server Configuration can be the cause, too. In the SharePoint Site Content overview you can see the faulty deployed App and in it`s details the following error: The database server is temporarily unavailable. Details: The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database. You may need to use RECONFIGURE to set the value_in_use. ALTER DATABASE statement failed. Solution You need to enable the SQL Server 2012 Feature Contained Database Authentication if you receive this error. You can do this in the Management Studio via this T-SQL statement: SP_CONFIGURE 'contained database authentication', 1; GO RECONFIGURE; GO Enjoy SharePoint!
Email Security Gateway NoSpamProxy available in Azure
Last updated: 2017-02-08 NoSpamProxy Azure Edition is the cloud based email security gateway of the successful NoSpamProxy family of products by Net at Work. The Azure edition of NoSpamProxy can easiliy be deployed using the Microsoft Azure Marketplace. NoSpamProxy Azure easily connects an Office 365 tenant and offers an easy way to provide centralized email encryption and decryption with PGP and/or S/MIME for mailboxes hosted in Exchange Online. Additionally, NoSpamProxy Azure provides compliant anti-spam handling, an anti-malware component, and a large file portal. The edition currently available in Microsoft Azure installs a NoSpamProxy single-server deployment. A single-server deployment combines the NoSpamProxy intranet role and the gateway role on a single server. The NoSpamProxy Azure Edition is provided as BYOL (Bring Your Own License) deployment. In addition to the recurring fees for the Microsoft Azure VM you are required to buy a NoSpamProxy license. If you already own a NoSpamProxy Version 11 license, the license can be used for the NoSpamProxy Azure Edition as well. Content DeploymentOptions Notes Deployment Links Deployment Options Due to the nature of a cloud service NoSpamProxy Azure can be operated in different scenarios in ...
SPF, DKIM, DMARC and DNS
This is a translated blog post of the original post in German, which can be read here. Different technologies are used to verify the validity of email senders. Each technolgy by itself represents only one component of an holistic solution. It is currently recommended to implemtent all three technologies. The technologies are: SPF - Sender Policy Framework The SPF resource record of a DNS zone defines which servers (host names or IP addresses) are allowed to send emails on behalf of the domain. Each sender domain must have it's own SPF resource record. DKIM - Domain Keys Identified Mail DKIM pursues the same objective as SPF. With DKIM parts of an email message are enrypted using a provivate key. The public key is published as a DNS resource record. In the most cases the key pair ist generated by the mail servers, as these encrpyt the message anyway. DMARC - Domain-based Message Authentication, Reporting & Conformance DMARC is placed on top of SPF and DKIM. DMARC executes a so called alignment for SPF and DKIM. An alignment defines a ...
Read More »
Last updated: 2017-08-20 The SMTP Simulator project has been started due to a specific demand during a customer project. We needed a solution to test native transport of Exchange Server 2013 and third party addons to Exchange in an isolated lab envrionment having no internet access at all. While it is pretty easy to send test emails using PowerShell, we wanted to create an automated service which is capable of: replies to incoming emails has configured internal and external SMTP domains creates random local email addresses sends emails depending on a schedule to simulate user behaviour fixed number of emails per timeframe random number of emails per timeframe send misformed emails adds attachments to outgoing emails documents archives / password protected archives EICAR files simple testing of POP3/IMAP4 remote connections runs as a Windows service has a nice web interface for simplified administration access to SMTP send/receice logs The SMTP Simulator can be used with any Message Transfer Agents (MTA), not only with Exchange. Besides testing the ...
GlobalFunctions updated to support WriteOnConsole
The GlobalFunctions PowerShell module has been updated to support writing of log messages to the PowerShell output pipeline. When writing to the PowerShell output pipeline, the severity level is not written to the pipeline. In most cases you will use this option for debugging purposes. Example # Import module first Import-Module -Name GlobalFunctions # Create an instance of the logger $ScriptDir = Split-Path -Path $script:MyInvocation.MyCommand.Path $ScriptName = $MyInvocation.MyCommand.Name $logger = New-Logger -ScriptRoot $ScriptDir -ScriptName $ScriptName -LogFileRetention 14 # Write an informational message to the log file only $logger.Write('Some informational message') # Write an informational message to the log file only $logger.Write('Some message to log and console',0,$true) # Write a warning level message to log file and the message only to PowerShell output pipeline $logger.Write('Some warning message',2,$true) Note Remember to add the severity level when writing to console. Read more about the GlobalFunctions module here. You can get the source code here: Import from PowerShellGallery: https://www.powershellgallery.com/packages/GlobalFunctions Download and follow at Github: https://github.com/Apoc70/GlobalFunctions Download and like at TechNet Gallery: https://gallery.technet.microsoft.com/Centralized-logging-64e20f97
System.UnauthorizedAccessException when preparing Active Directory
When you run the following cmdlet to prepare Active Directory for the installation of an Exchange Server Cumulative Update (in this case CU17) you might encounter a System.UnauthorizedAccessException. D:\tmp\Cu17>setup.exe /PrepareAD /IAcceptExchangeServerLicenseTerms Microsoft Exchange Server 2013 Cumulative Update 17 Unattended Setup Unhandled Exception: System.UnauthorizedAccessException: Access to the path 'C:\ Windows\Temp\ExchangeSetup\ExSetup.exe' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at Microsoft.Exchange.Setup.CommonBase.SetupHelper.DeleteDirectory(String pat h) at Microsoft.Exchange.Bootstrapper.Setup.BootstrapperBase.CopySetupBootstrapp erFiles() at Microsoft.Exchange.Bootstrapper.Setup.Setup.Run() at Microsoft.Exchange.Bootstrapper.Setup.BootstrapperBase.MainCore[T](String[ ] args) at Microsoft.Exchange.Bootstrapper.Setup.Setup.Main(String args) There is a simple reason for the the System.UnauthorizedAccessException: .NET Framework Optimization Service The required .NET Framework 4.6.2 had been installed just minutes before executing setup.exe. Preparation of the Active Directory schema ran without any issues. But when the /PrepareSchema call finished, the temporary folder in C:\Windows\Temp\ExchangeSetup could not be fully cleaned up, as mscorsvw.exe had an open file handle on ExSetup.exe. Additionally, when you run Setup.exe and the folder C:\Windows\Temp\ExchangeSetup exists, the setup will not try to copy required installation files. Regardless if the folder files exists in the folder or not. Solution End both mscorsw.exe processes or wait until both process ...
Scheduled Maintenance at Ignite 2017
At Microsoft Ignite, the major IT conference regarding Microsoft technologies, you will have a chance to award yourself with a scheduled maintenance sponsored by ENow. Have you ever been to one of the legendary Scheduled Maintenance parties in the past? No? Then get your pass now. Where: 180 Skytop Lounge - Orlando, FL https://www.180downtown.com/ When: Wednesday September 27, 2017 from 9pm to 12am Vist the Scheduled Maintenance web site to request your pass now.
Delete users from NoSpamProxy database script
Description This script deletes user from the NoSpamProxy NoSpamProxyAddressSynchronization database table [Usermanagement].[User] table that have not been removed by the NoSpamProxy Active Directory synchronization job. The script was developed due to a process flaw in how Active Directory accounts are handled as part of a leaver process. So this script does not fix a software bug, but a process glitch. Due to the Active Directory account process the accounts still exist in Active Directory and are synchronized to the NoSpamProxyAddressSynchronization database. When executed without the -Delete parameter all identified users are wirtten the log file only. Requirements Windows Server 2012 R2 or Windows Server 2016 Utilites GlobalFunction library found here http://scripts.granikos.eu or https://www.powershellgallery.com/packages/GlobalFunctions NopamProxy PowerShell module, script requires to run on a server having NoSpamProxy installed ActiveDirectory PowerShell Module (Install-WindowsFeature RSAT-AD-PowerShell) Examples # EXAMPLE 1 # Check for Active Directory existance of all users stored in NoSpamProxy database. Do NOT delete any users from the database. .\Remove-NspUsers.ps1 # EXAMPLE 2 # Delete users from NoSpamProxy database hosted on SQL instance MYNSPSERVER\SQLEXPRESS that do NOT exist in Active Directory. .\Remove-NspUsers.ps1 -Delete -SqlServerInstance MYNSPSERVER\SQLEXPRESS Version History 1.0, Initial community release Links Download and follow at Github: https://github.com/Apoc70/Remove-NspUsers Download ...
ESE Blog - Modern Attachments with OneDrive for Business
My guest post about Modern Attachments with OneDrive for Business was published in the ENow Exchange & Office 365 Solutions Engine Blog (ESE) yesterday. Enjoy reading here: http://blog.enowsoftware.com/solutions-engine/modern-attachments-with-onedrive-for-business
Get your Exchange Server Hybrid Key
This is a quick post on how to obtain the license key for your on-premises Exchange Hybrid Server. Even though that there is no such role like a Hybrid Server, you cann get a dedicated license key to license your Exchange server used for Office 365 hybrid connectivity. While using your Office 365 Global Administrator login, you can access your hybrid product key using the follow link: http://aka.ms/hybridkey The web site will check if your Office 365 tenant is eligible for an hybrid key first. Then you have to select the approriate Exchange Server version. Links Exchange Server Hybrid Deployments, https://technet.microsoft.com/en-us/library/jj200581(v=exchg.150).aspx Exchange Hybrid Key, http://aka.ms/hybridkey Enjoy your Exchange hybrid setup wth Office 365.
Create a Twitter Bot using Azure Automation
This blog post is about creating an Twitter Bot to tweet messages using Azure Automation. The steps and the script itself are based on Trevor Sullivan's TechNet Gallery post. His post assumes that you are familiar with some Azure Automation steps. So I am going to describe the required steps in more detail. Requirements You'll need the following components to setup your personal Twitter Bot. Local install of the PoshTwit PowerShell module A Twitter account An Azure subscription Trevor Sullivan's PowerShell Twitter Bot script or an updated version which is available here. Step 1: Create a Twitter Application First you'll need to create a Twitter application to reference your Azure Automation bot. The authentication information of your Twitter application will be needed in step 2. The information required are ConsumerKey ConsumerSecret AccessToken AccessSecret (AccessTokenSecret) You need to create a new Twitter application by accesssing the following link: https://apps.twitter.com/ Ensure that you've added your mobile phone number to your Twitter account before creating a new Twitter application. This is a requirement for creating Twitter applications. Log on to Twitter using the Twitter account you want your Twitter Bot to post ...
Create a new Room Mailbox with Security Groups
Description This scripts creates a new room mailbox and security two groups for full mailbox access and and for send-as delegation. The security groups are created using a configurable naming convention. If required by your Active Directory team, you can add group prefixes or department abbreviations as well. The script uses a Xml configuration file to simplify changes for variables unique for your environment. High level steps executes by the script: Create a new room mailbox Create a new mail enabled security group for full access delegation Assign full access security group for full access to the room mailbox Create a new mail enabled security group for send-as delegation Assign send-as permissions to send-as security group Set calendar processing to AutoAccept, if required Set resource capacity, if rewuired Examples Xml settings file <?xml version="1.0"?> <Settings> <GroupSettings> <Prefix>pre_</Prefix> <SendAsSuffix>_SA</SendAsSuffix> <FullAccessSuffix>_FA</FullAccessSuffix> <CalendarBookingSuffix>_CB</CalendarBookingSuffix> <TargetOU>mcsmemail.de/IT/Groups/Mail/Rooms</TargetOU> <Domain>mcsmemail.de</Domain> <Seperator>-</Seperator> </GroupSettings> <AccountSettings> <TargetOU>mcsmemail.de/IT/Mail/RoomMailboxes</TargetOU> </AccountSettings> <GeneralSettings> <Sleep>10</Sleep> </GeneralSettings> </Settings> Note The calendar booking security group feature is currently not available. But will be available in an upcoming release. The following example creates a room mailbox for an Conference Room with empty security groups. .\New-RoomMailbox.ps1 -RoomMailboxName "MB - Conference Room" -RoomMailboxDisplayName "Board Conference Room" -RoomMailboxAlias "MB-ConferenceRoom" -RoomMailboxSmtpAddress ...
Enabling Kerberos Authentication Fails with Exchange Server
There are quite a lot of good step-by-step manuals available describing how to enable Kerberos authentication for Exchange Server 2013/2016. The following issue has been seen in an Exchange 2013 infrastructure (8 server DAG) where Outlook clients use OutlookAnyhwere to connect to Exchange Server. MAPI over Http is disabled on an organizational level due to a compatibility issue with another client software. Problem Even if you follow the detailed descriptions you might end up in a situation where your Outlook clients still won't connect to Exchange Server using Kerberos. The Outlook connection status overview (Ctrl + Right Click on the Outlook icon in System Tray) still shows Ntlm as the used authentication provider: Reason You are supposed to use the following PowerShell cmdlets to configure OutlookAnywhere to use Kerberos: Get-OutlookAnywhere -Server CASSERVER | Set-OutlookAnywhere -InternalClientAuthenticationMethod Negotiate All eight Exchange 2013 servers where still not offering Nego as an authentication provider even after some period of time. Verifying the OutlookAnywhere configurations using PowerShell showed the correct configuration values. So what to do? A quick check at the IIS authentication settings of the \Rpc virtual directory of the Front End web site (Default ...
Read More »
We are using Cookies!
Cookies help us to deliver our Solutions. Through using of this Web-Site you agree that we set Cookies.