I have a 2000 / 2005 side-by-side installation on our test server.
To login to 2005 with SSMS, the connect string is
hostname/SQL2005, 1434
There's a WiFi network connecting my client PC to the network.
SSMS fails to login frequently. I need to exit SSMS, then login again. It'll work.
A new problem today - after successful login, I can't open a project and login successfully. Error messages states "Failed to Login".
Any tips
Sam
SSMS - Intermittent Login Failure
phoenix.8848.cn
Even though I had port 1433 and 1434 open, disabling my Windows XP firewall solved this problem.
Any idea on how I can enable my firewall and keep SSMS running would be appreciated.
Sam