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 |
|
CujoX
Starting Member
3 Posts |
 Posted - 2007-01-03 : 17:17:32
|
| Greetings,First I am fairly new to SQL Server 2005 Clustering so this is why I was to see if any of you might be able to help me.Are current setup is as follows:CRM1 SERVER 2K3 R2 xxx.xxx.xxx.74CRM2 SERVER 2K3 R2 xxx.xxx.xxx.75HP MSA1000 xxx.xxx.xxx.75MSDTC IP xxx.xxx.xxx.77SQL INSTANCE xxx.xxx.xxx.78Now are CRM guys are trying to connect to xxx.xxx.xxx.78 for there SQL instance or RDP into this ip address and they can’t…Now the question is should they be able yto logon to the SQL Instance via RDP?Thanks,CujoX |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-03 : 19:30:45
|
| short answer is yes. They should be able to RDP to the virtual hostname used by the SQL Server cluster group. This will actually connect you to the underlying node that the SQL group is running on (CRM1 or CRM2 in your example).WHat error are you getting? Is RDP access enabled? Can you RDP to the individual nodes that make your cluster?-ec |
 |
|
|
CujoX
Starting Member
3 Posts |
Posted - 2007-01-12 : 12:18:33
|
| First sorry for the delay, so I checked to see if RDP was inabled on CRM1 & crm2 it was enabled but no member added so I added are WebTach Group and Domain admins..I asked the WebTach guys what was going on and they can ping the SQL INSTANCE xxx.xxx.xxx.78 but when they try to rdp into the ip it fails, but they can ping it...Error: sql browser services doesnt' startThanks,CujoX |
|
|
|
CujoX
Starting Member
3 Posts |
Posted - 2007-01-12 : 12:19:11
|
| you can e-mail me at tsteeves@graebel.com if you would likeThanks,CujoX |
|
|
|
|
|
|
SQL SERVER 2005 FAIL OVER CLUSTER