I have a SCCM Database server running Windows Server 2012 R2 with SQL 2008 R2 . Which doesn’t allow SCCM upgrades any more . Unless the SQL Server is 2014 SP2 or later. Checking the edition . It was SQL 2008 R2 Standard in the existing server. Have Download SQL …
Read More »SQL 2014/2016 Express Daily Full Backup using PowerShell
As SQL Server Agent doesn’t function on SQL 2014 Express. We have to use scripts to do daily backup. But Powershell SQLPS module can make things more easy for Admins. DailySQLDatabaseBackup Create a Scheduled Task in Windows Server 2012 R2 Note: Using Windows Task Scheduler to Run Power shell Scripts …
Read More »Service Principal Name is incorrect
If the SQL Service Account Principal name doesn’t have Domain Admins permission , You will face this error. you can give read write service principal name permission so that you can safely delegate the permission to the sql service account. Use adsiedit – Open Adsiedit.msc – domain (default partition) – …
Read More »Could not drop Login as the user is currently logged in. Error 15434
Created a Temporary users for testing purposes . But not able to remove the user in Microsoft SQL server Management Studio. Error : Could not drop Login as the user is currently logged in. (Microsoft SQL server,Error: 15434) Drop Failed for Login (Microsoft.Sqlserver.smo) Additional Information: An exception while executing a …
Read More »Installing/Configuring SQL 2014 Always ON Cluster on Windows 2012 R2 – Recommended way
SQL Always ON Availability groups are just similar like Exchange Database availability groups. It supports on only Enterprise editions. Lets see how to build it – One domain Controller Two SQL Servers One Witness servers (As its Even number of nodes – Having a Witness server so that it can …
Read More »Installing netfx manually on Windows server 2012 R2
The Following error has occurred: Error while enabling Windows feature : NetFx3, Error Code : –2146498298,Please try enabling windows feature : NetFx3 from Windows Management Tools and run the setup again. — Add the 2012 R2 Media – Assuming the Drive is D . Run below command in …
Read More »