Why are blocked servers prohibited?

Question

I work in a corporate environment where the creation of linked servers is absolutely prohibited. I asked the database administrator, and the only answer I ever received was "This is a policy." Therefore, I have to write and use SSIS packages to move data between databases when the need arises.

Can someone tell me what reasons could be behind creating such a policy? It seems to me unjustified.

Answer 1

The theory goes that if one server is hacked, any linked server will also be automatically compromised.

, , , . , , , .

, , , , , , , db . , db, db, , , .

Answer 2

, , .

Answer 3

Simple. - , " " . ( ) ( A B).

, , , . .

, . , .

Answer 4

. - . , :

​​

, - .

"" - -, , ; . , , DBA . , . , , , .

. , SOA - .

P.S. : SOA , , , SOA fantasy kinda : -)

Answer 5

, .

:

• " ",

• " ", sys.server_principals, , NT: ( , )

• " self" ( " " ), "domain\bob" . , SPN, AD.

:

• , "syadmin", . , SQL .

OPENDATASOURCE, , adhoc . .

, , . , .

, FWIW.