all groups > sql server new users > august 2005 >
You're in the

sql server new users

group:

SQL Server 2005 and SQL Express


SQL Server 2005 and SQL Express Don Tucker
8/30/2005 2:55:03 PM
sql server new users:
I have recently installed SQL Server 2005 on a server running Windows Server
2003. I subsequently installed Visual Studio, which installed SQL Server
2005 Express Edition CTP. I am concerned that the Express Edition might
interfere with the regular SQL Server. Are there application notes to which
I can refer to see if there might be a conflict, or should I just uninstall
Express to be safe?

Re: SQL Server 2005 and SQL Express Gail Erickson [MS]
8/30/2005 3:40:01 PM
This is best asked on the SQL 2005 newsgroup.

http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

[quoted text, click to view]

Re: SQL Server 2005 and SQL Express Lou Vogel
10/4/2005 4:39:01 PM
Gail, when I click on the link you gave (as many others seem to give in this
batch of "newgroups", I get routed to a general overview page and when I
click on the SQL Express 2005 CTP link on that page I am in a loop. So, for
me, telling me to go look at that is extremely useless. I accept it may be
my problem but this whole sequence of screens isn't really telling me how to
find the information I need.

[quoted text, click to view]
Re: SQL Server 2005 and SQL Express Lou Vogel
10/4/2005 7:31:53 PM
Mike, Thank you very much. That was an excellent response and very helpful.

I am trying to uninstall a version of SQL Express so I can install another
one...but I cannot install a new one or uninstall the old one. I know that
detailed question is off topic to his group, and you have helped me find a
path to the right place where I saw pointers that didn't go where they said.

Thanks again.

[quoted text, click to view]
Re: SQL Server 2005 and SQL Express Mike Hodgson
10/5/2005 12:00:00 AM
Yeah, the SQL 2005 newsgroup links on Microsoft's communities webpages
don't seem to be going where they ought to. If you've got a NNTP news
reader (like Mozilla Thunderbird <http://www.mozilla.org/> or Microsoft
Outlook Express, included in recent versions of Internet Explorer
<http://www.microsoft.com/windows/ie/default.mspx>) you can just get the
news feeds straight from Microsoft's private news server
(news://privatenews.microsoft.com) and subscribe to the appropriate SQL
2005 newsgroups (I think the username/password for the MS private news
server are private/private off the top of my head).

That said, SQL Server 2005 Express Edition can happily run on the same
box as other instances of SQL Server 2005 (be they Express Edition or
one of the other editions like Workgroup, Standard, Enterprise, etc.).
Microsoft's SQL 2005 website is here
<http://www.microsoft.com/sql/2005/default.mspx>. I haven't been
through the whole thing but there are various links that may be helpful
to you (like whitepapers, etc.).

However, if it was me and I knew I already had another SQL 2005 instance
on the box, I would uninstall the Express Edition instance because,
assuming it's just a local dev box, there's no need to have 2 instances
(just more management overhead) - you can just as easily create DBs &
manipulate data on your existing Yukon instance. There may be a few
minor differences between your Express instance and your other instance
depending on which beta/CTP each instance is (it is still beta software
after all), but to start developing with Visual Studio any of the later
CTPs should be fine.

--
*mike hodgson*
blog: http://sqlnerd.blogspot.com



[quoted text, click to view]
AddThis Social Bookmark Button