Server TCP provider failed to listen on [IP Address]. Tcp port is already in use.

Consider the following scenario: You try to start the SQL Server service at a cluster node or at a standalone machine, after the SQL Server service was stopped. The service fails to start and you see these messages or similar ones logged in the ERRORLOG: Server TCP provider failed to listen on [IP Address]. Tcp…

0

Is it safe or supported to remove the local security groups that the SQL Server setup creates (SQLServer2005MSSQLUser$<computer name>$MSSQLSERVER) ?

When the SQL Server setup is ran, it creates some local groups of the following format: SQLServer2005MSSQLUser$<computer name>$MSSQLSERVER These groups are part of the product and should not be deleted: – Reviewing Windows NT Rights and Privileges Granted for SQL Server Service Accounts Deleting them renders the product unsupported and part of the functionality is…

1

Does the CRM database and application support the SNAPSHOT isolation level?

This is a very interesting question that for some reason has not been documented in the Official CRM documentation.   To give a short reply: YES, IT IS SUPPORTED   The longer reply is: The default isolation level of a SQL Server database is READ COMMITTED: SQL Server Customer Advisory Team Blog – Concurrency Series:…

0

Script to export the configuration of SQL Server

Recently I was asked to write a script that would export (or backup) as much configuration information from a SQL Server instance as possible. This is handy when migrating a SQL Server instance to a new environment and serves as a checklist.   The result was the following script, that exports: – The instance name of…

4

The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.

This time I came across a certificate error, that was stopping the SQL Server service from starting: The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.Error: 26014, Severity: 16, State: 1.Unable to load user-specified certificate The…

5

How to install a Service Pack at a SQL Server 2012 Failover Instance – Best Practices

Best practices for updating a SQL Server 2012 Failover Instance   Part 1 – Preparing for the installation Preparing for the Service Pack installation is the most important part. Skipping one or more of the preparations steps imposes a risk and is not a recommended action.   –  Testing before deployment:  Service packs and hotfixes…

2

How to troubleshoot Scheduled Tasks that fail to run

Frequently a Scheduled Task fails to execute and you need to identify why it stopped working. Or it may have never worked correctly and now is the time to fix it! 🙂 The first thing I do is check the Events in the History Tab. Both the Successful and Failed runs of this Task will…

0

The OpenSSL "Heartbleed" vulnerability and SQL Server

I just wanted to share with everyone that SQL Server is unaffected by the OpenSSL “Heartbleed” vulnerability: Microsoft Services unaffected by OpenSSL “Heartbleed” vulnerability It is unlikely that this vulnerability would affect SQL Server itself, because neither Windows or SQL Server use the OpenSSL software. If there are any updates regarding this vulnerability, they will…

1