Error installing WSUS using a remote SQL and non-standard SQL port

Ran into this error earlier today while trying to install WSUS using a remote SQL 2014 SP2 server with non-standard SQL ports. 2016-11-22 20:30:13  Stopping service WSUSService 2016-11-22 20:30:13  Stopping service W3SVC 2016-11-22 20:30:13  Configuring database... 2016-11-22 20:30:13  Configuring the database... 2016-11-22 20:30:13  Establishing DB connection... 2016-11-22 20:31:14  System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a [...]

By | 2017-08-22T10:29:40+00:00 November 22nd, 2016|Configuration Manager (SCCM), SQL|0 Comments

VIP Users Part 2 or how to synchronize group membership from AD to SCSM

Dealing with VIP users is a common practice within Service Management. This old blogpost explains a very good approach to mark VIP users in SCSM as VIP users. We simply extend the User class with an extra boolean property (true/false) and we then expose that property on the Incident right under the Affected User. That way Analysts can quickly see if the person is VIP and you can also make various workflows or notifications based on this property.   What is missing in the above post is how we figure out who is VIP or not. For many, this relationship [...]

By | 2017-08-30T11:48:15+00:00 November 15th, 2016|Automation, Powershell, Service Manager (SCSM)|2 Comments

Ready to Upgrade to SCOM 2016?

  Weehau - we got the new version of SCOM – and many companies are already thinking about the upgrade, when how and why? – First the last – A couple of new features are available like: Maintenance from the SCOM Agent Scheduled Maintenance Mode Agent for Nano Server New Agent for Linus/UNIX – Faster more robust and able to run shell scripts by itself LAMP Stack monitoring on Linux Good performance in mornitoring Network Devices Storage Spaces monitoring by Microsoft Native MP MP Tuning, Updates and Recommended MP in the Console A MP for AWS which are able to [...]

By | 2016-11-03T09:16:15+00:00 November 3rd, 2016|Operations Manager (SCOM)|1 Comment