SQL Server 2000 and 2005

  • 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

  • Did you uninstall SQL server 2005 and install SQL 2000 on same server?

    Did you rebooted your server after uninstallation?

    Make sure the compability level is 80.

     

     

  • They are both on the server.

  • You must have instance name for sql server 2000..

    Try to connect SQL sever 2000 instance. It must be your named instance because you have installed SQL 2005 first as default instance.

  • SQL2005 was probably installed as a default instance (instance name = MSSQLSERVER). SQL2000 was then had to be installed as a named instance (instance name = foo). When you connect via QA you are probably connecting to the default instance which means you're connecting to the SQL2005 instance.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply