sp_addlogin fails if you attempt to include a local temporary database as a default database for any login.