How do I change the password in the SQL "DotNetNuke" log in. I put in the password that the video says "dnnpassword" then when I try to install and configure the database connection I get this error message:
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed

It has something to do with the password automatically going to the default password and I cant change it without knowing what it is. Does anyone know the default password so I can change this to match with the database configuration part of the installation?

If you have SA access to the server you can run the following to set the password to a new one. As previously noted, you need to remove the enforce security attributes.

USE master
GO
sp_password @old=NULL, @new='YourNEWPASSWORD', @loginame='YourCurrentDBUSERNAME';
GO

---

Try using command prompt.
Osql –S yourservername –E
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO

This article is given 4 methods to change sql password, that could be helpful.