locked
My client wants completely sql server 2008 in D:\ RRS feed

  • Question

  • Why SQL Server 2008 is not completely installing in d:\

    Some part is automatically installing in C:\

    My client wants completely in D:\

    Please help Urgent.


    "SQLSERVER DBA" "INDIA"
    Wednesday, January 12, 2011 6:56 AM

Answers

  • Its documented
    http://msdn.microsoft.com/en-us/library/ms143547(v=SQL.100).aspx 

    {
    Common files used by all instances on a single computer are installed in the folder <drive>:\Program Files\Microsoft SQL Server\100\, where <drive> is the drive letter where components are installed. Normally this is drive C.
    }

    Do you already have any SQL instance installed?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by Sudeepta Ganguly Wednesday, January 12, 2011 7:40 AM
    • Marked as answer by WeiLin Qiao Friday, January 21, 2011 11:49 AM
    Wednesday, January 12, 2011 7:04 AM

All replies

  • Why SQL Server 2008 is not completely installing in d:\

    Some part is automatically installing in C:\

    My client wants completely in D:\

    Please help Urgent.


    "SQLSERVER DBA" "INDIA"
    • Merged by WeiLin Qiao Friday, January 14, 2011 11:37 AM duplicate thread
    Wednesday, January 12, 2011 6:55 AM
  • Its documented
    http://msdn.microsoft.com/en-us/library/ms143547(v=SQL.100).aspx 

    {
    Common files used by all instances on a single computer are installed in the folder <drive>:\Program Files\Microsoft SQL Server\100\, where <drive> is the drive letter where components are installed. Normally this is drive C.
    }

    Do you already have any SQL instance installed?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by Sudeepta Ganguly Wednesday, January 12, 2011 7:40 AM
    • Marked as answer by WeiLin Qiao Friday, January 21, 2011 11:49 AM
    Wednesday, January 12, 2011 7:04 AM
  • Avoid duplicate posts
    http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/56482448-006e-41b8-922c-92d58e2eae10
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, January 12, 2011 7:05 AM
  • Thanks to response..

    Do you already have any SQL instance installed?

    Answer: No and I have installed the SQL Server as default on a fresh machine.

    If I am removing the content of C:\program files\Microsoft SQL Server after installing it in D:\ drive.

    The SQL Service is not starting and giving error:

    Error:1053 The Serivce did not respond to the start or control request in timely faishion.

    Is it never possible that SQL Server 2008 installed completely on D:\drive?

    In previous versions this was not happen.


    "SQLSERVER DBA" "INDIA"
    Wednesday, January 12, 2011 7:24 AM
  • Well, you should not do that, those are shared components, and its required for SQL Server operation. If you install it on your D; drive, then too, as Balmukund said earlier, shared components are normally placed on the C:\Program Files\XX
    SKG: Please Marked as Answered, if it resolves your issue.
    Wednesday, January 12, 2011 7:40 AM
  • If I am removing the content of C:\program files\Microsoft SQL Server after installing it in D:\ drive.
    You should not do that. As per link which I mentioned

    Shared Files for All Instances of SQL Server
    "
    Common files used by all instances on a single computer are installed in the folder <drive>:\Program Files\Microsoft SQL Server\100\, where <drive> is the drive letter where components are installed. Normally this is drive C.
    "

    I am not 100% sure by CommonFilesDir is the key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion which is used to install those components

    I don't know impact of changing the key.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, January 12, 2011 7:50 AM