T
Thuizt
Hi,
Setting up RDS HA Connection broker but not succesfull.
Not much left that I haven't searched and read but my installation Cannot create the database. The error is: Check brokerservice has acccess to SQL en path for databases exist. Connection to SQL is correct. Tried with SQL 2014 and 2017
Eventlog RDMS-UI on RDHost gives error with eventid 32776. This indicates a access issue. Added network Service but to no avail. Connection Brokers are group members and that group has DBCreate (and many more) rights.
Setup is two RDS hosts with Connection broker and dedicated SQL server.
Creating and dropping database with SQLCMD from the broker is successfull
ODBC test is succesfull.
SQL server logs gives no errors.
Tried with Server client 11 and 13
Documentation is mostly about 2012 but seems not much different from 2016
At the moment I'm out of options. Who has ???
Continue reading...
Setting up RDS HA Connection broker but not succesfull.
Not much left that I haven't searched and read but my installation Cannot create the database. The error is: Check brokerservice has acccess to SQL en path for databases exist. Connection to SQL is correct. Tried with SQL 2014 and 2017
Eventlog RDMS-UI on RDHost gives error with eventid 32776. This indicates a access issue. Added network Service but to no avail. Connection Brokers are group members and that group has DBCreate (and many more) rights.
Setup is two RDS hosts with Connection broker and dedicated SQL server.
Creating and dropping database with SQLCMD from the broker is successfull
ODBC test is succesfull.
SQL server logs gives no errors.
Tried with Server client 11 and 13
Documentation is mostly about 2012 but seems not much different from 2016
At the moment I'm out of options. Who has ???
Continue reading...