I can connect to sql server using Management Studio from my XP machine just fine.

 I cannot connect from any Vista machine.

I cannot figure out why?

The vista machine connects to local servers using TCP, just fine.  I've tested locally using TCP and server authentication, not windows authentication.

 

NOTE: I am using <ipaddress>,<port> and again, this works fine from any XP machine.

 

Thanks in advance,

---

-Ben

Vista Firewall is probably blocking the port.  Unfortunately I'm not up on Vista protocols so I couldn't tell you how to open the port.

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

I have SQL Server 2005 SP1 and SP2 installed. 

Firewall is disabled.

UAC is disabled.

User account is an dministrator and I'm also shift-clicking to run as administrator. (both can't hurt)

---

-Ben