<add name="SQL Server" providerName="System.Data.SqlClient"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Databases\MyData.mdf;Integrated Security=True;User Instance=True" />
i have visual studio 2005 pro and sql server 2005 pro.
i got an 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: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)"
what will i need to change in the connection string?