Solved

Installing SQL Server 2005 Express as second named instance

Posted on 2007-12-05
3
210 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now