malkaj01
asked on
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.
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.
try to connect with QEPRSCCM, dont use QEPRSCCM\QEPRSCCM
also check if your SQL Browser service is running or not (Adminstrative tools/services/..)
also check if your SQL Browser service is running or not (Adminstrative tools/services/..)
ASKER
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?
VjSoft: QEPRSCCM does not resolve as this is the cluster name. What server name should we be using?
The port is 1434. Also open services.msc to check whether SQL Browser service is running on the Server or not.
Thanks !
Thanks !
ASKER
navinmohanta: sqlbrowser.exe running OK and listening on port 1434. What server name should I be using for clustered SQLs?
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Resolved by other methods.
Thanks !