¿Cómo puedo solucionar un error en SQL Server?

Question

Me sale el siguiente error cada vez que quiero conectar la base de datos:

TITLE: Connect to Server

---

Cannot connect to FABIANDIAZ2004\SQLEXPRESS.

---

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: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--1-database-engine-error

---

BUTTONS:

OK

---

Como puedo arreglar ese error ayuda es urgente ya que requiero utilizar la base de datos

Answer 1

Welcome to Q&A Forum;

this is a great place to get support, answers, and tips.

Thank you for posting your question; I'll be more than glad to help you out.

Your error message is a standard (and not very specific) error message which can have thousands of reasons...

First, what comes into my mind reading your topic.. a SQL Server Service is running (or should be running) called "SQL Server Browser"... then is there any network protocol enabled for your instance, if you try to reach a local instance Shared Memory would be easy or NamedPipes... if it is on a different server, you should enable the TCP-protocol... are there necessary holes in the firewall?

Can you give us a screenshot of your error and how you try to connect?

And the error log of that given instance might support in giving you pieces of advice.

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 2

Hi @Fabian Esneider Diaz Gomez

Yes, as Bjoern Peters said, this error can happen for many reasons. You can use this link to help troubleshoot errors: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection.

You can also check the error log to provide more detailed error information for us to analyze.

Best regards,

Aniya