Under SQL 2005, when I try to get list of Salesforce objects I get error: "Object reference not set to an instance of an object."

Under SQL 2005, when I try to get list of Salesforce objects I get error: "Object reference not set to an instance of an object."

Make sure you have at least SP2 installed. To determine current version open SSMS and enter the following query: select @@version

The reported version should be 9.00.3042.00 or above.