Remember SQL Server Express Instance Name

Just a quick note / reminder that when you have installed SQL Server 2005 Express on a server or workstation, that the default instance is not the server name!

I was trying to deploy a solution on a test box for MOSS 2007 and damn if it would not create the database that I needed!  Installed on the same box!  GRRRR! Well of course I was not thinking!  The default SQL instance name for SQL Server Express 2005 that is installed with the Standalone option of MOSS 2007 is ServernameOfficeServers  DUH!  Change my SQL Server name in the configuration and behold a successfull database creation!  ARGHHH!!!!

So, just a reminder to you!