• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2223
  • Last Modified:

SQL Management Studio cannot connect to clustered SQL

Hello,

We have a clustered MS SQL DB (QEPRSCCM\QEPRSCCM) which we want to manage through SQL Management Studio from a remote machine but when we try to logon from the remote machine we recieve the following error:



TITLE: Connect to Server
------------------------------

Cannot connect to QEPRSCCM\QEPRSCCM.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------



Thing for consideration:

SQL SERVER:      Remote access has been enabled.

REMOTE CLIENT WITH SQL MGMT STUDIO:      We're not sure what server to point this at as this is clustered SQL. Also, as this is a clusted SQL do we have to point this to a different port? I've read something about clusted SQLs usign port UDP 1434.

Any ideas?

Thanks.
0
malkaj01
Asked:
malkaj01
1 Solution
 
navinmohantaCommented:
Please check for the firewall settings.

Thanks !
0
 
Mohit VijayCommented:
try to connect with QEPRSCCM, dont use QEPRSCCM\QEPRSCCM

also check if your SQL Browser service is running or not (Adminstrative tools/services/..)
0
 
malkaj01Author Commented:
navinmohanta: Firewall disabled on server. What port should I take in mind for clustered SQLs?

VjSoft: QEPRSCCM does not resolve as this is the cluster name. What server name should we be using?

0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
navinmohantaCommented:
The port is 1434. Also open services.msc to check whether SQL Browser service is running on the Server or not.

Thanks !
0
 
malkaj01Author Commented:
navinmohanta: sqlbrowser.exe running OK and listening on port 1434. What server name should I be using for clustered SQLs?
0
 
GSGDBACommented:
hi, you have to use virtual server name. not the cluster name. can you please check whether the sql server agent is running on the pointed server.
0
 
malkaj01Author Commented:
Ended pinging the instance name and got a reply for the full FQDN. Connected OK.
0
 
malkaj01Author Commented:
Resolved by other methods.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now