SQL Managed Instance linked-server error

Question

안녕하세요

SQL Managed Instance 에서 linked-server 기능을 사용하고자

온프레미스 서버에 SQL Managed Instance db연결 후 linked-server 를 사용 한 결과 아래와 같은 오류가 발생 하였습니다. 여기에 대한 해결 책이 있을까요?

제목: Microsoft SQL Server Management Studio

---

연결된 서버에 대한 연결 테스트에 실패했습니다.

---

추가 정보:

Transact-SQL 문 또는 일괄 처리를 실행하는 동안 예외가 발생했습니다. (Microsoft.SqlServer.ConnectionInfo)

---

TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

OLE DB provider "SQLNCLI11" for linked server "G1230" returned message "Login timeout expired".

OLE DB provider "SQLNCLI11" for linked server "G1230" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, 오류: 10060)

도움말을 보려면 다음을 클릭하십시오: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error

---

단추:

확인

---

Answer 1

Server is not found or not accessible. Check if instance name is correct

As the error message says.

For a more detailed answer we need more details informations.

Is e.g. a Firewall running, blocking the access?