Compare Microsoft SQL Server versions
Feature availability Not supported Fully supported `
Posts
Unable to cast COM object of type 'System.__ComObject' to interface
TITLE: Microsoft Visual Studio ------------------------------ Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{203E24BD-5203-4C76-AFC7-7C8545EBA1A0}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)). ------------------------------ BUTTONS: OK ------------------------------ Solution: 1. Before starting, make sure you close any open Visual Studio instance. 2. Open command prompt and run as a administrator. 3. Navigate to bellow path C:\Program Files\Microsoft SQL Server\ 120 \DTS\Binn\ where 120 is you SQL Server version number. 4. Reregister the dts.dll by executing the command: regsvr32 dts.dll
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: 2)
TITLE: Microsoft Visual Studio ------------------------------ Failed to connect to server . ------------------------------ ADDITIONAL INFORMATION: 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 connection to SQL Server) (Microsoft SQL Server, Error: 2) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476 ------------------------------ The system cannot find the file specified ------------------------------ BUTTONS: OK ------------------------------ Solution: 1.Check for working fine SQL Server Services running or not. 2.Also check for working in good condition SQL Server (MSSQLSERVER). 3.Also check for working fine SQL Server B
Sql cmd commands
1. You can check all the sqlcmd commands using this command: Sqlcmd -? 2. check sql server instance is running or not sc query mssql$instancename 3. check sql server browser is running or not sc query mssqlbrowser
