CODEWITHSUNDEEP
sql-serversql-server-2012ssms
chamathabeysinghe
chamathabeysinghe

Reputation: 868

SQL Server Managemet Studio not finding local server

Here I think my local machine should be shown. But it is not shown. So I can't connect to it. What is the solution for this?

enter image description here

Upvotes: 4

Views: 32165

Answers (2)

marc_s
marc_s

Reputation: 755421

Go to Start Menu > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager and see that your SQL Server service is installed, up and running and what it's name is:

enter image description here

  • if you don't find any entry under "SQL Server Services" that looks like SQL Server (instancename), then you don't have SQL Server (the engine, the core) installed

  • if you find a value of SQL Server (MSSQLSERVER) in your list and it's in State = Running, you should be able to connect to it using ., (local), or your-machine-name as the server/instance name

  • if you find any other value (like SQL Server (SQLEXPRESS) in my example), then you have a named instance and you can connect to it using .\instance-name, (local)\instance-name - e.g. .\SQLEXPRESS or (local)\SQLEXPRESS in this case

Upvotes: 6

Shahul Hameed
Shahul Hameed

Reputation: 1

On Browse for servers window.Click on the Network Server.You can find your Local server.

I think this should work.

Upvotes: -2

Related Questions