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

Exactly what error message are you getting on your Vista box when you try to connect/login?

---

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

Exact error:

 http://devel.mcpapps.net/images/vistaclienterror.jpg

 
"(provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

(Microsoft SQL Server, Error: 10060)

 OTHER NOTES:

I am able to connect to my local sql server using sql authentication, addressing the server by ip address, and picking the TCP provider drop down.

I am able to connect to ultima's sql server from all my XP machines.

Again, I cannot connect to ultima's sql server from any vista client. ( I have two vista business installs.  One clean install and one upgraded from XP Home.)

 I have searched google for about a week trying to solve this.  Still don't have an answer...

---

-Ben

You may be using the wrong IP address.  This is the one I use:

69.16.211.96,937

---

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

Remote connections have been disabled at the moment.

---

System Administrator

Any idea when remote access will be reenabled?  Also it would have been nice to have received an email that this functionality was going to be disabled, slightly frustrating to have to hunt down this fact.

I'm having the same problem.  Did you ever get an answer?  I can't get anyone to answer my emails to support@ultimahosts.net.

 

My vista problem is separate from ultima disabling remote connections.   

---

-Ben

Remote connections seems to be disabled at the moment. Does anybody know when they will be up again?