Solved

RD Connection Broker for High Availability could not create database error

Posted on 2015-01-29
10
555 Views
Last Modified: 2015-02-06
Server Manager, Remote Desktop Service, RD Connection Broker, Configure High Availability

Configure:
- Database connection string:
- Folder to Store Database Files:
- DNS Round Robin Name

Goes to the next screen nothing above fails at this point. Hit next and get the following error:
Configure RD
0
Comment
Question by:WORKS2011
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 40579116
does the database server have tcpip/named pipes enabled?  (sql configuration manager) does that account have login properties?
0
 
LVL 24

Expert Comment

by:VB ITS
ID: 40579122
Are you trying to connect to remote SQL server? Please provide the DB connection string just as well or at the very least the syntax you are using.

Have you confirmed that you have met all the prerequisites for High Availability for the RD Connection Broker role?

Taken from this following Microsoft blog post: http://social.technet.microsoft.com/wiki/contents/articles/10390.deploying-rd-connection-broker-high-availability-in-windows-server-2012.aspx
- A Microsoft SQL Server with write permissions granted to all RD Connection Broker servers that will be part of the deployment
- The Microsoft SQL Server Native Client is installed on all RD Connection Broker servers that will be part of the deployment
- Static IP addresses have been assigned to all RD Connection Broker servers that will be part of the deployment
- DNS resource records with a single DNS name have been created for all RD Connection Broker servers that will be part of the deployment
- Also note that the SQL Server must be at least SQL Server 2008 R2.
Also make sure that your SQL permissions and firewall is configured correctly: http://social.technet.microsoft.com/wiki/contents/articles/10393.rd-connection-broker-ha-sql-permissions.aspx
0
 
LVL 17

Author Comment

by:WORKS2011
ID: 40579401
Hi VB ITS, I've done everything in the documentation you mentioned.

It's interesting I didn't pass the following at first:  Configure: Database connection string, Folder to Store Database Files, DNS Round Robin Name until I removed SQL completely and reinstalled.

After doing so I can now get past the above screen but it fails with the screen shot.

Seems like something with SQL to me.
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40579930
There's no error log? Or at least an entry in the Event log?
That error message is too generic and we need to get something more to point you to the right direction.
0
 
LVL 24

Expert Comment

by:VB ITS
ID: 40580038
You'll need to provide more information as Vitor has mentioned above. Can you please at least confirm that you have a dedicated SQL server running at minimum SQL Server 2008 R2?

Have you verified that your environment meets the minimum requirements outlined in my previous comment?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 17

Author Comment

by:WORKS2011
ID: 40580214
Yes all the requirements are met and tried SQL Server 2008 and 2012 R2.
0
 
LVL 17

Author Comment

by:WORKS2011
ID: 40580228
Dell support has been working on it for hours, appears it may be something in the registry and at this point a fresh install is likely the way to go. The server was taken out of the box four days ago, it's this new and nothing is on it. Problem is we really need the remote access.

Others have had this problem with the same results (not allot of information reporting back). Others that had this problem didn't report a solid way to fix which doesn't help much. When I say "Others" I mean the few posts I found.
0
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 40582349
it shouldn't be creating a database mssqlserver but a database ON servername\mssqlserver. This is the default instance, if you changed the instance name then it would be server\instancename
0
 
LVL 17

Accepted Solution

by:
WORKS2011 earned 0 total points
ID: 40582941
Hi David, understand and tried all these things. Found there was something in the NIC and registry that was causing an issue.
0
 
LVL 17

Author Closing Comment

by:WORKS2011
ID: 40593228
Thank you for all the help, greatly appreciated.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Resolve DNS query failed errors for Exchange
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now