Tag Archives: Database

Microsoft OLE DB provider for SQL Server error 80004005

While browsing a ASP site, you end up getting SQL Server error 80004005. Microsoft OLE DB Provider for SQL Server error ’80004005′ [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. CAUSE Microsoft OLE DB provider for SQL Server error 80004005, primary occurs because ASP page is unable to connect to SQL Server using connections settings, which you [...]

SQL Server – Kill All Process in a Database

At times, there may be a chance, when we intentially, wanted to kill all active proccesses in a given database or Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. Drop Database Failed Following Script will kill all currently running processes in a given databse. This generic [...]