Data Protection Manager 2012 Setup: Error 4309 while installing SQL Server 2008 R2 SP1
I just needed to do a fresh installation of Microsoft System Center 2012 Data Protection Manager SP1 on a fresh Windows Server 2012. I went throug all steps of the installation wizard, installed all prerequisites and started the installation. But then I got this error: The Data Protection Manager installation did not complete successfully. For details, click the Error tab. The SQL Server installation failed. All changes made by the SQL Server installation to the system were rolled back. Manually install SQL Server. For instructions, see “Manually Installing Prerequisite Software”...
Read MoreSystem Center 2012 SP1 Operations Manager: Datawarehouse configuration failed to install
While installing Microsoft System Center 2012 SP1 Operations Manager I got following error: In the log I could see that Setup could not create the Datawarehouse database: EXEC(@sql);: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file ‘E:\SQL\Data.mdf’. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. I have a standalone SQL 2012 SP1 server (SQL) and a Windows...
Read MoreCannot insert duplicate key error while upgrading SCCM 2012 to SP1
The following error occurred during SP1 update of Microsoft System Center 2012 Configuration Manager: ERROR: SQL Server error: [23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint ‘CollectionQueryRuleTables_PK’. Cannot insert duplicate key in object ‘dbo.CollectionQueryRuleTables’. The duplicate key value is (16777228, 1, vSMS_R_System). Configuration Manager Setup 05.02.2013 09:12:18 4084 (0x0FF4) The easiest way would be to delete the corresponding rows from CollectionQueryRuleTables table in your SCCM database. This...
Read MoreError 18054 and Error 777971002 in SQL log after moving System Center Operations Manager 2007 Database
I just needed to move the System Center Operations Manager 2007 Database from one SQL server to another. I followed Kevin Holman’s instructions step by step and ran into the same problem he was noticing after the move. The error I got was: Error 777971002, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. So I followed the steps he took which did not solve my problem. I still got these errors in the log. But there is another way to fix this...
Read MoreSQL 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 MoreError 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 MoreTape Label Studio
Buy Tape Label Studio one time – create hundreds of free backup tape barcode labels anytime.
Once you got a license, it’s yours to keep. No monthly fee.
For more information on Tape Label Studio visit www.tapelabelstudio.com
Recent Comments