dbnetlib connectionopen connect . sql server does not exist or access denied - SQL 2008

Make sure TCP/IP protocol is running.
1. Open SQL Server configuration manager
2. Click on SQL Server configuration manager
3. Click on SQL server network configuration
4. Click on Protocol for SQL Express
5. Make sure TCP/IP is Enable

(Note: Make sure all SQL Server services are running as well)

SQL: The backup set holds a backup of a database other than existing database - SQL Server "2008

Cannot restore database using .bak file. It is showing an error message: The backup set holds a backup of a database other than existing database - SQL Server "2008. 

1. Select the Backup file to restore from the following window - Look at the left hand side you will see General Tab is selected

2. Click on the Option tab on the left hand side of the same window and Select: Overwrite the existing database

ASP.NET: Cannot connect to Default database

It seems I had the DB still opened inside my Visual Web Developer Express-IDE, in the database explorer. 
1. Right-clicking the database 
2. and selecting "close connection" fixed it.
3. Close the browser if it was already open and try again.
4. If does not work immediately, wait few moments and try again.


Thanks