How do I find what is the named instance of my SQL Server 2012 Express instance
22:04 22 Sep 2012

Using SSMS to validate my ServerName\instance ... I can only get it to connect with the dot . (or computerName). I thought the default instance was .\SQLEXPRESS ... but this does not work.

It seems Visual Studio 2012 also expects (.\SQLEXPRESS) .... changing my web.config file to reflect the data source as DATA SOURCE= .; fixes nothing....VS 2012 cannot find my SQL Server 2012 Express when trying to add a database item. All my attempts have failed.

I tried to post image but it fussed at me because I am a new user.... but here is the Visual Studio Error Message I received when I attempt to add a database:

Network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was accessible. Verify that the instance name is correct and that SQL Server is configured to allowed remote connections. (provider: SQL Network Interfaces, error: 50 -Local database runtime error occurred. Cannot create an automatic instance. See the Windows App event log for error details

Windows App Event Log:

Cannot access LocalDB instance folder: %%LOCALAPPDATA%%\Microsoft\Microsoft SQL Server Local DB\Instances\.

(examining the above path.. shows only an instances folder and a projects sub-folder. The project folder contains many files including master db)

How to I sync of my SQL Server 2012 Express installation with VS 2012??

asp.net sql-server-2012-express