SQL Server Always on RRS feed

  • Question

  • So there is a small issue of SQL logins when running Alwayson Database.

    I am wondering if I convert the databases to contained DBs if this is supported? Then the SQL logins are no longer an issue?


    Friday, May 10, 2019 3:29 PM

All replies

  • What small issue of SQL logins are you referring to?
    Tuesday, May 14, 2019 1:43 AM
  • The SQL logins are not replicated to the other Always on servers. 

    So if there is a failure of the SQL server the HPC cluster will fail as it will not be able to log in to the other servers.

    but if I convert the DBs to contained DBs, then the HPC servers will be logging into the databases and not the SQL server to access the DBs

    Tuesday, May 14, 2019 2:35 AM
  • It may work but we never test.
    Wednesday, May 15, 2019 2:40 AM