A network-related or instance-specific error occurred while establishing a connection to SQL Server

Rezolvare problema (Fix IT)

Situatie

Incercam sa ne conectam remote pe retea la o baza de date prin sql server management studio si primim urmatorea eroare

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: 28 – Server doesn’t support requested protocol) (Microsoft SQL Server, Error: -1)

Solutie

Pasi de urmat

Mergem in Sql Server Configuration Manager –> SQL Server Network configuration –> Protocols for (INSTANCE) –> TCP/IP unde vom deschide Properties.

Vom selecta tab-ul IP Addresses(Tab) si vom da scroll pana la intrarea IP All unde vom trece la TCP Port portul 1433.

Dupa asta vom da Apply si ok.

Pasul urmator este sa mergem in services.msc si dam restart la serviciul de SQL pentru instanta respectiva.

Tip solutie

Permanent

Voteaza

(17 din 33 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?