SQL 2005 Cluster with dedicated nic for Sharepoint DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brady Toulou - 10 Aug 2007 19:56 GMT

I was wondering if this was possible. We have many databases on this
cluster and I would like to isolate sharepoint network traffic to a
dedicated nic. My thoughts is to create new cluster resources for an
ip-address and network name and create a DNS alias like 'SharepointDB' that
points to the new cluster resource and have Sharepoint connection string use
the DNS alias.

I think this should work but I'm not sure how SQL will handle this.

Thanks,
Brady

Reply to this Message

Hilary Cotter - 14 Aug 2007 03:59 GMT

Post this to the clustering newsgroup.

Signature

relevantNoise - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I was wondering if this was possible. We have many databases on this
> cluster and I would like to isolate sharepoint network traffic to a
[quoted text clipped - 9 lines]
> Thanks,
> Brady

Reply to this Message

Simon Sabin - 18 Aug 2007 11:42 GMT

Hello Hilary,

Should be fine. By default enabling TCP, enables SQL to listen on all ip
addresses.

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Post this to the clustering newsgroup.
>
[quoted text clipped - 16 lines]
>> Thanks,
>> Brad

Reply to this Message