2012 r2 rds deployment cannot connect to sql server after reboot


we have ha connection broker setup 2 connection brokers , working fine untill servers rebooted updates. users cannot connect thier collections , have error in event log deployment not connect sql database.

at point assume issue related security. able query database admin effected servers , other services use other databases in same sql instance no5 having issues.

i have checked security group both cb servers should in , in group , group has sysadmin , dbo within sql

any ideas?


please remember mark replies answers if help

hi,

thank posting in windows server forum.

can please create database manually below command , verify.
ps c:\> set-rdconnectionbrokerhighavailability –databaseconnectionstring
 "driver=sql server native client 11.0;server=<sql server
 name>;trusted_connection=yes;app=remote desktop services connection broker;
database=<db name>" -databasefilepath "c:\dbfiles\<dbname>.mdf"
 -clientaccessname "<dns rr name>"

grant dbo permissions service account on rds server , try run wizard again.

more information.
rd connection broker high availability in windows server 2012
http://blogs.msdn.com/b/rds/archive/2012/06/27/rd-connection-broker-high-availability-in-windows-server-2012.aspx

hope helps!

thanks.

dharmesh solanki

technet community support



Windows Server  >  Windows Server 2012 General



Comments

Popular posts from this blog

Error: 0x80073701 when trying to add Print Services Role in Windows 2012 Standard

difference between wuauclt1.exe and wuauclt.exe

Windows 2016 RDS event 1306 Connection Broker Client failed to redirect the user... Error: NULL