Posts Tagged "Always On"

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

Error while running SharePoint 2010 Products Configuration Wizard

Posted by on Aug 7, 2012 in Events, Sharepoint Server, SQL Server | 0 comments

Error while running SharePoint 2010 Products Configuration Wizard

The wizard aborts at about 10% in step 9. Everything I could find in the logs was this here: Unknown SQL Exception 1468 occurred. Additional error information from SQL Server is included below. The operation cannot be performed on database “Sharepoint2010_UsageDB” because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. ALTER DATABASE statement failed. Seems legit to me, since I moved all databases to a SQL Server 2012 Always On...

Read More