[AccessD] FW: [dba-SQLServer] Installing SQL Server 2005 developer on a machinewith SQL Server 2005 express edition

Hi Doug,

I'm certainly not a guru but I had SQL2005 standard on my machine. A 
friend was having some problems with express so I installed it on my 
machine as well so I could see what he was seeing. Both worked fine. I 
might add I also had SQL 2000 on the same machine. My Server has SQL 
2000, 2005 and 2008 on it and all seems OK.

Even though it works, I would recommend removing express, installing 
standard and then just change the connection string in VB 2008 projects 
to the name of the instance you want to connect to.

Be sure to not use the default SQL Server name (Your computer name would 
be the default for the first instance of SQL Server) but name it 
something else like SQL2005 and SQL2005EXP, etc as you add instances.


HTH

Bill

Doug Murphy wrote:
>  I posted this on the SQL list but there does not seem to be much action
> over there today.  Possibly some one on this list can answer.
>
> Thanks.
>
> Doug
>
>
> Folks,
>
> I am looking at installing SQL Server 2005 developer edition on my
> development system? The computer currently has Visual Studio 2008 and SQL
> Server 2005 express edition on it. As things stand now Visual Studio uses
> the Express edition for projects and web sites. I don't want to screw up my
> current projects. I would like to have access to the Full version of
> Management Studio to work on some remote servers.
>
> What is the consensus of the SQL Server gurus on the best way to do this?
>
> Thanks in advance.
>
> Doug
>
>
>