Can't find my Localhost Database Engine for SQL Server

Click For Summary

Discussion Overview

The discussion revolves around troubleshooting issues related to locating the database engine for SQL Server after a reinstallation. Participants explore various methods and configurations that may affect connectivity to the local database engine.

Discussion Character

  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant suggests testing connectivity using the actual TCP/IP address or the loopback address 127.0.0.1.
  • Another participant recommends checking the SQL Server Configuration Manager to ensure the SQL Server Browser service is running and that the TCP/IP network protocol is enabled.
  • There is a mention of verifying the instance name of SQL Server and connecting using the format COMPUTERNAME\INSTANCENAME.
  • One participant advises looking into the Windows event log for any startup errors related to SQL Server.
  • A participant indicates they are uninstalling and reinstalling SQL Server as a potential solution.

Areas of Agreement / Disagreement

Participants present various troubleshooting steps and suggestions, but there is no consensus on a single solution to the problem. The discussion remains unresolved as participants explore different approaches.

Contextual Notes

Limitations include potential missing configurations, dependencies on specific SQL Server versions, and the need for further clarification on the installation process.

WWGD
Science Advisor
Homework Helper
Messages
7,802
Reaction score
13,106
Hi All,
I had to reinstall my SQL Server and I a having trouble finding the database engine which is the local host. Please see screenshots. Any ideas? Thanks.

upload_2018-2-16_17-28-10.png
 

Attachments

  • upload_2018-2-16_17-28-10.png
    upload_2018-2-16_17-28-10.png
    35.9 KB · Views: 1,141
Technology news on Phys.org
Did you try using the actual tcpip address of your host or the 127.0.0.1 to test that it works ?

Did you try searching on google to see if others had the same problem? It may well be a product issue.

Review your install confit stuff to see you have to place anything in the Microsoft Windows registry ?
 
  • Like
Likes   Reactions: WWGD
Can you start SQL server configuration manager? You probably need the check if the sql server browser service running. The TCP/IP network protocol should be enabled. Look if what the name of the instance of SQL server is, and don't browse, but connect to COMPUTERNAME\INSTANCENAME. Look at https://docs.microsoft.com/en-us/sq...-connecting-to-the-sql-server-database-engine See the steps under "testing a local connection"
If that doesn't work look in the windows eventlog if there were any errors during startup of sql server (restart services with configuration manager if necessary).
 
  • Like
Likes   Reactions: WWGD
Thanks all, I just uninstalled and I am re installing at the moment.
 

Similar threads

Best courses to revise SQL in 2 days?
  • · Replies 6 ·
Replies
6
Views
2K
What does it mean that MySQL is a server application?
  • · Replies 16 ·
Replies
16
Views
3K
User-Defined Functions in Sql Server SSMS
  • · Replies 7 ·
Replies
7
Views
3K
Why can't there be a Database tool that has the best of everything?
  • · Replies 5 ·
Replies
5
Views
3K
Amateur Dev Q: Creating Front End for SQL Server DB
  • · Replies 18 ·
Replies
18
Views
4K
Python Query runs fine in MySQL, but returns empty list in Python
  • · Replies 7 ·
Replies
7
Views
5K
Request for Large Databases (100,000+ rows) to Practice with
  • · Replies 8 ·
Replies
8
Views
3K
Python Python Socket library to create a server and client scripts
  • · Replies 9 ·
Replies
9
Views
4K
Embarrassingly Simple SQL Server query: List Even numbers in....
  • · Replies 7 ·
Replies
7
Views
2K
Simpler alternatives to SQL-like databases
  • · Replies 50 ·
2
Replies
50
Views
9K