Connection problems for local server
I am having trouble setting up an existing site locally on my box in order to do maintenance and debugging. I want the site and the datase to be local on my machine.
I am getting the following error...
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is my connection string...
<add name="RIIDBudget" connectionString="Data Source=AMEDRIIDNBF5476;Initial Catalog=RIIDBudgetDB;Integrated Security=True" providerName="System.Data.SqlClient"/>
I am using SQL Server 2000. In the Interprise Manager I have the following...
Console Root
-- Microsoft SQL Servers
-- SQL Server Group
-- AMEDRIIDNBF5476\DBM2000
-- Databases
-- RIIDBudgetDB
Any ideas o what I am oing wrong?
Thanks,
Scott

