How to find server name of SQL Server Management Studio

by

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. To connect to it in Management Studio, just type . (dot) OR (local) and click Connect. If the instance name is different, then use .\[instance name] to connect to it (for example if the instance name is SQL2008, connect to .\SQL2008).

Also make sure SQL Server and SQL Server Browser services are running, otherwise you won’t be able to connect.

Edit:

Here’s a screenshot of how it looks like on my machine. In this case, I have two instances installed: SQLExpress and SQL2008.

enter image description here

More Related Contents:

  1. How to execute dtsx packages through command line
  2. UTF-8 without BOM
  3. IIS Express Windows Authentication
  4. How to connect to local instance of SQL Server 2008 Express
  5. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  6. Cannot import the keyfile ‘blah.pfx’ – error ‘The keyfile may be password protected’
  7. Targeting .NET Framework 4.5 via Visual Studio 2010
  8. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  9. SQL Server 2008: how do I grant privileges to a username?
  10. No IntelliSense for C++/CLI in Visual Studio 2010?
  11. Restrictions on installing extensions or add-ins in Visual Studio 2010 Express
  12. Unique constraint on multiple columns
  13. How do I create an COM visible class in C#?
  14. Setting up Visual Studio Intellisense for CUDA kernel calls
  15. Do I need the resx Designer.cs file?
  16. How can I use PowerShell with the Visual Studio Command Prompt?
  17. Installation of Visual Studio 2010 (any edition) installs only 2 files in the C++ headers directory
  18. Can’t run ASP.NET MVC 2 web app on IIS 7.5
  19. How to fix “Root element is missing.” when doing a Visual Studio (VS) Build?
  20. Can Web Deploy’s setAcl provider be used on a sub-directory?
  21. Using CustomParameter with Visual Studio Multi-Project Template
  22. Error while trying to run project: Unable to start program. Cannot find the file specified
  23. Error Code -1073741515 When Using EDITBIN
  24. Visual Studio does not let me drag drop items into it?
  25. What does the “Link Library Dependency” linker option actually do in Visual Studio 2010 – 2015 and upwards?
  26. Visual Studio Disabling Missing XML Comment Warning
  27. Restrict varchar() column to specific values?
  28. TFS Build not transforming web.config as expected
  29. Visual Studio 2010 related file nesting
  30. Setting up Point Cloud Library with Visual Studio

Leave a Comment