Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a server that has (and needs to keep) SQL Server 2005.

We are hosting intranet sites on one server (server 1), but have a database on another server (server 2). One of these sites uses AJAX to go server-side (server 1) and then queries databases on server 2.

We are trying to cut out the middle man and we want to install WebMatrix (which comes with SQL Server CE) on the same server as the database (server 2), but this server already has SQL Server 2005 installed.

Will a simple WebMatrix install (i.e., SQL Server CE) break the SQL Server 2005 install?

My guess is that it won't, but the damage recovery would be considerable if it does.

I don't think it matters, but server 2 has Windows Server 2003.

share|improve this question
1  
I know SQL Server 2005 will live next to 2008 and 2012 just fine, just not sure about CE. However the best suggestion I can offer is to grab another server and test it if possible. That is the only way you can be sure nothing goes wrong. –  Wind Raven Mar 11 at 19:59
    
I appreciate the suggestion, and the info. I will talk to my boss to see if we have at least a virtual server we can test or something. –  VoidKing Mar 11 at 20:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.