How do I connect remotely to a SQL Server Cluster

Question

question

lelias asked Jan 21, '15

How do I connect remotely to a SQL Server Cluster

Using SQL Server 2012 Cluster.

sql server cluster always-on remote access

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Jan 27, 2015 at 06:04 AM

This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.

0 ·

Answer 1 · 2015-01-21T06:34:56Z

Tom Staab answered Jan 21, '15

By "connect remotely" I'm not sure if you mean SQL Server access from a different machine or remote desktop to the host, but I'll address the former. If you are using SQL Server 2012 AlwaysOn Availability Group, you can connect directly to a given SQL instance or connect to the current primary through the listener name or address and port.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2015-01-22T00:13:06Z

Bandit121 answered Jan 22, '15

You should be able to 1. Open SQL Server Management Studio 2. Select the SQL Server (Cluster) Name from the [Server name:] drop down 3. If Cluster is not in the list, you can either type it in or browse for it 4. Choose Authentication type (Windows Authentication or SQL Server Authentication) 5. Enter your credentials (if SQL Server Authentication is selected) 6. and click connect

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question