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.
Leave A Comment?