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?
Forum Topic
Viewing a single forum discussion topic.
← Back to Programming Errors And Help
SQL Server Managemet Studio not finding local server
Post a reply
2240 views
mayureshpandit282
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:
-
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
Last updated
1-2 of 2
Reply to this discussion
You cannot edit posts or make replies: You should be logged in before you can post.