P
phantom1122
Hey all!
We have a 2 node failover cluster running SQL2008R2, on there i created a instance for my 2 server 2012 connection brokers.
When i try to configure HA on the connection brokers is get the following error in the HA Wizard:
Database Creation - Failed: Could not create the database 'RDSFARM01'.
The log files also show the following error:
The Remote Desktop Connection Broker server could not install the database named RDSFARM01 by using the connection string:
DRIVER=SQL Server Native Client 10.0;SERVER=SQLCL01R05\RDS;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=master.
The database name in the connection string is shown as [master] because in order to create a new database with admin specified name, a connection must be made to master database.
Both nodes have DB Creator and DB Admin rights on the SQL Instance.
When i install a single node SQL2012 instance is works, but i need SQL2008r2 for another application.
I tried connecting to the database with a .udl file, this works perfect and when i select the Master database and hit connection is comes back with "Connection Successfull"
I been looking arround on google and Technet forums but can't find any solution, i hope someone can help me over here.
Thanks!
Best Regards,
Robin
Continue reading...
We have a 2 node failover cluster running SQL2008R2, on there i created a instance for my 2 server 2012 connection brokers.
When i try to configure HA on the connection brokers is get the following error in the HA Wizard:
Database Creation - Failed: Could not create the database 'RDSFARM01'.
The log files also show the following error:
The Remote Desktop Connection Broker server could not install the database named RDSFARM01 by using the connection string:
DRIVER=SQL Server Native Client 10.0;SERVER=SQLCL01R05\RDS;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=master.
The database name in the connection string is shown as [master] because in order to create a new database with admin specified name, a connection must be made to master database.
Both nodes have DB Creator and DB Admin rights on the SQL Instance.
When i install a single node SQL2012 instance is works, but i need SQL2008r2 for another application.
I tried connecting to the database with a .udl file, this works perfect and when i select the Master database and hit connection is comes back with "Connection Successfull"
I been looking arround on google and Technet forums but can't find any solution, i hope someone can help me over here.
Thanks!
Best Regards,
Robin
Continue reading...