Basic sbs2003 question about sql server 2000 and/or 2005
marklarson
Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were using SQL Server 2000 on the old server for a few things: Backup Exec, Prolog (construction mgmnt software), Great Plains (MS financial), etc. During the install, I kind of just followed directions and installed R2, which I guess installed SQL Server 2005. I wasn't really aware of options. Since then I have had a number of problems that seem related to SQL 2005.
For one, I've having trouble with the communication between our primary business app (S2000Win, a service dispatch software with billing functionality) and the aforementioned Great Plains, which does GL and AP. We're supposed to be able to export data from S2kWin and have it read by Great Plains, but this isn't working.
Second, I can't get Backup Exec 10d to load. Beserver.exe loads and hangs with the status of "Starting" and I haven't been able to resolve it yet. I'm working with Symantec people on another forum for that (but if you have any ideas, feel free to make my holiday.) While installing, BE says that the SQL2000 instance isn't updated to the correct service pack and that it will have to install MSDE. Although BE says they support sql 2005, some tech support forum help believes that my problem may come from MSDE and 2005 running together. Go figure.
I now believe I could have just stuck with SQL Server 2000.
Beware of Stupid Questions! (I've been able to get by so far without really understanding SQL server and BE and Quantum Theory.)
But first, can I run "SQL Server 2000 and 2005 on the same server? Could I then choose which to use for which database? And, even if it's possible, is this a terrible idea?
Is it possible and wiser to uninstall the SQL server 2005 and go back to running 2000? Can I do this without starting over? Can I just uninstall the SQL Server 2005 and reinstall 2000 without running a whole reinstall? (Better yet, can I uninstall SQL2005 and have SQL2000 miraculously appear in it's place while harp music plays in the background and I am suffused by a warm, illuminating light?)
I believe everything I have will run on SQL Server 2000. In fact, I know it.
EggHeadCafe - Software Developer Portal of Choice
How To Create a Custom IE8 Accelerator
http://www.eggheadcafe.com/tutorials/aspnet/8ae07577-f1c5-498b-a7da-11c3e7cc2a61/how-to-create-a-custom-ie.aspx
Erland Sommarskog
> My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the
> same ssbs2003 server? and, regardless, Should I/ can I uninstall SQL
> Server 2005 and go back to SQL Server 2000.
Generally, you can run both SQL 2000 and SQL 2005 on the same server.
But what applies to SBS I don't know. I think you are better off asking
in a forum devoted to SBS.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx