Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Server name not displayed in visual studio server explorer

Tags:

sql

visual-studio-2013

server-explorer

server-name

Any ideea why my local sever is not displaed in the drop down list where u select the server name?

enter image description here Thx!

like image 511
TBogdan Avatar asked Jan 17 '15 23:01

TBogdan

People also ask

How do I find my Visual Studio server name?

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.

How do I find the SQL Server Name in Visual Studio?

Open up SQL Server Configuration Manager (search for it in the Start menu). Click on SQL Server Services . The instance name of SQL Server is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it's the default instance.

How do I add a server to Visual Studio?

Add a connection in Server Explorer To create a connection to the database, click the Add Connection icon in Server Explorer, or right-click in Server Explorer on the Data Connections node and select Add Connection.

1 Answers

Maybe your Sql Server Browser service stopped.

Here is the solution.

  1. Open the Run dialog (WinKey + R)
  2. Type: "services.msc"
  3. Select SQL Server Browser
  4. Click Properties
  5. Change "disabled" to either "Manual" or "Automatic"
  6. When the "Start" service button gets enable, click on it.

Done. Now you can select server name from server name drop down list.

like image 199
Kishor Naik Avatar answered Sep 29 '22 19:09

Kishor Naik
Sign in to Comment

Related questions

check for point in a polygon
Truncate nvarchar(max) to nvarchar(n) with ellipses
Update row with check by linq2db in one atomic operation
Extracting a string using SQL PATINDEX, substring of varying sizes
Get Current Unix Epoch Time-stamp in seconds in SQL Server
Get first and last date time from each date in query SQL Server
Wrong PostgreSQL query results with explicit locks and concurrent transaction
T-SQL Unique Identity Column as Part of Composite Primary Key
Difference between cross product (cross join, Cartesian product) and natural join
How to change the date format when the file is spooled in oracle
Limit a LEFT JOIN Subquery to 1 result
How to execute sql query files via RPostgreSQL
Use SQL keyword as alias name of a column
How to create a indexed view with tables from 2 different databases using Schemabinding
Combining results before grouping in SQL
h2 VIEW has problems with correct SELECT statement
I need to optimize my first T-SQL update trigger
Horizontal to vertical display using Dynamic Pivot Function
SQL Server : drop column @variable not working
Composite primary key

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!