Power BI Tutor

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    

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 Browser. 4.Delete