Remote SQL Server with a Named Instance

Remote SQL Server with a Named Instance

As Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) administrator we wear many hats. One of those hats is SQL Server administration. We use SQL for several components within ConfigMgr including ConfigMgr, WSUS and SQL Server Reporting...
Remote SQL Server with a Non-Default Port

Remote SQL Server with a Non-Default Port

Sometimes people want to make life difficult for themselves. SQL deployments in a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) environment come to mind. In one such example, deploying a remote SQL installation with a default instance name...