Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “The CREATE DATABASE statement failed. The primary file must be at least x MB to accommodate a copy of the model database.” …
Read More »Ekrem Önsoy
Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)
ERROR MESAGGE: “Drop failed for Login ‘Login_Name’. The server principal owns an endpoint and cannot be dropped. (Microsoft SQL Server, Error: 15141)” EXPLANATION: You …
Read More »The SQL Server (‘Instance_Name’) service failed to start due to the following error: The service did not start due to a logon failure.
ERROR MESAGGE: On SQL Server Configuration Manager: The request failed or the service did not respond in a timely fashion. Consulf the event log …
Read More »Connections to SQL Server files (*.mdf) require SQL Server to function properly
ERROR MESAGGE: “Connections to SQL Server files (*.mdf) require SQL Server to function properly. Please verify the installation of the component or download from …
Read More »Database ‘xxx’ cannot be opened due to inaccessible files or insufficient memory or disk space
ERROR MESAGGE: “Database ‘xxx’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. …
Read More »An error has occurred while establishing a connection to the server…No connection could be made because the target machine actively refused it
ERROR MESAGGE: “An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused …
Read More »Ad hoc update to system catalogs is not supported
ERROR MESAGGE: “Ad hoc update to system catalogs is not supported.” EXPLANATION: If the “allow updates” option in SQL Server Instance is enabled, you …
Read More »Error 0xc002f210: Preparation SQL Task: Executing the query “” failed with the following error: “Retrieving the COM class factory for component with
ERROR MESAGGE: “Error 0xc002f210: Preparation SQL Task: Executing the query “” failed with the following error: “Retrieving the COM class factory for component with …
Read More »SQL Server is not Starting(The system cannot find the path specified)
ERROR MESSAGE: Error 3(The system cannot find the path specified.) occurred while opening file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf’ to obtain configuration information at startup. …
Read More »System.Data.SqlClient.SqlError: The operating system returned the error ’32(The process cannot access the file because it is being used by another process.)’
ERROR MESSAGE: System.Data.SqlClient.SqlError: The operating system returned the error ’32(The process cannot access the file because it is being used by another process.)’ while …
Read More »