WebMatrix error "The specified password for user account 'root' is not valid...."

mysql sql-server webmatrix
James picture James · Oct 1, 2012 · Viewed 17.9k times · Source

When creating a new Joomla, Drupal or any website involving a database from the 'App Gallery', I get the errors:

MySQL

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

SQL Server

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

What can be done to stop this error occurring? I don't believe it's with the databases, I blame WebMatrix because it's the same problem for both DBs.

Thanks in advance

Answer

Ravi Reddy picture Ravi Reddy · Dec 13, 2012

I had the same problem and i performed the below steps to resolve the issue:

  1. Open Sql Server Management Studio as Administartor

  2. Login to .\SQLEXPRESS using Windows Authentication

  3. Go to Security Tab -- > Logins --> Change the "sa" password and Press Ok

  4. Use the newly created Password in WebMatrix and you should be all Set.

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
update columns values with column of another table based on condition

I have two tables... table1 ( id, item, price ) values: id | item | price ------------- 10 | book | 20 20 | copy | 30 30 | pen | 10 ....table2 ( id, item, price) values: id | item | price ------------- 10 | book | 20 20 | book | 30 Now I want to: update table1 set table1.Price = table2.price where table1.…

Read More
Differences between MySQL and SQL Server

I'm an ASP.NET developer who has used Microsoft SQL Server for all my database needs (both at work and for personal projects). I am considering trying out the LAMP stack for some of my personal projects. What are some …

Read More