Oct 14, 2010 at 9:21 AM
Edited Oct 14, 2010 at 9:31 AM
I have a problem with my database server configuration so that I cannot create the Entity Data Model.
I'm using MS Visual Studio 2010 and MS SQL Server 2008 with default instance name MSSQLSERVER.
When I tried to open MvcMusicStore.mdf using Server Explorer window, I got Server Explorer Error...
"A network-related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 25 - Connection string is not valid)."
And here is the entity connection string:
metadata=res://*/Models.StoreDB.csdl|res://*/Models.StoreDB.ssdl|res://*/Models.StoreDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\MSSQLSERVER;AttachDbFilename=|DataDirectory|\MvcMusicStore.mdf;Integrated Security=True;User
I checked SQL Server Instance Name on Tools > Options > Database Tools > Data Connections and I found it correct (MSSQLSERVER).
Thank you for your information. I'm really appreciate it.