Posts made in September, 2012

Strange behavior with Data Protection Manager End User Recovery feature or not?

Posted by on Sep 14, 2012 in Data Protection Manager | 1 comment

Strange behavior with Data Protection Manager End User Recovery feature or not?

I recently activated the End User Recovery feature of Data Protection Manager 2012. I did the schema extension – which by the way added a ms-BackupSrv-Share attribute a ms-ProductionSrv-Share attribute a ms-SrvShareMapping class and a MS-ShareMapConfiguration container to my Active Directory. We’ll come back later to this… I also enabled EUR in DPM itself (Options > End-user Recovery). In the first few days this feature seemed to work really well and I was happy in the first place. But now, about 3 or 4 weeks later, I am experiencing some strange behavior. When looking...

Read More

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