Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2009-11-04 : 02:03:20
|
| Hi Experts,I have this problem this week on to Cluster servers.It says Cannot connect to <SQL01>An Error has occured while establishing a connection to the server. when Connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. (Provider:SQL Network Interfaces error 26 - Error locating server /Instance Specified) (Microsfot SQL Server).We Tried to use the Configuration Manager on the Server and tried to connect to the server.Resulting of these, No Maintenance plan or Logins were working.Please, many thanks for your expert solution. |
|
|
learnit
Starting Member
6 Posts |
Posted - 2009-11-04 : 07:45:21
|
| Hey,Even we encountered this anonymous error.-> please check the network connection (either by enabling some sniffer) and i m sure you should see some ray of light. |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-11-04 : 15:46:30
|
| Thanks so far.This is the cluster server nodes and we see all the disk drives were disabled on 1st server and is available on 2nd server. Since Quorum is running on 2nd server. All the Jobs were halted and no logins were enabled.Please treat this my problem as urgent and waiting for your expert advise. |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-11-04 : 22:31:19
|
| Can anyone give the solution please as there is no clue on the Net as well for me.Thanks in advance. |
|
|
|
|
|
|
SQL Connection