Problem

After a Sql Server restart, the service failed to start giving the following error messages:

Error: 26049, Severity: 16, State: 1.

Server local connection provider failed to listen on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. Error: 0x5

Error: 17182, Severity: 16, State: 1.

TDSSNIClient initialization failed with error 0x5, status code 0x40. Reason: Unable to initialize the Shared Memory listener. Access is denied.

Error: 17182, Severity: 16, State: 1.

TDSSNIClient initialization failed with error 0x5, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Access is denied.

Error: 17826, Severity: 18, State: 3.

Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

Error: 17120, Severity: 16, State: 1.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Solution

When the SQL Server starts it tries to open listening named-pipes to accept client share memory or named-pipe connections. If the listening named-pipes are not closed properly during the last shutdown of SQL Server (maybe after a forced kill of the SQL Server process), there will be orphan named-pipe handles in the windows kernel file system.

To solve this issue, a quick solution will be to reboot the machine hosting the SQL Server.

Problem

When trying to browse the SSIS packages from Management Studio the following error can apear:

The SQL Server specified in Integration Services service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in SQL Server 2008 Books Online.

Solution

This error appears when you have only named SQL instances on the machine, or when the default instance runs on a different port than the default one (1433).

To fix this edit the MsDtsSrvr.ini.xml file:

SQL 2005 location:
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

SQL 2008 location:
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml

SQL 2012 location:
C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.ini.xml

Full story »

Problem

 When trying to process a database cube the following error is received:

 Internal error: An unexpected exception occured.

After the restart of the SSAS service the event view shows the following error:

The file '\\?\X:\...\Data\master.vmp' could not be deleted. Please check the file for permissions.

Solution

Note that even if the SSAS Service is up and running when trying to execute some operation, even if they complete successfully, no modification are actually done. For example after restoring a cube database from a backup, although the operation completes successfully, the new database doesn?t appear in the Management Studio list.

The ?master.vmp could not be deleted? error message can appear sometimes if you just moved the SSAS databases from one location to another on the same server.

In this situation the solution is to grant rights "Modify" on this new data folder to the service account used to start the SSAS service. More information about this scenario you can find in this article: http://blogs.technet.com/b/mdegre/archive/2012/10/03/moving-ssas-database-to-a-new-drive-on-same-server.aspx

If previous suggestion didn?t solved the issue you can try to find out if there is another process that is locking the master.vmp file. To do this you can use the Process Explorer tool, which can be found here: http://www.microsoftnow.com/2008/10/unlocking-files-that-are-in-use.html

Full story »

Problem

When trying to connect locally to a SSAS 2005 or 2008 instance, the following error can appear:

Cannot connect to ServerName\InstanceName.

A connection cannot be made. Ensure that the server is running.

(Microsoft.AnalysisServices.AdomdClient)

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

An existing connection was forcibly closed by the remote host (System)

Note that the connection to that specific SSAS instance can be established from SQL Server Management Studio remotely.

Solution

You can connect locally to the SSAS instance by using in SSMS instead of SERVER_NAME\Instance the following: local, . , ./Instance , SERVER_IP

Full story »

Problem

When trying to select data from a view through a linked server the following error can appear:

SELECT *  FROM [SERVER_NAME].DATABASE_NAME.DBO.VIEW_NAME

OLE DB provider "SQLNCLI" for linked server "SERVER_NAME" returned message "Binding information is invalid.".

Msg 7346, Level 16, State 2, Line 1

Cannot get the data of the row from the OLE DB provider "SQLNCLI" for linked server " SERVER_NAME".

Tested with other views / tables, the linked server turns out to work fine so the problem is in particular with that view.

Solution

As a workaround you can select data from that view using OPENQUERY, and it works. 

SELECT * FROM OPENQUERY([SERVER_NAME], 'SELECT *  FROM DATABASE_NAME.DBO.VIEW_NAME')

The problem seems to be related to this particular view definition (wrong data type used, etc).

After recreating the view the select through linked server worked fine.