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 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: References: 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 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