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 |
|
mjb_AEA
Starting Member
5 Posts |
 Posted - 2007-06-29 : 11:39:44
|
| I am working on a computer connected to a network. I am using SQL 2000/XP on my computer so I can manage other sql servers on our network (I'll call them S1 and S2, both running SQL 2000)I recently received a new computer running SQL 2005 Standard/Vista. When I try to connect to S1 and S2, I can’t find them anywhere. Am I overlooking some settings in 2005/vista?I am a little inexperienced at this, so please let me know if any additional information would be helpful.Thanks in advance |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2007-06-30 : 01:42:38
|
| Can you ping them?Nathan Skerl |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-30 : 02:16:28
|
Is the SQL 2005 configured to enabled remote connections ? Run Surface Area Configuration to verify
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-30 : 20:30:46
|
| How did you connect to them? In ssms? |
|
|
|
mjb_AEA
Starting Member
5 Posts |
Posted - 2007-07-02 : 13:54:13
|
| Sorry about the late reply, I am now connected. I created an alias in the SQl Native client config, and was able to connect. I dont know if that is the best or correct way, but it worked.Thank you everyone for your reply. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 14:17:35
|
| Seems protocol related issue. Yes, that's the way to solve the problem. |
|
|
|
|
|
|
Problem connecting to other sql servers on network