Home » SQL Server » Page 2

SQL Server

SQL Server Error : 1639 The eror occurs during installation of SQL Server

SQL Server Error : 1639 Details

SQL Server Error: 1639 Severity: 16 Event Logged or not: No Description: The eror occurs during installation of SQL Server Severity 16 Description: Indicates general errors that can be corrected by the user.

SQL Server error 1639 happens during the installation of SQL Server. It happens for a variety of causes, ranging from folder naming issues to SQL port issues.

We assist our customers with SQL related faults on a regular basis as part of our Server Management Services.

Let’s talk about the probable causes and solutions for this mistake today.

SQL Server installation on a Windows PC fails for a variety of reasons. To name a few, there … Read the rest

SQL Server Error : 10027, Severity: 16. Command was not prepared.

SQL Server Error : 10027 Details

SQL Server Error: 10027 Severity: 16 Event Logged or not: No Description: Command was not prepared. Severity 16 Description: Indicates general errors that can be corrected by the user.

Has anyone managed to connect to Windows Search Service using SQL Server’s OLE DB Provider for Search? The error message I keep getting when setting a Linked Server in Management Studio is listed above…

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and … Read the rest

SQL Server Error : 10028, Severity: 16. Authentication failed.

SQL Server Error : 10028 Details

SQL Server Error: 10028 Severity: 16 Event Logged or not: No Description: Authentication failed. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

For other ways to read and find error log location please our article https://sqlserver-dba.co.uk/error-log/sql-server-identify-location-of-the-sql-server-error-log-file.htmlRead the rest

SQL Server Error : 10009, Severity: 16. The provider did not give any informatio

SQL Server Error : 10009 Details

SQL Server Error: 10009 Severity: 16 Event Logged or not: No Description: The provider did not give any information about the error. Severity 16 Description: Indicates general errors that can be corrected by the user.

The Event ID 10009 indicates that RPC system service on local machine couldn’t reach the RPC system service of target server. There could be various possibilities cause this Event error.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its … Read the rest

SQL Server Error : 1002, Severity: 16. Line %d: Specified scale %d is invalid.

SQL Server Error : 1002 Details

SQL Server Error: 1002 Severity: 16 Event Logged or not: No Description: Line %d: Specified scale %d is invalid. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

The parameters for XP_READERRRORLOG are:
1. Value of error … Read the rest

SQL Server Error : 10021, Severity: 16. Execution terminated by the provider bec

SQL Server Error : 10021 Details

SQL Server Error: 10021 Severity: 16 Event Logged or not: No Description: Execution terminated by the provider because a resource limit was reached. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

For other ways to read … Read the rest

SQL Server Error : 10022, Severity: 16. The provider called a method from IRowse

SQL Server Error : 10022 Details

SQL Server Error: 10022 Severity: 16 Event Logged or not: No Description: The provider called a method from IRowset Notify in the consumer, and the method has not yet returned. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL,
Read the rest

SQL Server Error : 10023, Severity: 16. The provider does not support the necess

SQL Server Error : 10023 Details

SQL Server Error: 10023 Severity: 16 Event Logged or not: No Description: The provider does not support the necessary method. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

For other ways to read and find error … Read the rest