I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day later, the SQLServer service wouldn't start. I assume these events are related so I go into the Sql Server Configuration Manager. I try to start the service but it won't start so I open the properties for SQL Server (SQLEXPRESS). The Log On tab shows that the service is set to log on as .\administrator. I figure the problem is that I changed the administrator password and need to make these changes here. I put in the new password but it tells me the specified network password is not correct. I'm pretty sure I typed it in right so I'm assuming me and sql server aren't talking about the same administrator. I got it working by setting the administrator password back to what it used to be but I'd really like to be able to change it without breaking SQLEXPRESS. Any ideas what I'm missing?
Thanks,