0

I am trying to execute SQL query on a local databse that I created inside visual studio (service based database option). However when I click "Execute" I get the "Connect to Server" message and it asks for server name.

I have no idea what to enter, I tried SQLEXPRESS, my computer name, localhost. none of these work!! Please help this is so frustrating to do a basic thing...

Seymour
  • 7,043
  • 12
  • 44
  • 51
Chebz
  • 1,375
  • 3
  • 14
  • 27
  • What about the server instance? SQL Servers are now come with an option to install multiple instances. Your localhost may have this configuration. Open SSIS and check what you have – cha Nov 21 '13 at 01:03
  • how do I open SSIS? I am not sure what it is sorry. – Chebz Nov 21 '13 at 03:48
  • I think you need to change "Data Source" to Microsoft SQL Server Database file. When you do so, you will need to navigate to your SQLEXPRESS file you have created – cha Nov 21 '13 at 04:38

1 Answers1

0

Ok I figured it out. Once I restarted VS, a new server appeared under the servers tab. It's actually called "(localdb)\Projects"

Once I specified that into server name, everything connected fine.

Chebz
  • 1,375
  • 3
  • 14
  • 27