CODEWITHSUNDEEP
c#sql-serverdatabasevisual-studio-2010
user3786234
user3786234

Reputation: 115

Visual Studio not showing server name when adding connection

I'm using Visual Studio 2010 and SQL Server 2012. When I try to connect to SQL Server through Visual Studio, I don't get my server name on Add connection drop down menu.

Upvotes: 7

Views: 30818

Answers (5)

Moataz Alsayed
Moataz Alsayed

Reputation: 381

For people using sql server 2014+ and using the local db on your pc. simply set the server name to be (localdb)\ name of your database. It worked for me.

Upvotes: 0

Divyansh
Divyansh

Reputation: 79

run services.msc find " SQL server browser " , it might be disabled , start that service and set it to automatic.

Upvotes: 5

Jsperk
Jsperk

Reputation: 148

Insert machine_name/SqlServerName

Upvotes: 1

mybirthname
mybirthname

Reputation: 18127

Go to SQL Server Management Studio to look for the correct Server Name and copy the value. Make all the configurations by yourself at the end just click Test connection button. If the connection is test successfully proceed with your work.

Upvotes: 24

Venkataraghavan Yanamandram
Venkataraghavan Yanamandram

Reputation: 431

If the database is in your local machine, Just put a . (Dot) in Server Name and select the database.

Add connection dialogue

Upvotes: 15

Related Questions