Today I installed SP2 for Visual Studio 2013 and can now use SQL Server Tools in VS to create SqlServer 2014 database objects. Once this was installed, the server name on both the Visual Studio 2013 and Sql Server Management Studio 2014 connection dialog
was changed to (localdb)\ProjectsV12 and this solved the problems I was having between the two programs.
Now I am trying to connect to the SQL Server database from Excel 2013 using the Database Connection Wizard. After selecting Get External Data and From SQL Server, I entered (localdb)\ProjectsV12 for the "Server
Name" and checked "Use Windows Authentication". This produces the error "SQL Server does not exist or access denied."
Is there another "server name" I should use?
Go to the complete details ...