Wednesday , January 23 2019

SQL

SQL 2008 R2 In place Upgrade to SQL 2014

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 »

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 »