Problem connecting to ASPNETDB.MDF file
I cannot seem to connect to the ASPNETDB.MDF file provided with the chapters code. Even when I just try connecting to it directly from the Server Explorer in VS2005, I get an error. I click on new connection (under data connections), then i select "Microsoft SQL Server Database File", then I navigate to the file and select it. For the login I leave it as "Windows Authentication". Testing the connection I get the error:
"An error has occured 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)"
If anyone has any idea why I cant seem to be able to connect to the .MDF file please let me know. I do have SQL Server 2005 installed, its possible that the full version is interfering with my attempt to connect to the express edition file.
Any help is appreciated.