January 27, 2008 at 9:58 am
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.
January 27, 2008 at 10:34 am
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.
January 28, 2008 at 7:36 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply