connecting to an instance on a cluster

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » connecting to an instance on a cluster

connecting to an instance on a cluster

Rate Topic

Display Mode

Topic Options

Author

Message

Chris Hall-421715

Posted Sunday, January 27, 2008 9:58 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, July 16, 2012 5:56 AM
Points: 18, Visits: 130

We have a 4 node cluster with a total of 16 instances on it.

Presently, to connect to the instances I use RDP to connect to a node on the cluster, then connect to the instance.

So for example, I RDP to the node SQL1N3, start SQL Server Management Studio, then connect to MONSQL\MONSQL

Is it possible to connect from my desktop and not have to RDP into the cluster first?

I've tried connecting to MONSQL\MONSQL from my desktop as well as SQL1N3\MONSQL but neither work.

Any help is appreciated.

Post #448051

SQL ORACLE

Posted Sunday, January 27, 2008 10:34 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

Sure, you can. You need to use the virtual IP address for SQL instance. To find it, you can go to the cluster administrator on the cluster.

Post #448063

Key DBA

Posted Monday, January 28, 2008 7:36 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 26, 2009 3:02 PM
Points: 515, Visits: 655

The "Server Name" column output of the script below will give you the
"Virtual SQL Server Name (Cluster)" for your cluster, allowing you to use it as your value for Server Name for connecting via SSMS on your local desktop. Run the script in SSMS against the master database.

-- Show information about all SQL Server Databases in a given instance.
-- SQL Server 2000
-- SQL Server 2005
USE master
GO

select
cast(serverproperty('ServerName') as varchar(20)) as [Server Name]
,case when serverproperty('InstanceName') is null
then '(default)'
else serverproperty('InstanceName')
end as [Instance Name]
,name as [Database Name]
,cast(serverproperty('productversion') as varchar(20)) as [Product Version]
,cast(serverproperty('productlevel') as varchar(20)) as [Product Level]
,cast(serverproperty('edition') as varchar(40)) as [Edition]
FROM dbo.sysdatabases

Hope This Helps

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

Post #448304

« Prev Topic | Next Topic »

Permissions