How to find if SQL 2008 has been installed with default instance or named instance.

Hi
I have 2008 SQL server installed on 2003 server. I am now going to migrate the Database to a new SQL 2012 server that I am going to install.

Firstly: Is there a way to find if the old SQL server was installed with Named instance or default instance.
If it is named instance , how do I find the instances names.

Secondly: I am installing SQL Server 2012 64bit version on a windows 2012R2 64bit, during the
Feature selection windows and Shared feature directory.
It gives me a default path as shown below.
Shared Feature Directory:  C:\Program Files\Microsoft SQL Server\
Shared Feature Directory(x86): C:\Program Files(x86)\Microsoft SQL Server\

But I am going to install it on D drive.
(Path 1) So my path will be
Shared Feature Directory:  D:\Program Files\Microsoft SQL Server\
Shared Feature Directory(x86): D:\Program Files(x86)\Microsoft SQL Server\

(Path 2)
I noticed some videos that they change the Shared feature Directory path as
Shared Feature Directory:  D:\Microsoft SQL Server\
Shared Feature Directory(x86): D:\Program Files\Microsoft SQL Server\

For Best practice ,If I select D: for the shared feature, do in need to give the path as per path 1 or 2
Does the Program files(x86) path really matter as I am installing the 64bit version 0f SQL.

Please suggest any help much appreciated!
lianne143Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EvilKnievelCommented:
Hi,
You can check the services on your server to see if SQL is a default or named instance. In case of a default instance you will only see the SQL service registered as something like MSSQLSERVICE. In case of a named instance, the instance name will be added to the service name like this: MSSQLSERVICE (instance name)

For your second question, i would only change the drive letter from C: to D: in the installation windows, that way it will Always be clear where the 32 bit and 64 bit components are.

Hope this helps you out a bit.
0
lianne143Author Commented:
So for my understanding do I need to leave it as

Shared Feature Directory:  D:\Program Files\Microsoft SQL Server\
Shared Feature Directory(x86): D:\Program Files(x86)\Microsoft SQL Server\

 OR

Shared Feature Directory:  D:\Microsoft SQL Server\
Shared Feature Directory(x86): D:\Program Files\Microsoft SQL Server\
0
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
To find if you have installed SQL as an instance, start SQL Server Management Studio and click on browse.  If SQL servers are found in the form of servername\instancename then it is not default install.  You could also look at services as mentioned above.

With respect to file locations, SQL server by default installs shared files used by all instances in one location and once a new instance is installed, instance specific files will be installed in a different location.
0
EvilKnievelCommented:
For the file location i would keep it like this:
Shared Feature Directory:  D:\Program Files\Microsoft SQL Server\
Shared Feature Directory(x86): D:\Program Files(x86)\Microsoft SQL Server\
But that's just me ;)
It doesn't really matter where you install the shared features, as long as the 32 and 64 bit components aren't in the same folder.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.