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


install default instance with named instance already installed

Posted on 2006-04-10
Medium Priority
Last Modified: 2012-08-14
i have a 64 bit Ver of sql 2000 installed on a machine that when installed was told to install a named instance, we have swiched to legato networker SQL module for backup nad it needs a default instance to work, how do i install a default instance when a named instance exists??
Question by:Cecilpierce
  • 4
  • 2
LVL 11

Expert Comment

ID: 16422630
local should be the default instance on that server even if it has been named

Author Comment

ID: 16422642
all it shows is  servername\instance i am not a sql guru bu it does not show local at the top

Author Comment

ID: 16422646
at the time of install named instance was selected not default
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

LVL 21

Expert Comment

ID: 16427566
I don't think 64 bit makes a difference....

Drop in the CD, or re-run the setup and just choose default at the appropriate screen.  If the option is not available, you already have one.  Verify this by looking for a MSSQLServer service in your services applet from control panel.  You should see MSSQLServer$whatever for your named instance(s)

Author Comment

ID: 16427948
am i correct in thinking it will install the default instance in a differnt directory that the named instance?
LVL 21

Accepted Solution

Kevin3NF earned 2000 total points
ID: 16428416
yes...each instance gets its own copies of the various .exe s and .dlls

Author Comment

ID: 16428432
thats what i whanted to know:) you win

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

In this article, we’ll look at how to deploy ProxySQL.
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

580 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