none
ZTI error opening SQL Connection

    Question

  • Dear Ladies/Gentlemen,
     
    I am facing one critical issue in my organization. Could you please guide me for that problem?
     
    Here let I explain you
     
    Problem,
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [CSETTINGS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [CPACKAGES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [CAPPS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [CADMINS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [CROLES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [LOCATIONS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [LSETTINGS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [LPACKAGES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [LAPPS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [LADMINS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [LROLES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MMSETTINGS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MMPACKAGES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MMAPPS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MMADMIN] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MMROLES] properties
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [RSETTINGS] properties
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [RPACKAGES] properties
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [RAPPS] properties
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [RADMINS] properties
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MASETTINGS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MAPACKAGES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MAAPPS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MAADMINS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MAROLES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MOAASETTINGS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MOAAPACKAGES] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MOAAAPPS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MOAAADMINS] properties.
     
    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
    Unable to establish database connection using [MOAAROLES] properties.
     
    The network path was not found.
     
    Note:- The script error has taken from BDD Logs
     
    Root Cause,
     
    SQL Related Error,
     
    Solution,
     
    Hi Paul here I gave possible solution but still the problem persist in that location
     
    First,
     
    We have checked that CustomSetting.ini files in Deployment share at GVC Location. Further we ensure that there was no changes made in customsettings.ini script

    Second,
     
    For Bang location they were using mdtuser sql Server authentication credentials for all location. Further we analyzed that credentials having proper security permission to access MDTDB. Finally we ensured that the mdtuser having its proper security permission in BTP Database server. As well as they also able to connect database by using that credential
     
    Third,
     
    We make sure that all SQL services, SQL Network configuration and DNS Settings further we ensure that was working fine
     
    Fourth,
     
    At last we configured a New Database for GVC Location. And we ask them to disable the entire firewall in SQL Server. Still that problem exists.
     

    What could be possible solution please tell from your point of view?

    Thanks in Advance

    Please find the logs and screen-shot from below path

    http://www.mediafire.com/?o53d65s4mtce7q0

    Dinesh Vinay


    Thanks & Regards, Dinesh Sundaram
    Saturday, October 09, 2010 12:29 PM

All replies

  • Have you verified that you can access the server?  When the TS fails try and open a cmd prompt and ping the server resolve by ip or name and see if that is your first problem..
    Brandon Linton |http://myitforum.com/cs2/blogs/brandonlinton/default.aspx | MCTS - SCCM, MDT, AD
    Saturday, October 09, 2010 4:57 PM
  • Hi Brandon,

    I have verified those settings it was fine. Could you please guide me where the exact problem is relies whether in MDT WDS Server or MDT SQL Server. And provide possible solution to try further.

     We have connected three MDT 2010 Servers with one single database server. We are using mdtuser SQL authentication credentials for connecting SQL DB. Even though the problem didn’t happen in two MDT 2010 Servers the deployment going fine in locations. But I am facing problem with one MDT Server at one of the location the deployment completed with several errors


    Thanks & Regards, Dinesh Sundaram
    Sunday, October 10, 2010 12:57 PM