The instance name of the MSSQL 2008 server on any of our Windows accounts is "SQLEXPRESS". This is good to have when trying to connect to the specific instance locally when the instance was not installed as the Default Instance on the server.
Please refer to the knowledgebase article on classic ASP connection strings in the ASP .NET category for more information.