06/14/13
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.
Tags: error: 0x5, status code 0x1
04/11/13
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: SQL 2008 location: SQL 2012 location:
03/20/13
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
02/18/13
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 02/01/13
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.
|
|