Azure 数据库的密码重置

我有一个新的 Azure 帐号。我能够以管理员的身份登录到“管理”页面，但是我忘记了一个数据库的密码。我想重置那个数据库的密码。我该怎么做？微软似乎没有这方面的知识——至少我找不到。谢谢。

97226 次浏览
小开

You can actually reset your admin password to your SQL database using the old/previous Silverlight portal.

  1. Log into https://windows.azure.com/ or into the current one and select "Previous portal" from your login

  2. In the previous portal click the "Database" menu item on the bottom left

  3. Select the database from the subscription

  4. click the "reset password"

小开
最佳答案

If you're referring to the administrative password for a specific Windows Azure SQL Database server, you can do this from the new portal. Select the Database choice on the left, then select Servers:

enter image description here

Then, after selecting the server of choice, you'll see the option on the right for resetting admin password:

enter image description here

小开

To reset the administrator password for a SQL Database server, use the following steps:

  1. Go to the Windows Azure Management Portal at http://manage.windowsazure.com and click SQL Databases in the left-hand navigation pane.
  2. Click the Servers tab at the top of the SQL Databases workspace. This will launch the Server List View.
  3. In the Server List View, click the name of the server to update. This will launch the Server Dashboard.
  4. On the Server Dashboard, click Reset Administrator Password under quick glance tasks on the right-hand side of the workspace.
  5. On the Reset Password dialogue, specify a new password and then confirm the new password.
  6. To complete the operation, click the Check mark button at bottom right. You will be returned to the Server Dashboard for the server.

If you reset the SQL Database server password during a time when there are active connections to databases on the server, you may want to use the KILL statement to terminate user sessions. This will force client connections to refresh their sessions with the database and the host server. For more information, see KILL (Windows Azure SQL Database).

小开

Using the new azure portal: https://portal.azure.com

  1. Click browse (to view all resources)

Resources list

  1. Select SQL databases

  2. Choose a database that's in the server you want to change creds for.

  3. Select the server name url for that selected database. This should open up the server configuration blade.

  4. Reset password is the second button from left.

For selected database

小开

Another variation on new Azure portal (bypassing the database), #1 go to SQL servers directly; #2 click on the DB Server you want to update the password for, #3 click the pencil, #4 update the password, confirm and save.

enter image description here

小开

You can use the following command with the Azure CLI 2.0 to change / reset the password for Azure SQL Database:

az sql server update -n {database server name}
-g {resource group name}
-p {password}

Source: https://buildazure.com/2017/05/18/azure-cli-2-0-reset-azure-sql-database-password/

小开

With the current iteration of the interface, the process is similar to what is described above with an additional step:

  1. Get to the Overview as described above.
  2. New: Click on the server name (I just had to stumble into it. Horrible UI design.)
  3. Now there is an option to reset the password.
小开

Update for new portal:

Go to the SQL server that's hosting your SQL DB and click on "Reset password".

enter image description here

小开


If someone had forgotten his password for DB, First of all, look at the connection string(appsettings.json). You will find it there.


提交答案