Linked server under 2 VLANs

How to create a Linked server to be accessed by 2 different VLANs each having MS SQL 2005 server enterprise on Windows 2003 enterprise ?
What are the data needed to accomplish this task, considering all aspects of security and performance?
GlNGERAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Kindly check the following:

1. Make sure sufficient ports are opened for these two VLAN's so that these two servers can access each other without any issues.
2. Don't open the default ports 1433 and open a different port instead.
3. Make sure that MSDTC is running on both sides with port 135 excluded to make it work from both the sides.
4. Make sure that only authorized users are able to connect using VPN connection.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Why a C Grade?

Kindly check this one out..

http://www.experts-exchange.com/help.jsp#hi403

And request you to re-assign appropriate grades.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.