When you attempt to load Ektron in a web browser your presented with the error "Unable to login with user 'USER' [EKSite -> GetSiteVariables()] or "Object reference not set to an instance of an object. [EKSite ->GetSiteVariables()]" error.

This is most commonly due to an issue loading information from the SQL Server due to a failed login. Double check your ConnetionStrings section of your web.config to make sure the connection string to your Ektron DB is setup to point to the correct Server and Database with a valid login and "Integrated Security" set to false.