I'm configuring TFS 2012 in advanced mode, that means that Sql Server is on another machine. When I need to specify the database server (in the TFS Configuration) it fails because the SqlServer host is unreachable.
TFS255049: A connection cannot be made to the server that is running SQL Server. Verify that you have entered the correct name for the server, including the instance name, that the server you are attempting to connect to is online, and that you have the required persomissions to connect. If you are attempting to connect to the remote SQL Server instance, then verify that it is configured to allow remote connections, that TCP/IP protocol is both enabled and configured to use port 1433 (default), and that Windows Firewall does not block this port.
Also, when I ping to
databaseserver, the ping fails.
But if I remove the databaseserver from the domain, then the configuration doesn't fail in that step (the databaseserver is accesible) but, obviously, it fail in next steps (because the of account that is needed to authenticate to SqlServer, databaseserver MUST be joined to the domain).
What am I missing?
The gpresult file looks like this (it's in spanish, hope it won't be a problem...)
Denied GPOs Default Domain Policy Ubicación de vínculo pinard.local Extensiones configuradas Exigido No Deshabilitado Ninguno Filtros de seguridad NT AUTHORITY\Usuarios autentificados Revisión AD (0), SYSVOL (0) Filtro WMI Causa denegada Vacío Local Group Policy Ubicación de vínculo Local Extensiones configuradas Exigido No Deshabilitado Ninguno Filtros de seguridad Revisión AD (0), SYSVOL (0) Filtro WMI Causa denegada Vacío