DotNetNuke, the specified password for the user account "sa" is invalid

I install DotNetNuke, during the installation it asks for the database password, I provide the same password that I use for the SQL server, but it shows an error.

The specified password for the user account "sa" is invalid or could not connect to the database server

Screenshot:

+6
source share
7 answers

You probably wonโ€™t set up a fairly complex SA password, although the Web Platform installer will not tell you what requirements (most likely 7 characters, with something else than just alpha)

As Daniel said, I hate WPI and avoid it like the plague. When it works, it works great, but when it does not, it is very difficult to fix the problem

+5
source

Follow the steps described here this solved my problem:

  • Log in to SQL Server using. \ sqlexpress and Windows Authentication

  • Expand Security, then Logins

  • Look at the icon. If a small down arrow is specified, the account is disabled. Let me fix it.

  • Double-click the sa account to open the properties.

  • Change the password (using the password policy) and confirm it.

  • Click Status in the left pane to reload the settings in the right pane. Select Enabled under the Login heading.

  • Click OK to close the properties window.

Given the sa account, we need to verify that we are in mixed mode:

  • In SSMS, right-click the server name in the left pane and select "Properties"

  • Click Security in the left pane and select SQL Server and Windows Authentication Mode.

  • Click OK.

  • Close SSMS.

The last step is to restart SQL Server (SQLEXPRESS) under the control panel โ†’ administrative tools โ†’ services.

Once this is done, log on to SQL Server 20008 Express using the sa account and password that you changed. If successful, you can install DNN using the web platform installer.

+3
source

I had the same problem, it took me several months to train. I have done the following:

Open Webmetrix as โ€œAdministratorโ€ Hold Shift + Right-click Webmetrix

he will ask you to enter the administrator password.

Install Webmatrix (make sure you know the SA password)

It should work like a charm

Thank you Yogovsky

+1
source

I do not have a great answer for you, but I can say that I had a lot of problems using the web platform installer. Now I prefer to download the regular installation package and just do it manually. This is not very difficult:

  • you unzip it, then move or copy all the files to the directory of the IIS website.
  • then you will make sure that the workflow has full rights to the folder
  • you create your database with user
  • you go to the site, and the installer simply cleans up right in the browser.
0
source

Use the server as a password. It worked for me.

0
source

Be sure to observe the password complexity for SQL Server by following the link: Password Policy

0
source

Make sure your instance is configured for sql authentication and Windows authentication. Check that your magazines can find something there.

-1
source

Source: https://habr.com/ru/post/952486/


All Articles