[Solved] System.Data.SqlClient.SqlError Directory lookup for the file "Path" failed with the operating system error 2(error not found). (Microsoft.SqlServer.Express.Smo)

Problem:
While restoring the content Database backup(.bak) to newly created content database in the database list, you will find this Error message.

System.Data.SqlClient.SqlError Directory lookup for the file "Path" failed with the operating system error 2(error not found). (Microsoft.SqlServer.Express.Smo)

Solution:
To solve this problem, use the steps mentioned below.
1) Right click in the new database in the database list
2) Tasks --> Restore --> Database...
3) Select 'From device' option to browse the backup file location
4) Enable the Restore checkbox for Database Backup and Transaction Log Backup in the selected backup path
5) Go to Options in the top left --> Select the Overwrite the existing database option
6) Most Important: Check the newly created Database Path which is selected properly or not as per in the below mentioned screenshot.
 

7) Once you confirm with the database location, click OK to restore.

My SharePoint: HTTP Error 503. The service is unavailable.

Service Unavailable HTTP Error 503. The service is unavailable

Today when we try to deploy webpart to SharePoint site, System display following error

“Service Unavailable  HTTP Error 503.  The service is unavailable”

When I research online come across that the error cause due to following reasons

1. Application Pools Identity account password may changed

2. The administrator has stopped the application pool

To Enable Service

1. Open up IIS Manager and

2. Go to Connection and Expand click on Application Pools

3. Select Application Pools and Start (if Services stopped)

If changed Identity account password

4. Locate your App Pool account and right-click on it and select ‘Advanced Settings’.

5. Click on the right of the Identity box to change it (A window will pop up).

6.  Click on Set and simply retype your App Pool Identity in there with the new password.