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
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
Post a Comment