![sql server connection string 2012 remote server sql server connection string 2012 remote server](https://blog.citrix24.com/wp-content/uploads/2014/01/psql_1.jpg)
Ensure the "Map" checkbox is checked and that the "User" field has the Connection Brokers Security Group.Click on "User Mapping" in the left-hand menu.Right-click on the Login that was created during the initial HA setup and select Properties.I know that this is an old thread, but I just experienced the same issue and was able to successfully join a second Connection Broker to the deployment by altering the permissions on the database itself via SQL Server Management Studio.Īssuming that the database has already been created and is accessible by the first Connection Broker, the next step is to grant the Connection Brokers security group access to the database. This is the database connection string I am attempting: Double-checked that native client is installed on both servers appears to be installed.Tried creating a blank database of the correct name on the SQL server and ran the HA wizard again no go.Disabled AV on both servers temporarily to test no go.
#Sql server connection string 2012 remote server windows#
Turned off the Windows Firewalls on both servers to test no go.Created an AD group called "RDS Connection Brokers", added the RDS servers, and gave the group dbcreator permissions in SQL server (out of desperation, I also attempted giving the group sysadmin privileges in SQL, but no go).Verified in the SQL Server Configuration manager on both the RDS and the SQL server that TCP/IP is enabled.Installed SQL Server Native Client on the RDS server (ran SQL Server 2014 setup, just installed the features "client tools connectivity" and "SQL client connectivity SDK").So far, this is what I have done and tried (in no particular order): Ensure that the SQL Server is available on the network, the SQL Server Native Client is installed on the RD Connection Broker server, and the RD Connection Broker has write permissions to the database. The database specified in the database connection string is not available from the RD Connection Broker server. I'm trying to follow this guide: and have gotten pretty far, but I'm failing at the Configure RD Connection Broker for HA screen.
![sql server connection string 2012 remote server sql server connection string 2012 remote server](https://filedb.experts-exchange.com/incoming/2008/05_w21/26306/sql-server-remote-connections.jpg)
I have a brand new RDS environment I am trying to set up.