Jared Heinrichs

You are here: Home / Blog

By Leave a Comment

FIX – The specified password for user account ‘root’ is not valid, or failed to connect to the database server.

Are you getting the error:

The specified password for user account 'root' is not valid, or failed to connect to the database server.

when you are trying to install WordPress via the Microsoft Web Platform Installer?

If you are 100% sure that you have the right password this post might help.

It would be in your best interest to try and log into the MySQL server using the root/password combo you think is correct. As long as you can login here the rest of the post will apply to you.

You can do this either through LanBench or MySQL command line.

MySQL_Login_error_installing_wordpress_001

I will use the command line tool. It will ask you what the root password is right off the bat.

MySQL_Login_error_installing_wordpress_002

If the password is correct you should see something similar.

The next thing you need to do is download and install the MySQL .NET Connector. Once you install the connector the install should proceed!

Good luck. I hope I helped you fix “The specified password for user account ‘root’ is not valid, or failed to connect to the database server.” error!

By Leave a Comment

FIX – Application pool cannot be deleted because it contains 1 applications.

Are you getting the error message: There was an error while performing this operation. Details: Application pool “<name>” cannot be deleted because it contains 1 applications?

The only way I could figure out how to delete it was using Powershell.

How-to-delete-web-pools_000

How-to-delete-web-pools_001a

How-to-delete-web-pools_002

Here are the Powershell commands:

  1. import-module WebAdministration
  2. iis:
  3. ls *optional* This just shows you the AppPools folder exists
  4. cd AppPools
  5. dir
  6. del *name_of_Web_Pool*
  7. Will ask you if you really do want to remove the App Pool. “Hit A for “Yes to all”.
  8. ls – This will allow you to verify the AppPool is gone.

How-to-delete-web-pools_003

You can now go back into IIS and verify that the AppPool is no longer there!

Filed Under: IIS

By Leave a Comment

How to find the SID of a User (Local/Service/Domain/Microsoft)

There are 4 main SIDs that I know of:

  1. Local User
  2. Service
  3. Domain (AD user)
  4. Microsoft User (Part of Windows 8/10) – Users authenticate against Microsoft servers.

To Find them on the local machine you need to go to Regedit and find:

  • HKLCM
    • SOFTWARE
      • Microsoft
        • Windows NT
          • Current Version
            • Profile List

In “Profile List”, you will find the SIDs of the computer.

SIDs can have two “looks”. Many people call them:

  • Short SIDs
  • Long SIDs

The short SIDs tend to be for local users and services whereas the long ones are used for Domains and Windows Users.

sid-001b

If you look at the “ProfileImagePath” you can figure out what user or service the SID resolves to. In the screenshot above:

  • S-1-5-18 -> “SystemProfile”
  • S-1-5-19 -> “Local Service”
  • S-1-5-20 -> “Network Service”
  • S-1-5-21 – [Long SID] -> My account.

 

By Leave a Comment

Delete or restore users in Office 365

As an Office 365 admin, you may have to delete or restore a work or school account. Once you delete the work or school account, unauthorized people can’t continue to use the account. Deleting the work or school account also frees the Office 365 license assigned to that user. When you create an Office 365 user account, a license gets assigned to that user so they can use certain features. When you delete a user, you don’t lose their data. The user’s data is stored for 30 days. When you restore thework or school account within the 30 days, the user account and all associated data are restored.

TIP: Do you want to delete a user on the go? Use your mobile device. Delete a user on the go using the Office 365 admin mobile app. Enter your mobile device number and we’ll text it to you or you can get it from your mobile device’s store.

You can re-assign a license without deleting the related work or school account. Check out Assign or remove a license for more info about removing or assigning licenses.

Delete users

To delete the account for one or more users

  1. Sign in to Office 365 with your work or school account.
  2. Go to the Office 365 admin center.
  3. Go to Users > Active Users.
  4. Choose the names of the users that you want to delete, and then select Delete or Delete user Delete.

    Your screen might look like either of the following screenshots:

    Delete a user in Office 365. Delete a user in Office 365.
  5. On the confirmation page, select Delete.

When you delete a user account, the account becomes inactive. However, for approximately 30 days after you have deleted it, you can restore the account and the associated data.

IMPORTANT: Make sure you reset the user’s password after you restore the user. Follow the steps in this topic.

NOTE:  If your organization synchronizes user accounts to Office 365 from a local Active Directory environment, you must delete and restore those user accounts in your local Active Directory service. You can’t delete or restore them in Office 365. For more information about synchronizing user accounts to Active Directory, see Activate synced users.

Restore Users

Restore one or more users
Restore a user that has a user name conflict
Restore a user that has a proxy address conflict
Reset a user’s password

Restore one or more users

When you restore a user account within 30 days after deleting it, the user account and all associated data are restored. The user can sign in with the same work or school account. Their mailbox will be fully restored, and they’ll have access to all services they previously accessed.

NOTE:  If you need to find out how much time remains before a particular user account can no longer be restored, contact Office 365 Support.

Before you restore a user account, make sure there are Office 365 licenses available that you can assign to the account. Also, when you restore an account, you may encounter conflicts with user names or proxy addresses, which you can resolve.

To restore one or more users

  1. Go to Users > Deleted users.
  2. On the Deleted users page, choose the names of the users that you want to restore, and then select Restore users orRestore.

    Your screen might look like either of the following screenshots:

    Restore a user in Office 365. Restore a user in Office 365.
  3. If the user is successfully restored, click Close in the confirmation box.

For more information about deleted user accounts and how to restore them, see How to troubleshoot deleted user accounts in Office 365.

Top of Page

Restore a user that has a user name conflict

A user name conflict occurs when an admin deletes a user account, creates a new user account with the same user name (either for the same user or another user with a similar name), and later tries to restore the deleted account.

To resolve a user name conflict, you can either replace the active user account with the one that you are restoring or assign a different user name to the account that you are restoring so that there aren’t two accounts with the same user name.

Which version of the admin center do you see?

Illustration of the Office 365 Admin Center. Find out more about the Office 365 admin center

If you see this, follow the steps: Restore a user that has a user name conflict

 Illustration of the Office 365 Preview Admin Center. Find out more about the Office 365 Preview admin center

If you see this, follow the steps: Restore a user that has a user name conflict


Restore a user that has a user name conflict in classic admin center

  1. Go to Users > Deleted users.
  2. On the Deleted users page, choose the names of the users that you want to restore, and then select Restore users.

    NOTE:  If two or more users fail to be restored, an error message advises you that the restore operation failed for some users. View the log to see which users were not restored, and then restore the failed accounts one at a time.

  3. On the User name conflict page, do one of the following:
    • If you want to keep the restored account and the conflicting active account, select Edit user name of the user you want to restore, type a new user name, and then select the appropriate domain name.
    • If you want to remove the active account and replace it with the account that you are restoring, select Replace active user with this deleted user.
  4. Select Submit.
  5. Review the results, and then select Finish.


Restore a user that has a user name conflict in preview admin center

  1. Go to Users > Deleted users.
  2. On the Deleted users page, choose the names of the users that you want to restore, and then select Restore.

    NOTE:  If two or more users fail to be restored, an error message advises you that the restore operation failed for some users. View the log to see which users were not restored, and then restore the failed accounts one at a time.

  3. On the Restore page, choose whether you want to have the password automatically generated, or whether you want to create the password. Additionally, you can choose to Make this user change their password when they first sign in.
  4. If you chose Let me create the password, type the password in the Password box, and then retype the password.
  5. Click Restore.
  6. A message advises you that there was a problem restoring the account. Do one of the following:
    • Cancel the restore and rename the current active user. Then attempt the restore again.
    • Type a new primary email address for the user and click Restore.
  7. Review the results, and then select Close.

Top of Page

Restore a user that has a proxy address conflict

A proxy address conflict occurs when an admin deletes a user account that contains a proxy address, assigns the same proxy address to another account, and then tries to restore the deleted account Follow the steps below to fix this issue.

Which version of the admin center do you see?

Illustration of the Office 365 Admin Center. Find out more about the Office 365 admin center

Follow the steps: Restore a user that has a proxy address conflict

 Illustration of the Office 365 Preview Admin Center. Find out more about the Office 365 Preview admin center

Follow the steps: Restore a user that has a proxy address conflict


Restore a user that has a proxy address conflict in classic admin center

  1. Go to Users > Deleted users.
  2. On the Deleted users page, check the names of the users that you want to restore, and then select Restore users.

    NOTE:  If two or more users fail to be restored, an error message advises you that the restore operation failed for some users. View the log to see which users were not restored, and then restore the failed accounts one at a time.

  3. On the Restore User page, if you want to restore the user account and delete the proxy addresses attached to that account, select Submit.

    NOTE:  If a user account contains more than one error that prevents you from restoring it, the Resolve proxy address conflict page displays a Next button instead of a Submit button. Select Next to resolve the error on the next page.

  4. Review the results, and then select Finish.


Restore a user that has a proxy address conflict in preview admin center

  1. Go to Users > Deleted users.
  2. On the Deleted users page, select the user that you want to restore, and then select Restore .
  3. On the Restore page, choose whether you want to have the password automatically generated, or whether you want to create the password. Additionally, you can choose to Make this user change their password when they first sign in.
  4. If you chose Let me create the password, type the password in the Password box, and then retype the password.
  5. Click Restore. Any conflicting proxy addresses are automatically removed from the user you are restoring.
  6. Review the results, and then select Close.


Reset a user’s password

After you’ve restored a user, make sure you reset the user’s password by following the steps in the Reset a user’s passwordtopic.

Try searching this site!