472,790 Members | 1,451 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,790 software developers and data experts.

SQL Server 2005 + SQL Server Express

I have SQL Server 2005 installed on my dev system. I am working on an
app that i would like to distribute SQL Server with. SQL Server
EXpress edition seem to be ideal for this. My questions are:

-If i installed Express Edition, Can both SQL Server 2005 and Express
Edition coincide peacefully on the same PC?

-Which one will Visual Studio see? (currently i created by database
using VS, which i assumed created a SQL Server 2005 database, since
that is the sql server i have installed).

-When VS2005 is installed, which SQL Server is installed and how can i
tell which one VS2005 is using if i have both SQL servers (2005 and
Express) installed?

thanks much

Aug 8 '06 #1
2 1618
farseer (fa*****@optonline.net) writes:
-If i installed Express Edition, Can both SQL Server 2005 and Express
Edition coincide peacefully on the same PC?
Yes. SQL Server permits multiple instances being installed on the same
server, and this can be multiple instance of Express Edition, multiple
instance of, say, Enterprise Edition, or any mix thereof.

Furthermore, to prevent collisions, SQL Express installs by default as
a named instance, \SQLEXPRESS whereas other editions of SQL Server by
default installs as default instances, which do not have any extra
-Which one will Visual Studio see?
The one you point it to. I assume here that you mean the database that
you connect to for development purposes.

Some parts of VS like the compoent in Team System for Database
development uses the Express instance for its own storage.
-When VS2005 is installed, which SQL Server is installed and how can i
tell which one VS2005 is using if i have both SQL servers (2005 and
Express) installed?
That is in the, eh, is it called Server Explorer? And you can work with
muiltiple servers.

Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Aug 8 '06 #2
Thank you..

Aug 10 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Chris | last post by:
If i've installed SQL Server 2005 Developer, when I come to install VS 2005 is there any need to install SQL Server Express? I would have thought the install would have detected SQL Server...
by: Darryl Kerkeslager | last post by:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp SQL Server Express was developed with two distinct uses in mind. The first is as a server product,...
by: Peter | last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server 2005 Express, but get the following error in the error log. Please could someone help me.... Microsoft SQL Server 2005...
by: Jeremy S. | last post by:
I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean development machine (XP Pro/SP2 etc). Is the order of installation important (i.e., which product should I install first)? ...
by: amjad | last post by:
how to connection sql server table with aspx like pulling data from table to grid view.... simple example to start .... thanks
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
by: kress1963nov22 | last post by:
I recently purchased a good MS book ("Build a Web Site Now") by Jim Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on CD and also MS SQL Server 2005 Express Edition on the CD. A...
by: leonaisse | last post by:
Hi I have a bunch on tables and data in my local SQL Server 2005 Express master DB and I want to export it to a database.mdf within my wwwroot (visual studio) file - how can i do this? Thanks...
by: Steve | last post by:
Hi All I downloaded Sql server 2005 express SP2 and attempted to modify the Bootstrapper package files as I did with SP1 When i try to install SQL server as part of my VS 2005 deployment app I...
by: samadams_2006 | last post by:
Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express...
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.