none
Use remote SQL with WSUS under Server 2012

    Frage

  • Hello, I have two VM's, one is the DB server and the second a file server which should run WSUS (both Server 2012).
    When trying to connect to the remote MSSQL 2012, I get this exception:

    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
     

    How can I add the DB server as a trusted domain and is it possible to use SQL Server authentication?

    Montag, 24. Juni 2013 22:13

Antworten

  • When trying to connect to the remote MSSQL 2012, I get this exception:
    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

    Well, the message is exactly what the problem is. I'm not sure I know how to explain it any clearer. Did you read and comply with the installation prerequisites in the Deployment Guide before implementing your remote SQL scenario:

    • When using a remote SQL Server, the front-end (WSUS) server and the back-end (SQL) server must be in the same domain, or have an established domain trust.
    • SQL Authentication is not supported with WSUS, Windows Authentication must be used. (As a matter of fact, Microsoft has not used SQL Authentication with any application since shortly after the Slammer worm in 2003!)

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Donnerstag, 27. Juni 2013 20:51
    Moderator

Alle Antworten

  • No one?
    Mittwoch, 26. Juni 2013 20:30
  • When trying to connect to the remote MSSQL 2012, I get this exception:
    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

    Well, the message is exactly what the problem is. I'm not sure I know how to explain it any clearer. Did you read and comply with the installation prerequisites in the Deployment Guide before implementing your remote SQL scenario:

    • When using a remote SQL Server, the front-end (WSUS) server and the back-end (SQL) server must be in the same domain, or have an established domain trust.
    • SQL Authentication is not supported with WSUS, Windows Authentication must be used. (As a matter of fact, Microsoft has not used SQL Authentication with any application since shortly after the Slammer worm in 2003!)

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Donnerstag, 27. Juni 2013 20:51
    Moderator