The Object Explorer will no longer connect

James Mouland 1 Reputation point
2021-04-09T19:56:38.037+00:00

I am using this program for my database college at class, today, the object explore just decided that it no longer wanted to connect to the server. I haven't installed or uninstalled anything recently, till today. So have I have Uninstalled and reinstalled the server 2 times.

Keeps giving me a error that it can't find a file.

86316-error.jpg

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,759 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,606 Reputation points
    2021-04-12T06:20:07.767+00:00

    Below document should help

    https://learn.microsoft.com/en-us/troubleshoot/sql/connect/resolving-connectivity-errors

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments
  2. Alberto Poblacion 1,556 Reputation points
    2021-04-11T10:04:00.993+00:00

    Unfortunately, this error message is not very useful because you always get the same error message whenever the server cannot be contacted, regardless of the cause why it cannot be contacted.

    There are several things that you can verify to attempt to solve the problem:
    First, check that the SQL Service is running. You can verify this from SQL Server Configuration Manager, or even from the Services applet in the Windows Control Panel.
    If it is running, the next steps depend on whether you are running SQL Server Management Studio on the same machine as the server, or from a remote machine. Presuming that it is on the same machine, the most common reason for failure is that the name of the server is not correctly written in the dialog box in Management Studio. Make sure that you are typing the correct combination serverName\instanceName (if you have installed a named instance it is necessary to type the instance name; just typing the server name is not sufficient). Also, verify that you are typing a back slash and not a forward slash.

    0 comments
  3. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-04-12T06:06:13.853+00:00

    Hi @James Mouland ,

    Are there any updates on this issue?
    Please make sure the name of instance you want to connect to is correct, and the SQL Server instance is running.
    And the default instance listens on port 1433 by default. Please check if the TCP/IP is enabled and the port have not been blocked.
    Please refer to this article and this doc which might help.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments