Always use SQL-Alias in your SharePoint farm

Published on Thursday, 2 January 2020

Not every farm is set up using SQL-Alias. It's not clear to me why this is so. Always. Use. SQL-Alias.

I've heard excuses like: "That's much more work". Yea. Like 5 clicks for each server. Granted.

But that got me thinking on how to automate the creation of SQL-Alias in a farm. I started out by wanting to utilize (Get-SPFarm).Servers. However, the farm is only accessible after is is set up. That would be too late.

Therefore I created a script to set a SQL-Alias for a list of servers:

Consequently I also created a script to list the existing SQL-Alises: