Introduction You can move the report server databases that are used in an installation SQL Server Database Engine to an instance that is on a different computer. Both the reportserver and reportservertempdb databases must be moved or copied together. A Reporting Services installation requires both databases; the reportservertempdb database must be related by name to … Continue reading Migration of SSRS to Another Instance
SUMMARY You have successfully installed and configured a 2-Node Cluster with Always On which has been deployed into Production. Well you notice later that your 2 SQL Server Standalones participating in your AlwaysOn have different Server Collation. Assuming: Server A: Latin1_General_CI_AS - Case Insensitive Server B: SQL_Latin1_General_CP1_CI_AS ACTION We are instructed as DBA's to get … Continue reading How to change SQL Server Instance Collation in an Always On Environment.
You may encounter problems when installing SQL Server on a domain controller - https://support.microsoft.com/en-us/kb/2032911