Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Install a new instance of SQL Server

Posted on 2009-04-24
7
Medium Priority
?
428 Views
Last Modified: 2012-05-06
I have SQL Server installed on my desktop but for reasons of having to uninstall an old version of SQL Server and Visual Studio, I do not have any instances on the server engine.  i.e. there is no default SQLExpress instance when I open up SQL Server Config Manager.

How do I create a new instance?  I have tried uninstalling/reinstalling but although SQL Server says it successfully reinstalled, there's still no new instance.  How can I do it manually?
0
Comment
Question by:ReinisB
  • 4
  • 3
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24228902
>How do I create a new instance?
during installation, you get asked for a instance name.
you have to specify a different instance name, and there you go.
0
 
LVL 2

Author Comment

by:ReinisB
ID: 24229240
See that's what I thought.  But it doesn't ask me.

I go through the installation and on the Features Selection I have "Instance Features", "Shared Features" and "Redistributable Features" as well as a "Shared Features Directory". I can click on those, but all it has is an explanation.  There's nowhere I can set any name for an instance.

I don't suppose I want to set up a cluster node do I?  I assume not but I thought I would ask anyway.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 24229313
if you install the sql express edition, the instance name is in the setup's config file, which you must edit before starting the setup.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 2

Author Comment

by:ReinisB
ID: 24229340
I see.  It is the express edition.  Do you have any references on how to edit the config?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24229405
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24229409
If you select the Hide advanced configuration options check box, the Service Account, Collation Settings, Instance Name, and User Instances pages do not appear during setup.
0
 
LVL 2

Accepted Solution

by:
ReinisB earned 0 total points
ID: 24233135
I think this page is more what I was looking for http://msdn.microsoft.com/en-us/library/dd239405.aspx for editing 2008 config files.

However in the end I reinstalled VS 2008 with 2005 SQL Server, which then created a new instance.  I can use that same instance with the installed SQL Server 08.

Thanks for the suggestions angelic one.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

581 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