locked
SCCM 2012 SP1 Installation Issue RRS feed

  • Question

  • I have a Domain Controller(Windows Server 2008 R2) which also has SQL Server 2008 R2 in it. I tried installing SCCM 2012 SP1 on Windows 2012 Datacenter, but getting a below message.

    "setup has detected that there is not an NTFS drive on the remote SQL server, the SQL server must have at least one NTFS drive"

    My SQL server service is running with Domain\Administrator account.

    Could someone give me a solution to fix this issue?

    Advance thanks

    Siva


    SK

    Saturday, March 9, 2013 12:41 AM

Answers

All replies

  • @Sivakrish - First check if you can remotely connect to the \\SERVERNAME\<DRIVELETTER>$?

    Disable admin shares on SQL server and enable it. Restart SQL and SCCM server once. The issue should be fixed.


    Prajwal Desai http://PrajwalDesai.Com

    Saturday, March 9, 2013 3:35 AM
  • you need to ensure that the site server computer account is member of the local administrator Group, also the installation account should be a local administrator and sysadmin.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals

    • Proposed as answer by grundlichkeit Saturday, March 9, 2013 11:54 AM
    • Marked as answer by Garth JonesMVP Tuesday, October 27, 2015 4:37 PM
    Saturday, March 9, 2013 10:02 AM
  • I have the following, but still it is not working

    1. I can connection to \\Server name\<Drive Letter> $

    2. Disabled and Enabled Admin$ on the Domain controller

    3. I have tried installing using Domain\Administrator and Domain\User Account(Member of Administrators group in the domain controller)

    Any other ideas?


    SK

    Saturday, March 9, 2013 8:08 PM
  • The computer account of the site server has to be member of the domain admins group in your scenario. Make sure to reboot it after you added it to the group.
    It's not the best idea to place a SQL server on a domain controller.

    Torsten Meringer | http://www.mssccmfaq.de


    Monday, March 11, 2013 7:28 AM
  • I am still getting "setup has detected that there is not an NTFS drive on the remote SQL server, the SQL server must have at least one NTFS drive". Following is the summary:

    My SCCM User Account has following

    1. Member of Domain Admins group

    2. SysAdmin Role in the SQL Server database

    3. "System Management" container full access

    The Member Server computer name has following:

    1. Member of Administrators group in the Domain Controller

    2. SysAdmin Role in the SQL Server database

    3. "System Management" container full access

    My Domain Controller(SQL Server is installed on it) has all drives partitioned in NTFS.

    Server Environment:

    Domain Controller: Windows Server 2008 R2 SP1

    SQL Server: SQL Server 2008 R2 - 10.50.4000

    SCCM: SCCM 2012 SP1

    What else I am missing here?


    SK

    Tuesday, March 12, 2013 2:32 PM
  • I am able fix this issue by using the DNS as servername.FQDN

    I have another issue now. The setup is failing on BCP batch. following is the error.

    BCP fails due to internal SQL. Check if this table has a trigger failed to execute
    Failed to send batched rows.
    Failed to import data to table LU_SoftwareHash
    Failed to import data from CSV files
    Failed to import asset intelligence data into the site database

    Any help is appreciated.


    SK

    Wednesday, April 10, 2013 8:14 PM
  • Install SQL local on the site server not on the domain controller. Do it right first time and you will save a lot of trouble down the road

    Kevin Case | My blog www.sccmroad.wordpress.com/ Twitter: @casekev | | Please mark as helpful/answer if this resolved your issue

    Wednesday, April 10, 2013 8:46 PM