Share via

SQL Server v18.8 configuration manager

coolguy 1 Reputation point
2021-03-04T21:34:04.873+00:00

I have loaded SQL Server Management studio on my new computer, When I try to connect the data base engine there are no "Server Name"'s available for selection. I think this is related to not having the SQL Server v18.8 configuration manager tool, Can anyone help me with getting this set up. Thanks in advance

SQL Server | Other

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
    2021-03-05T03:32:04.043+00:00

    Hi coolguy-3283,

    Cannot connect to C:\Program Files (x86)\Microsoft SQL Server.

    It seems the SQL Server instance name you want to connect to is incorrect.
    When connecting to SQL Server, you must specify the name of the SQL Server instance. If the instance of SQL Server is the default instance, then specify the name of the computer where SQL Server is installed, or the IP address of the computer. If the instance of SQL Server is a named instance, then specify the name of the computer where SQL Server is installed or the IP address of the computer, and add a slash and the instance name (computername\instancename).
    In addition, is your instance installed on local computer or remote computer?

    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
  2. Erland Sommarskog 132.3K Reputation points MVP Volunteer Moderator
    2021-03-04T22:25:21.043+00:00

    I can but don't know what to type'

    Well, you need to ask your DBA what is the name of the SQL Server instance you are supposed to connect to.

    SSMS is only a query tool to connect to SQL Server. It is useless on its own. So if there is no SQL Server instance in your environment, you need to install one. Both SQL Server Express Edition and SQL Server Developer Edition are free. Developer is more versatile, but is not licensed for production. Express is limited, but is licensed for production.

    0 comments
  3. coolguy 1 Reputation point
    2021-03-04T22:01:53.277+00:00

    Doesn;t seem to be any detected

  4. coolguy 1 Reputation point
    2021-03-04T21:57:03.463+00:00

    I get the following:
    TITLE: Connect to Server

    Cannot connect to C:\Program Files (x86)\Microsoft SQL Server.

    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

    BUTTONS:

    OK

    0 comments
  5. coolguy 1 Reputation point
    2021-03-04T21:50:15.247+00:00

    I can but don't know what to type'

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.