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
Solved

Installing SQL Server 2005 Express as second named instance

Posted on 2007-12-05
3
235 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:murbro
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:murbro
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

840 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