Posts Tagged "Logins"

SQL Server 2012: Always On and SQL Server authentication

Posted by on Sep 4, 2012 in SQL Server, Transact-SQL | 1 comment

SQL Server 2012: Always On and SQL Server authentication

Here is just a small problem I experienced while adding databases with SQL Server authentication enabled (used for some php websites) to an availability group. Steps I took to add the databases: Add all logins to the secondary server (SQL Management Studio > Security > Logins > Create login) Add database to availability group (Always On High Availability > Availability Groups > desired group > Add Database) So the operation was successful and all databases were synchronized. Now I did a manual failover to the second node. But the php application was not able to login...

Read More