[dba-SQLServer] dba-SQLServer Digest, Vol 76, Issue 14

Doug Murphy dw-murphy at cox.net
Sat Jun 27 18:42:03 CDT 2009


Folks,

I am following up on this thread just to pass on my experience. I attempted
to install SQL Server 2005 standard on my development machine that already
has SQL Server 2005 Express on it. There is a conflict and the installer
won't put anything on my machine, apparently because the Express components
are newer than the Standard edition. After querying Stack Overflow and some
SQL Server groups this seems to be a known situation and the consensus is to
take Express off the machine. I could do this but then I'd have to go back
and modify all my apps and sites connection strings. Beging a coward and
lazy, why break something that runs, I set up an Windows 2008 Server virtual
machine and installed SQL server on that. SQL Server 2005 on Windows server
2008 has it's own set of issues, compatibility mostly, but they are known
and can be worked through. I have it up and running and can work on the
remote server through management studio which was my objective. Another 4
hours setting something up that should be simple.

Doug 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Friday, June 19, 2009 1:19 PM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] dba-SQLServer Digest, Vol 76, Issue 14

Hi Dave,

Thanks for the insight. The only projects I really have on this machine that
use SQL server are some Visual Studio applications and several ASP.NET
sites. They all are using my SQL Express server now. I can redo the
connection strings but would preffer not to if Express and the full version
are compatible on the same machine.

Doug 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David Lewis
Sent: Friday, June 19, 2009 11:05 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] dba-SQLServer Digest, Vol 76, Issue 14


Doug:  Coincidentally I just upgraded my management studio from 2000 to 2008
yesterday.  I had sqlprompt (from Redgate) installed, and that caused the
install to bonk.  There is a patch they've issued to allow the install to
proceed although I hacked around it by renaming a registry key temporarily.
Details on that via google.
But more importantly, I found after the upgrade that some ssis packages
broke.  Thankfully they were still in dev stage.  I don't remember all the
things that went wrong, but some of them were relative paths in script tasks
no longer worked (had to change to absolute paths), and some db connections
just plain broke.  hth.  d lewis

Message: 3
Date: Fri, 19 Jun 2009 09:33:19 -0400
From: James Barash <james at fcidms.com>
Subject: Re: [dba-SQLServer] Installing SQL Server 2005 developer on a
        machine with SQL Server 2005 express edition
To: Discussion concerning MS SQL Server
        <dba-sqlserver at databaseadvisors.com>
Message-ID:
        <12D2F894654B53498DEF840AE12B7BB3115C0933 at fciexchange.fcidms.com>
Content-Type: text/plain; charset="us-ascii"

Doug:

If you just need the Management Studio, you can install that by itself,
without installing an instance of SQL Server 2005. I've done that with
Management Studio 2008. As I recall, you start the installation and just
select the Client Tools and make sure to deselect everything else. I also
have the Developer and Express editions on my desktop and they run together
without any problems. You just need to install the second version as a named
instance. Although I usually shut down the one I'm not using to save memory.

James Barash

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Thursday, June 18, 2009 2:32 PM
To: 'Discussion concerning MS SQL Server'
Subject: [dba-SQLServer] Installing SQL Server 2005 developer on a machine
with SQL Server 2005 express edition

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


The contents of this e-mail message and its attachments are covered by the
Electronic Communications Privacy Act (18 U.S.C. 2510-2521) and are intended
solely for the addressee(s) hereof. If you are not the named recipient, or
the employee or agent responsible for delivering the message to the intended
recipient, or if this message has been addressed to you in error, you are
directed not to read, disclose, reproduce, distribute, disseminate or
otherwise use this transmission.  If you have received this communication in
error, please notify us immediately by return e-mail or by telephone,
530-893-3520, and delete and/or destroy all copies of the message
immediately.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list