Doug Murphy
dw-murphy at cox.net
Thu Jun 18 18:09:57 CDT 2009
Thanks Bill -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten Sent: Thursday, June 18, 2009 2:48 PM To: Access Developers discussion and problem solving Subject: Re: [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 > > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com