none
Troubleshoot TCP/IP access to MDT database

    Question

  • Using SCCM with MDT 2010.1. Have created the database. The client does not use named pipes so I am trying to use TCP/IP authentication but not working

    So I have got the client to create me a SQL login which they've done with DBW rights to the MDT database

    I've also create a share MDT2010 and shared out as MDT2010$

    Have added DBID and DBPwd entries into customsettings.ini to authenticate but to no avail

    How can I troubleshoot why SCCM cannot connect to the MDT database?

    Thanks


    Ian Burnell, London (UK)

    Tuesday, February 12, 2013 1:12 PM

Answers

  • It was a permissions issue. Although account had DB write access I had to also add DB read to get it to work

    Thanks


    Ian Burnell, London (UK)

    • Marked as answer by Ian Burnell Wednesday, February 13, 2013 2:07 PM
    Wednesday, February 13, 2013 2:07 PM

All replies

  • Within your CS.ini and Boot.ini try changing the Deploymentshare$ to the servers IP (i.e.)

    \\10.10.10.10\Deploymentshare$

    In your CS.ini define the SQL share as well:

    [CSettings]
    SQLServer=PC-MDT-B
    Instance=SQLEXPRESS
    Database=MDT2012
    DBID=mdt2012
    DBPWD=password
    Netlib=DBMSSOCN
    Table=ComputerSettings
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    SQLShare=DeploymentShare$

    -Biggy

    Tuesday, February 12, 2013 8:26 PM
  • It was a permissions issue. Although account had DB write access I had to also add DB read to get it to work

    Thanks


    Ian Burnell, London (UK)

    • Marked as answer by Ian Burnell Wednesday, February 13, 2013 2:07 PM
    Wednesday, February 13, 2013 2:07 PM
  • More for my personal interest was the local account you created in SQL not a DB owner to begin with or do you only grant read/write roles permission?

    -Biggy

    Wednesday, February 13, 2013 2:21 PM