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.
相关问题
- Sorting 3 numbers without branching [closed]
- sql execution latency when assign to a variable
- Graphics.DrawImage() - Throws out of memory except
- Why am I getting UnauthorizedAccessException on th
- 求获取指定qq 资料的方法
If the database is in your local machine, Just put a . (Dot) in Server Name and select the database.
Insert machine_name/SqlServerName
run services.msc find " SQL server browser " , it might be disabled , start that service and set it to automatic.
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.
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 clickTest connection
button. If the connection is test successfully proceed with your work.