HTTP 404 in MS CRM

1.    Check if the database is running up
2.    If the database is set to SingleUser by any chance then follow the below steps
    •    Stop all the Microsoft Dynamics CRM Asynchronous Processing Service in the application server
    •    and then go to SQL Server and open the respective database--> check if DB Properties are accessible --> change from properties
3.    If the DB Properties are not accessible just use the below command
    Use DatabaseName
    GO
    Select * from master.sys.sysprocesses Where spid > 50 And dbid=DB_ID (‘DatabaseName’)

    Use TestServer_MSCRM
        kill 69 --spid from the above Query
    Use master;
    GO
    ALTER DATABASE DatabaseName
    SET MULTI_USER;