How to find if SQL 2008 has been installed with default instance or named instance.
Posted on 2014-07-16
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\
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!