Okay so I am completely new to creating a database, and have been trying to create one in Visual Studio 2010
I found this guide on the web and have been following it pretty successfully till I came to spot that I can't get past
(here's the link - http://msdn.microsoft.com/en-us/library/dd193408.aspx)
Anyway I went to properties of my SQL Server 2008 Database Project that I titled "SQLClrDatabaseSandbox" (I am following the guide so I just named it like the guide said), and went to the Deploy tab.
After going to the Deploy tab I needed to fill in data for the "Target Connection:" field and this is where my problem lies.
I open this field to get the following dialog
But upon opening it, I have no clue what to enter into the Server name field.
I tried the name of my server "MYSQLTESTSERVER1" which is running, has TCP/IP enabled like all these guides have said (I had to manually enter the name because no data would appear on it's own in the drop down menu)
But the thing is when I tried testing the connection I get an error saying "provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server".
I know the server is running, my SQL Server Manager Studio says so
Btw if someone could tell me how to keep this server local to my machine only that would be greatly appreciated. I am only needing to connect to the database locally for a project I am working on (and have no desire to make it anything more at the moment)
Thnaks in advance for help, I know this may seem confusing, but now you know how I feel