Connecting to an upgraded SQLServer

I had a database box with SQLServer2000 on it somewhere.  let's say the IP Address was www.xxx.yyy.zzz

I upgraded to sqlserver 2008.  Maybe I didn't upgrade, maybe I added a new instance who knows.  The old sqlserver2000 wasn't running and the new sqlserver2008 was.  On a different port.  My code connection strings became www.xxx.yyy.zzz/MSSQLSERVER2008

I was trying to connect to this new database for weeks using the SQL Management studio.  No dice.  Read all sorts of articles.  Made sure Remote Connections were enabled and that the SQL Browser service was running.

In order to connect to this database I had to enter the servername as:  www.xxx.yyy.zzz,PORT

so something like 333.444.555.666,4567

Worked like a charm.  Sucked when it didn't work and I had to log into Remote Desktop to do anything.

Can't log into SQL Server

Had to reboot one of my servers today and after it loaded, I couldn't access or log into my local SqlServer at all.

I had changed my windows login password a few months ago but I guess I never rebooted back then.  After some digging I was able to find this solution:

I actually managed to solve this problem...i think my SQL Server was set to mixed mode which is why i was having problems with my new win2k password--

here's how i did it (for others who are facing teh same problem)
in win2k-
-go to the control panel
-click on administrative tools
-click on services
-right click on MSSQLServer and choose properties
-click on logon tab
-enter and confirm new password
-restart SQL Server

its actually in the help section (for SQL Server 2k) under the heading "Changing Passwords and User Accounts" and there also is info there for win 4.0 NT.