MS SQL


What is the instance name of MSSQL on the local server?
The instance name of the MSSQL 2008 server in WebsitePanel Hosting 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 the faq : How do I connect to MSSQL using Classic ASP? for more information,
Note: New server is setup with SQL Server 2012 Standard Edition. so connection strings using ".SQLExpress" or "localhostSQLExpress" will not work. Connection strings will need to be updated to just "localhost".

If the connection strings were encrypted in web.config, those will need to be re-encrypted on new server.