Networking Protocols and SQL Server 2005 Virtual Server

re: Networking Protocols and SQL Server 2005 Virtual Server

Jason — Tue, 20 Mar 2007 21:47:06 GMT

Regarding this portion -

To add an additional IP address your virtual server listens on, you can let your “Network Name” resource depend on an additional “IP Address” resource. You can also configure/update the IP address and its NIC card through Cluster Administrator. These IP addresses may belong to different networks. We recommend users use Cluster Administrator, rather than SQL Server Configuration Manager, to configure IP addresses of a SQL Server 20005 Virtual Server. Users can still use the SQL Server Configuration Manager to configure the TCP ports the virtual server listens on, though.

What if you wanted to add a second network that was for server to server traffic only that should not have it's IP registered publicly? I believe if you have the network name depend on both IP's they will both be registered in DNS. Also, new IP's registered on the server don't seem to show up in configuration manager. Anyone have any idea how to get them to show up?

re: Networking Protocols and SQL Server 2005 Virtual Server

Xinwei Hong — Tue, 27 Mar 2007 03:09:54 GMT

You can ask Cluster Administrator avoid registering DNS. There is a check box you should be able to find in the properities windows. The IP addresses shows on SQL configuration manager does not apply to SQL Cluster. SQL Configuration manager seems not able to check the IP addresses for SQL Cluster(need specific APIs to do it). I will check with related team see if they can improve this in next release.

Microsoft » Blog Archives » … two SQL Server 2005 in a cluster

Microsoft » Blog Archives » … two SQL Server 2005 in a cluster — Sun, 22 Apr 2007 13:48:47 GMT

PingBack from http://chaespot.com/mssql/2007/04/22/two-sql-server-2005-in-a-cluster/

Microsoft » Blog Archives » Before you start learning how to cluster, this

Microsoft » Blog Archives » Before you start learning how to cluster, this — Fri, 14 Sep 2007 03:19:37 GMT

PingBack from http://chaespot.com/mssql/2007/09/14/before-you-start-learning-how-to-cluster-this/

how do i fail over a specific named instance of sql 2005 to a another node

how do i fail over a specific named instance of sql 2005 to a another node — Wed, 04 Jun 2008 17:48:52 GMT

PingBack from http://josephsite.beyondspeed.com/howdoifailoveraspecificnamedinstanceofsql2005toaanothernode.html

re: Networking Protocols and SQL Server 2005 Virtual Server

Matt P. — Wed, 08 Oct 2008 17:06:48 GMT

Thamks for these nice hints, you saved my day.

I had added an additional virtual IP (though Cluster Adminitrator) to an SQL2005 Cluster, but SQLserver would not listen to it.

Was puzzled, 'til I read your description: The depedency from network name to the IP was missing.

Changed this, restarted: all fine.

クラスタ構成の SQL Server 2005 で共有メモリ接続ができない件について

SE の雑記 — Thu, 14 May 2009 03:04:30 GMT

クラスタ構成の SQL Server 2005 で共有メモリ接続をしようとすると以下のエラーが発生します。このメッセージだけだと分かりにくいのですが、接続先サーバーを localhost として設定すると

Networking Protocols and SQL Server 2005 Virtual Server

re: Networking Protocols and SQL Server 2005 Virtual Server

re: Networking Protocols and SQL Server 2005 Virtual Server

Microsoft » Blog Archives » … two SQL Server 2005 in a cluster

Microsoft » Blog Archives » Before you start learning how to cluster, this

how do i fail over a specific named instance of sql 2005 to a another node

re: Networking Protocols and SQL Server 2005 Virtual Server

クラスタ構成の SQL Server 2005 で 共有メモリ接続ができない件について

クラスタ構成の SQL Server 2005 で共有メモリ接続ができない件について