SQL

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 …

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 …

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) – …

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 …

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 …

  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 …