Groups > comp.databases.ms-sqlserver > #568

Re: Using SQL Server IP for non-sql uses on a failover cluster

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Using SQL Server IP for non-sql uses on a failover cluster
Date	Mon, 25 Jul 2011 10:57:52 +0200
Organization	Erland Sommarskog
Lines	41
Message-ID	<Xns9F2D6F896935AYazorman@127.0.0.1> (permalink)
References	<d40c34da-f44b-4a5b-9164-5c5b9f65253c@z7g2000vbp.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="9213"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/KQii1zUL3EdbN6n2aMvUU"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:T3m+nW+EXG3gYFJQ44NpuldX17o=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:568

Show key headers only | View raw

Mark (google@markginsburg.com) writes:
> At my organization, users have started to use the virtual address
> created when SQL Server is installed on a failover cluster for non-SQL
> uses.
> 
> I have always created an cluster IP resource in addition to the SQL
> cluster IP resource for non-SQL access to the server (like for mapping
> drives).
> 
> What is the impact on SQL Server if people use the SQL virtual IP for
> non-SQL related access to the cluster?
> 
> Is there a best practice that dictates that a separate IP should be
> provided for non-SQL access?
 
Since I'm into clustering myself, I relayed the question to my MVP mates.
Here are two responses I recevied:

    There is no different impact to SQL Between using the SQL name/ip or a
    different name/ip in the same resource group.  All it is in either
    case is a socket connection to the server on one ip or another. 

And response to this comment was:

   The impact is this: if they add it to the SQL group, make it a 
   dependency of the SQL resource, and it goes down, it can potentially
   take SQL down. 

   So never add anything to the SQL group for non-SQL access if you care
   about HA. 




-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Using SQL Server IP for non-sql uses on a failover cluster Mark <google@markginsburg.com> - 2011-07-24 12:52 -0700
  Re: Using SQL Server IP for non-sql uses on a failover cluster Erland Sommarskog <esquel@sommarskog.se> - 2011-07-25 10:57 +0200
    Re: Using SQL Server IP for non-sql uses on a failover cluster Mark <google@markginsburg.com> - 2011-07-25 06:09 -0700

csiph-web