Hello I'm not being able to install RD Connection Broker with High Availability.
The RDS deployment consists on two servers running win2012
server1 - RDWA and RDG
server2 - RDSH and RDCB
The SQL server 2012 that I'm using is installed on server2 itself and had to be installed after the RDS otherwise the SQL installation failed and had to be done using the RD-install. It's working fine , I've applications that run on it.
As when configuring RDCB HA "both" RDCB hosts access directly to the SQL DB to create a new database, their accounts need to be authenticated as a SQL login with dbcreator role.
1 step: I checked a straight forward installation_
2 step: I checked an installation where my problem happened.
I checked RD Connection Broker HA – SQL Permissions
Added the host to a domain group and added the group as an SQL login, SQL authentication failed.
4 step: Google for how to create SQL login for a computer account and I added it by executing:
“CREATE LOGIN [MyDomain\MyComputer$] FROM WINDOWS”
Also tried to use Add-ADcomputerServiceAccount without success.
3 step: I ended here
Where I verified that none of the following explanations were correct:
- The SQL Server Native client is not installed
- A firewall is blocking SQL Access from the RD Connection Broker (port 1433)
- The incorrect SQL Server Native Client version is specified
- An incorrect SQL Server name is specified
I tried several variations of the string to use but this is the one I think it's correct:
DRIVER=SQL Server Native Client 11.0;SERVER=WIN2012-1;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=RDCB
The error registered on SQL is:
Login failed for user 'RDS\WIN2012-1$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]"
I tried to connect via ODBC with an existing username an it succeeded.
The problem seems to be with the computer account not existing as an SQL login...the thing is that it exists.
I need to set this up in order to be able to change the RDCB FQDN to a public FQDN.
How were you guys able to overcome this? Did you faced this at all?
I think it absolutely does not work --- Remote Desktop Connection Broker High Availability
DRIVER=SQL Server Native Client 11.0;SERVER=WIN2012-1;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=RDCB, after this screen
Im create sql database. Database created, starting to work in single-user mode... DAMN It.