Terrymac_Computer_Guy
asked on
sbs 2003 premium and SQL Server 2005
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?
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?
Why you do not upgrade your existing SQL2000 -> SQL 2005? There is nothing in SQL 2005 that could be done in 2000.
ASKER
I don't want to disturb the current setup. Client would like to ease into the newer version (tesing forms and functionality) before moving to the new version live.
Sure - you're right.
If nobody knows - just try them both at Microsoft VirtualPC or Sun VirtualBox.
If nobody knows - just try them both at Microsoft VirtualPC or Sun VirtualBox.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check the following for upgrade...
http://msdn.microsoft.com/en-us/library/cc966519.aspx
http://blog.scalabilityexperts.com/2008/01/28/upgrade-sql-server-2000-to-2005-or-2008/
http://msdn.microsoft.com/en-us/library/cc966519.aspx
http://blog.scalabilityexperts.com/2008/01/28/upgrade-sql-server-2000-to-2005-or-2008/
ASKER
Thanks gentlemen, much appreciated.