none
"ZTI error opening SQL Connection" RRS feed

  • Question

  • Hello,

    I am sorry if this issue has been beaten to death.  However, I have spent hours trying to figure out why I still keep getting this error.  I have setup WDS, MDT and SQL Express on a single virtual box.  I have disabled the firewall completely and given the DeploymentShare$ folder permissions to everyone for testing.  I have done a complete rebuild of the WIM file and updated it in WDS but I keep getting this error message at the end of the OS deployment on the client system.  Any help would be GREATLY appreciated!

    I tried to post the picture but it says my account is not "verified".

    Error message = "ZTI error opening SQL Connection:  Cannot open database "MDT" requested by the login.  The login failed (-2147467259)

    Unable to establish database connection using [CSETTINGS] properties.

    ...it continues to do this for all the role properties on the database.

    Current Rules on the Deployment Share are:

    [Settings]
    Priority=CSettings, CPackages, CApps, CAdmins, CRoles, Locations, LSettings, LPackages, LApps, LAdmins, LRoles, RSettings, RPackages, RApps, RAdmins, MMSettings, MMPackages, MMApps, MMAdmins, MMRoles, Default
    Properties=MyCustomProperty

    [Default]
    EventService=http://WDS:9800



    [MMSettings]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelSettings
    Parameters=Make, Model

    [MMPackages]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelPackages
    Parameters=Make, Model
    Order=Sequence

    [MMApps]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelApplications
    Parameters=Make, Model
    Order=Sequence

    [MMAdmins]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelAdministrators
    Parameters=Make, Model

    [MMRoles]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelRoles
    Parameters=Make, Model

    [CSettings]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerSettings
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CPackages]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerPackages
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CApps]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerApplications
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CAdmins]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerAdministrators
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CRoles]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerRoles
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [Locations]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=Locations
    Parameters=DefaultGateway

    [LSettings]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationSettings
    Parameters=DefaultGateway

    [LPackages]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationPackages
    Parameters=DefaultGateway
    Order=Sequence

    [LApps]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationApplications
    Parameters=DefaultGateway
    Order=Sequence

    [LAdmins]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationAdministrators
    Parameters=DefaultGateway

    [LRoles]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationRoles
    Parameters=DefaultGateway

    [RSettings]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RoleSettings
    Parameters=Role

    [RPackages]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RolePackages
    Parameters=Role
    Order=Sequence

    [RApps]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RoleApplications
    Parameters=Role
    Order=Sequence

    [RAdmins]
    SQLServer=WDS
    Instance=SQLEXPRESS
    Database=MDT
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RoleAdministrators
    Parameters=Role


    Bootstrap.ini settings are:

    [Settings]
    Priority=Default

    [Default]
    DeployRoot=\\WDS\DeploymentShare$
    UserDomain=xxxxx.LOCAL
    UserID=xxxxx
    UserPassword=xxxxxx


    Monday, July 4, 2016 9:57 PM

All replies

  • Hello Travis,

    Have you made sure named pipes is enabled under protocols for the SQL server from SQL Server configuration manager? Is SQL Server Browser service running and set for automatic startup?

    http://www.vkernel.ro/blog/creating-and-configuring-the-mdt-database

    Cheers,

    dlofstedt

    Tuesday, July 5, 2016 10:45 PM