Our network guy first installed 2005 on our server. I created a database, we had some sort of issues and so decided to install 2000. I removed the db I created on 2005 and restored it on 2000 instead.

Here's my problem....When I log in to query analyzer(sql 2000) using my windows auth, I get a list of database that are on the 2005 server, not 2000.

I think 2005 is set as my default server. How can I change it to be 2000?

Any help is greatly appreciated.

Thanks,
Ninel

OK, maybe I am not completely understanding what happened. From what i gather, you installed SQL Server 2005, then installed SQL Server 2000 without uninstalling SQL Server 2005. Correct? If that is the case, when you installed SQL Server 2000, did you create a new instance of SQL Server 2000? It appears that for some reason SQL Server 2000 is using the same SQL Server 2005 instance. I have never had both installed on the same box, espcially in that order, but that is what it sounds like is happening.

I would remove SQL Server 2000, reinstall with a new instance, and try again.

Ok...I created a login on the 2000 server called timecontroluser. When I use
remote desktop to logon to the server I connect to query analyzer like this:
We have both servers running.

Ok...I created a login on the 2000 server called timecontroluser. When I use remote desktop to logon to the server I connect to query analyzer like this:

SQL Server: ITITPAIT04\SQL2K
SQL Authentication:
        Login: timecontroluser
        Pass: timecontroluser

This works. I get logged in.

When I am not directly on the server, but using my local query analyzer to logon doing the same as above, I get "SQL Server does not exist or Access is denied"

Why can't I connect?

Try it like the following:

SQL Server: ITITPAIT04
SQL Authentication:
        Login: timecontroluser
        Pass: timecontroluser

What happens?

If I just use ITITPAIT04, it connects me to the 2005 server. ITITPAIT04\SQL2k is the instance of 2000.