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

Disconnecting from a Windows Server 2012 R2 file sharing session on a Windows 7,8,10 machine

Event ID 64,77,1008 Certificates Events Windows Server 2008, 2008R2