Linked Server, Ensuring One Way Access?

[bernie321]

Hi

We have an office SQL Server 2005 and have just setup a web SQL Server 2005 server with our webhost.

If we setup the remote server as a linked server on our office server is this one way? i.e. does it mean that only the office server can access the linked server, and not the other way round?

I believe this to be the case but just want to check from a security perspective.

Thanks
B

 

[mrdenny]

Yes, linked servers are one way.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog