Is it possible to have SQL Express and SQL Server Enterprize installed at the same time ?? [modified]
-
Hi all, I had SQL Server 2005 EXPRESS installed in my Computer (WIN XP) and I have just got SQL SERVER 2005 Enterprize edition. Now, I wanted to install SQL ENTERPRIZE but I got message that, a SQL Server instance is running so .etc.. and failed. So My point is, I want to develop Windows application using SQL Server Express 2005 so that it is easy to ship and free to distribute. But I want to have SQL Server Enterprize for Web Development purpose and other reasearch work. Is it not possible to keep both of them at the same time ? AND .. CAN I USE SQLEXPRESS WITH VISUAL STUDIO 2005 PROFESSIONAL ? Thanks EMRAN -- modified at 23:34 Tuesday 8th August, 2006
-
Hi all, I had SQL Server 2005 EXPRESS installed in my Computer (WIN XP) and I have just got SQL SERVER 2005 Enterprize edition. Now, I wanted to install SQL ENTERPRIZE but I got message that, a SQL Server instance is running so .etc.. and failed. So My point is, I want to develop Windows application using SQL Server Express 2005 so that it is easy to ship and free to distribute. But I want to have SQL Server Enterprize for Web Development purpose and other reasearch work. Is it not possible to keep both of them at the same time ? AND .. CAN I USE SQLEXPRESS WITH VISUAL STUDIO 2005 PROFESSIONAL ? Thanks EMRAN -- modified at 23:34 Tuesday 8th August, 2006
Hello
emran834 wrote:
Is it not possible to keep both of them at the same time ?
As far as I know it's possible. You can install multiple SQL servers on a single machine using different instance names. Maye you should post the whole error message. And of course I don't think I have to remind you that you should close Visual studio and/or any other program using SQL server.
emran834 wrote:
CAN I USE SQLEXPRESS WITH VISUAL STUDIO 2005 PROFESSIONAL ?
Sure!! Why not?? I do it all the time:) Regards:rose: