(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

The scenario: You try to connect to Sql Server but you are getting the following connection error (they vary depending on the provider used):   Using the .Net SqlClient provider: ———————————————————————————————————————————————————— System.Data.SqlClient.SqlException: 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…

1

The importance of selecting the correct Sql provider for the job. Sqlncli vs. Sqlncli10

Imagine this; you have been looking at the new data type DateTime2 in Sql Server 2008 because you have a need for the increased precision this data type offers.   Comparison here: “SQL Server 2008 Books Online (October 2008) – datetime2 (Transact-SQL)”   http://msdn.microsoft.com/en-us/library/bb677335.aspx “SQL Server 2008 Books Online (October 2008) – datetime (Transact-SQL)”  …

1