Having trouble getting through to a local SQL Server using the SQLOLEDB provider? I sure did. I’m trying to get a base VPC setup with some Microsoft server products which need access to a local SQL Server. The obvious answer is to use (local) or . to get at the local SQL Server and not have to worry about changes in the machine name. This, however, turns out not to work with the default settings of SQL Server 2005.
You basically have to enable TCP/IP using SQL Server Configuration Manager for it to work. I little gotcha for ya
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in any way.