Running SQL 2000 and SQL 2005 in the same server

Hello,

I would like to know if we can install MS SQL 2000 and MS SQL 2005 in the same server and use it with HC. I know that we can run both the versions in the same server, however, I would like to know if we install both the versions, do we get an option to select the MS SQL version to use while creating a database. If this is not possible, then I would urge HC to consider implementing it.



An ICANN Accredited Domain name Registrar - OwnRegistrar.com
| Shared Hosting | Reseller hosting | Dedicated server | - QualiSpace.com
Premium AntiSpam / AntiVirus gateway - SpamTermino.com
Signup as a reseller and get domains only for $6.49

see: http://forum.hostingcontroller.com/topic.asp?TOPIC_ID=4622
in the first line under 'Enhancements:'

Have you ever tested it in a test or a production environment?

An ICANN Accredited Domain name Registrar - OwnRegistrar.com
| Shared Hosting | Reseller hosting | Dedicated server | - QualiSpace.com
Premium AntiSpam / AntiVirus gateway - SpamTermino.com
Signup as a reseller and get domains only for $6.49

Yes we have tested in production environment and its working fine.

________________________
HC Support Team
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-341-1419

quote:

---

Originally posted by nitaish
[br]Hello,

I would like to know if we can install MS SQL 2000 and MS SQL 2005 in the same server and use it with HC. I know that we can run both the versions in the same server, however, I would like to know if we install both the versions, do we get an option to select the MS SQL version to use while creating a database. If this is not possible, then I would urge HC to consider implementing it.

---

Wouldn't it be the good option to use Sql 2005 & MSDE in a same machine instead of sql 2000. After all MSDE has complete database engine features except Front hand interface (Enterprise manager). From this way we can save some system memory.

Hi,
Some securyty tips for HC improve when it creates one data base (MSSQL Server 2005).

SQL Server 2005 Deployment Guidance for Web Hosting Environments
SQL Server Best Practices Article.

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/SQL2005DGWHE.mspx

I read that some denies are very important for Hosting environments.

Regards,

Thanks for the tips. We have fowarded to the concerned dept. for consideration.

________________________
HC Support Team
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-341-1419