On-Premises Gateway

We are living in a digital transformation to O365, but by the time we are doing this, our customers still need to connect their On-Premises data like SharePoint or SQL to Office 365 applications (PowerApps, Microsoft Flow, Logic Apps, Power BI).

For that reason, Microsoft has introduced on-premises data gateway for providing a quick and secure connection between on premise data and Office 365 apps.

We must keep in mind that there are two different types of gateways, one of them is On-Premises and the other gateway, is the personal gateway, which only allows to connect to PowerBI and can be used as an individual without any administrator configuration.

In the following image, we can see the differences between the personal gateway and the On-Premises gateway:

Moreover, the current supported On-Premises applications are SharePoint 2016 and SQL 2016, as you can see in the diagram below, there are multiple O365 connections to On-Premises services:

The installation process is straightforward, and only is needed a server with the following requirement to use the gateway:

Hardware Requirements:

Hardware Requirements	Value
CPU	8 Cores
RAM	8 GB

Software Requirements:

Software Requirements	Value
.NET Framework	Version – 4.5
Operating System	Windows 7 / Windows Server 2008 R2, or later

If you require more info about the gateway, you can follow the links:

https://flow.microsoft.com/es-es/blog/on-premises-data-gateway/

https://powerbi.microsoft.com/es-es/documentation/powerbi-gateway-onprem/

https://docs.microsoft.com/es-es/azure/analysis-services/analysis-services-gateway

Advertisement

Yammer Desktop App is here

Recently, Microsoft has launched the Yammer desktop application. Users can install the app from the Yammer web application, through the Office 365 portal or can distribute the app to users via SCCM using the MSI available.

You will need to meet the following requirements to use the app:

– Windows 7 or later

– Mac OS 10.9 or later

– an active Yammer account using O365 identity

As yo can see in the follow screen, the app is very likely than the web access:

If you need more information about this new app, visit the following link: https://support.office.com/en-us/article/Yammer-for-Windows-and-Mac-50920c05-cbfc-4f11-8503-e20fb2e623a5

Set Item level user permissions to add/edit/read only own items

In a recent project with SharePoint 2016, I needed to configure a library with the following user requirement: The users only have to view, their own items.

By default, this option it is not available in Library settings, it is only available for List settings, so… what we can do for a Library? You guessed right, PowerShell.

To do it, we can follow the following process:

You can also use s PowerShell script to manage the item level permissions:

Manage Read Access
$web = Get-SPWeb http://urlsite/
$list = $web.Lists[“Library Name”]
$list.ReadSecurity = 2
$list.Update()
$web.Dispose()

Note: 1 = “Read all items”, 2 = “Read items that were created by the user”

Manage Write Access
$web = Get-SPWeb http://url site/
$list = $web.Lists[“Library Name”]
$list.WriteSecurity = 2
$list.Update()
$web.Dispose()

Note: 1 = “Create and edit All items”, 2 = “Create items and edit items that were created by the user” 4 = “None”

Hope that helps!

How to troubleshoot Microsoft Teams

Many clients are adopting Microsoft Teams as the central tool for productivity and collaboration, it is great to see an application that unifies functionalities like video, call and the collaboration tools from SharePoint as well as the integration with other applications or even third party applications.

But, what happens when the Microsoft Teams application fails? Where we can troubleshoot what is happening?

It is true that we can navigate to the Tech Community to try to research for some information, but its not the best, so how we can obtain more information?

By using the magic key combination: Ctrl – Shift – Alt – 1

We will be able to download a log file:

Where we will see pieces of JSON formatted text and the most interesting part, lines that have time stamp and message level and of course, an error message.

Also, we have the leves categorized as:

 

• War : Warning
• Err: Error
• Inf: Information

So, doing this we will be able to troubleshoot Microsoft Teams, and at least obtain a clue of what the hell is happening with the app.

Hope that helps!

SharePoint Online Save As Template Access denied

While I was configuring a SPO tenant, i received an error when I tried to navigate to the url “_layouts/savetmpl.aspx” I receveid the error “You don’t have permissions to access to this site”. So what can we do?

Following the post https://albandrodsmemory.wordpress.com/2016/06/06/master-page-gallery-access-denied/ you will need to use PowerShell to solve this problem.

First, open the SharePoint Powershell and type the following:

Connect-Sposervice -url “https://tenant-admin.sharepoint.com”

Set-sposite “https://tenant.sharepoint.com/sites/url” -denyaddandcustomizepages 0

Once this has been executed, you will be able to save the site as a template

Skype For Business Web Scheduler

Recently I’d been involved in a O365 project where the client need to use Skype for Business Online, but they have the mail in other platform which is not Exchange Online (I hope they will migrate in a near future). So, the question is: How can they schedule meetings for Skype for Business?

As well as MS has a solution to Schedule meetings in OnPremises, for Skype Online we have a similar solution, which is “Skype for Business Web Scheduler”, very original, isn’t it?

This solution is a web-based program that you can use to create Skype Meetings, in case you don’t have Outlook. The only thing you need is an Internet connection (we are in O365, bravo captain obvius!)

So, we’ll need to navigate to https://sched.lync.com sign in with your work account, and the scheduler will be presented. For people that has been using Skype Scheduler with Outlook, will be very similar to it.

If you have any doubts or need support about this tool, check the following link

Hope that helps!

Open and closed terms in Managed Metadata

As you will know, term sets allow users to create collections of terms, which it can be reuse to associate content. In this case, usually, the SPO admin or the site owner prepopulate the Term set for all the users. But what happen when we have created a term set and we want to allow the users to add their own values into an specific term set?

In one hand, we can talk about open and closed term sets, by default, term sets are closed, so the term manager, must create the term and users will need to use them. There is no possibility to add new terms

On the other hand, we have open term sets, in this case we allow users to add their own values to the term set from input forms, it’s like to say: Ok, I’m allowing to create new terms on the fly

This option is quite great, but you have to be careful, because this option probably will not fit with your SharePoint governance strategy…

 

Disconnect inactive RDP sessions

While I’m working in a project that needs to log in into a server I usually leave my user session opened (yes I know that it s not a good practice, but I always forget to log off).

So when an admin needs to connect to the server there are either no free sessions or probably the openend sessions are consuming resources that could be slowing down the server.

So as a power user, I discovered the following command to execute in PowerShell (remember to execute it as administrator) to try to list and free the unused sessions:

If you only want to see the sessions, you can execute only this:

query user | select -Skip 1 | ? {($_ -split “\s+”)[-4] -eq ‘Disc’}

To disconnect all these sessions at once, you can execute this command inside an elevated PowerShell window:

query user | select -Skip 1 | ? {($_ -split “\s+”)[-4] -eq ‘Disc’} | % {logoff ($_ -split “\s+”)[-5] /v}

And then all disconnected RDP sessions are forced logoff and the resources are free.

Till next time!

SharePoint 2016 Features Standard vs Enterprise Comparaison (filterable, colors)

Great post from Jeff about how to choose SharePoint 2016 license types based on the features of each license.

This is my old blog. Visit my new blog : www.collabmania.com

 

How to recommend a SharePoint license based on what the user want ?

This excel file could help to choose the license for SharePoint 2013 / 2016.

https://gallery.technet.microsoft.com/SharePoint-2016-Feature-ce033b50

Hope it helps,

View original post

How to connect to Windows Internal Database (WID) with SQL Server Management Studio

The Windows Internal Database (WID) is used by the following Windows server components:

• Windows Server Update Services (WSUS)
• Active Directory Federation Services (AD FS)
• Active Directory Rights Management Services (AD RMS)
• Windows System Resource Manager (WSRM)

For Windows Server 2008 R2 and Windows Server 2008, you can use the following named pipes (NP) string:

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

On Windows Server 2012, Windows Server 2012 R2 and Windows Server 2016 you must use a different np connection string:

\\.\pipe\MICROSOFT##WID\tsql\query