Traducir Login Failed For User ‘Usr_Lnk_Dwpaiweb’. The Account Is Disabled. Del Inglés

Here’s how to fix the error: “Login failed for user ‘usr_lnk_dwpaiweb’. The account is disabled.” This error is most common in Microsoft SQL Server, and it means that the SQL login 'usr_lnk_dwpaiweb' is disabled in the database and needs to be re-enabled by someone with admin (sysadmin) access.

✅ Solution: Re-enable the Disabled SQL User Account

You’ll need access to SQL Server Management Studio (SSMS) or any other tool that can run SQL commands.

🔓 Option 1: Enable the SQL Login via SSMS GUI

1. Open SSMS and log in as a sysadmin (e.g., sa or Windows Auth).

2. In Object Explorer:

   • Go to: Security > Logins

   • Find the login: usr_lnk_dwpaiweb

3. Right-click on it → Select Properties

4. Under Status tab:

   • Set Login: Enabled

5. Click OK

🛠 Option 2: Enable the Login via T-SQL

If you prefer (or need to), you can use this command:

🔐 Run this from a sysadmin account. Otherwise, you’ll get a permissions error.

Also Read : Disney Subscriptions Down 

🧪 Optional: Reset the Password (if needed)

If the account was disabled due to failed login attempts or policy violations, you may also need to reset the password:

🔍 Verify If It’s Fixed

Once you enable the login, try logging in again (either via your app, script, or connection test). If it works, the issue is resolved.

⚠️ Still Failing?

If you’re still seeing errors:

• Make sure SQL Authentication is enabled (not just Windows Auth)

• Check the default database for the login exists and is online

• Review SQL Server logs (ERRORLOG) for details