I have a client that is using an SBS server 2003 premium which includes SQL 2000 server. They use the SQL Server 2000 for a special Truck Dealer System and each workstation is using odbc connection to the applications database. There is no user authentication in place as each odbc connection uses the same credentials. The software vender is now asking that they upgrade their SQL server to 2005. We can get SQL 2008 server with a downgradable license from Microsoft.
Question is can we install SQL 2005 on this same server with out disrupting the current SQL server 2000 operation? Can we have both versions running at the same time?