I have solved the problem and it wasnt related to Vista at all, I guess I was just grasping at straws.
It turns out the SQL Server was on a different domain than the user I was logging in as.
If I logged in as a new local user to my computer I can connect fine.
So it is a network/security...
Thanks for the help MrDenny,
Talk about port lockdown!
I have tried adding exceptions to the firewall for all the other applications and also even removing SSMS from the exception list.
I have also tried setting a rule to allow port 1433.
Unfortunately all of this has had no effect :-(
The...
I can't connect from a Vista Client to a SQL 2005 Server.
I have been stuck on this problem over a week so any help would be greatly appreciated.
Overview:
I cannot connect from my client (vista business) except with SQL Server Management Studio.
I have tried Red Gate SQL Compare connection...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.