Solved

Installing SQL Server 2005 Express as second named instance

Posted on 2007-12-05
3
243 Views
Last Modified: 2010-03-19
Hi

I have SQL server 2005 and wanted to also install SQL Server Express 2005 as a second named instance. I followed notes where part of the wizard allowed you to choose a second named instance,
however there was nothing like that on the wizard for SQL Server 2005 Express, so I changed the installation folder from SQL Server to SQL Server Express. Is this okay?
0
Comment
Question by:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 27

Expert Comment

by:ptjcb
ID: 20414231
Do you have a default instance? I ask because you mention that the SQL 2005 instance is a named instance.
0
 
LVL 8

Accepted Solution

by:
i2mental earned 500 total points
ID: 20414255
SQL Express installs into a named instance called /SQLEXPRESS by default
0
 

Author Comment

by:Murray Brown
ID: 20414272
I installed SQL Server 2005 with Visual Studio 2005 Professional. I am not sure if this is a named instance. Is there a way to check this? I am trying to also install SQL Server 2005 Express. Not quite sure of the terminology as I am new to SQL
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question