Visual Studio not showing server name when adding

2020-07-13 11:50发布

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.

5条回答
不美不萌又怎样
2楼-- · 2020-07-13 12:05

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

Add connection dialogue

查看更多
smile是对你的礼貌
3楼-- · 2020-07-13 12:07

Insert machine_name/SqlServerName

查看更多
聊天终结者
4楼-- · 2020-07-13 12:15

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

查看更多
手持菜刀,她持情操
5楼-- · 2020-07-13 12:19

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.

查看更多
疯言疯语
6楼-- · 2020-07-13 12:23

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.

查看更多
登录 后发表回答