error while setuping data base engine and getting below error

shaiksha vali 21 Reputation points
2022-06-25T10:54:09.507+00:00

214937-image.png

Azure SQL Database
SQL Server Other
{count} votes

3 answers

Sort by: Most helpful
  1. Bjoern Peters 8,921 Reputation points
    2022-06-25T15:48:12.09+00:00

    Is that Management Studio in the same machine? Which protocol do you use?

    If I remember it correct - by default - one protocol is disabled and maybe you are trying to connect with that protocol…

    Please check your usable protocols
    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver16

    Try again.


  2. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2022-06-25T20:05:01.467+00:00

    The error message means that the SQL Server instance you try to connect to was not found. There can be a whole number of reasons for this:

    • The instance does not exist at all (wrong server name, wrong instance name etc.)
    • The instance is not running.
    • Network issues.
    • Firewall.
    • The instance is on a remote machine but it only accepts local connections.

    And the list goes on. Since you did not give any indication why you expect this to work in the first place, we cannot give much detailed help. Here is a link to a troubleshooter.


  3. Seeya Xi-MSFT 16,586 Reputation points
    2022-06-27T06:10:08.123+00:00

    Hi @shaiksha vali ,

    Welcome to Microsoft Q&A!
    Here are some steps for troubleshooting:

    • Make sure your server name is correct.
    • Make sure your instance name is correct and there is actually such an instance on your target machine.
    • When you try to connect to an SQL Server instance on another server, make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    • Make sure SQL Browser service is running on the server.
    • If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    What's more, make sure the mode is SQL Server and Windows Authentication mode on Security page.
    Here is a related article you can refer to: https://support.solarwinds.com/SuccessCenter/s/article/Exception-A-network-related-or-instance-specific-error-while-establishing-a-connection-to-SQL-Server-EDIT?language=en_US

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.


Your answer

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