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...
“Invalid object name” in SSMS

“Invalid object name” in SSMS

As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) administrator We are not always well verse with SQL Server and its errors. Particularly within SQL Server Management Studio (SSMS). In this Article and video, we will show you how to...