SQL Server Errors

Data Mining Add-ins Error

When using Microsoft SQL Server 2012 Data Mining Add-ins you may encounter the below error: Error (Data mining): Session mining objects (including special data source views used to process data mining dimensions) cannot be created on this instance The reason this occurs is that the Data Mining tool needs to create session mining models in […]

Drop Failed for Login ‘User xxx’

How To Drop Users Who Are Owners or Databases and Jobs When you want to drop users you need to en sure that those users are not owners databases SQL Server agent jobs, otherwise you will be confronted with the below error: To avoid this you will need to change both the database and SQL […]

SQL Server Reporting Services – Insufficient Rights Error

Introduction At times when we successfully deploy the reports to the report server and try to view them through report manager we may encounter am insufficient rights error. This article focuses on resolving that error. Solution After deploying the reports to the report server we can view them in the Report Manager web app provided […]

SQL Server Agent Alter Column Error

Replication Agent will fail when attempting to alter a column in the publisher which is part of an index. For example, let’s say you have table like following: CREATE TABLE [dbo].[Employees]( [ID] [int] IDENTITY(1,1) NOT NULL, [FirstName] [nvarchar](50) NULL, [LastName] [varchar](50) NULL, CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED ( [ID] ASC ) ) ON [PRIMARY] And […]

Add Node to A SQL Server failover Cluster failed with invalid SKU error

After creating a new SQL Server failover cluster node, trying to add the 2nd node to the SQL failover cluster  after entering the product key (same key used for 1st node installation) and hitting next  I’m getting the below error: The current SKU is invalid. Solution: This bug supposed to be fixed by the first […]

SQL Server Destination remote server error

SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available.  Source: “Microsoft SQL Server Native Client 10.0″  Hresult: 0x80040E14  Description: “Could not bulk load because SSIS file mapping object ‘GlobalDTSQLIMPORT              ‘ could not be opened. Operating system error code 5(Access is denied.). Make sure you are […]

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

Reporting Services in SQL Server 2005 runs on IIS 7.0. After configuring Reporting Service, two virtual directories will be created by default their Application pool – DefaultAppPool. Every Application pool is set to pipeline mode and there are two types of Pipeline modes namely, Integrated and Classic. If the Pipeline mode of the Application Pool attached to the virtual […]

XQuery [query()]: Attribute may not appear outside of an element

Error Message: Msg 2396, Level 16, State 1, Line 7 XQuery [query()]: Attribute may not appear outside of an element Severity level: 16. Description: This error message appears when in an XQuery an attribute appears outside of an element. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of […]

Cannot find either column “%.*ls” or the user-defined function or aggregate “%.*ls”, or the name is ambiguous.

Error Message: Msg 4121, Level 16, State 1, Line 5 Cannot find either column “%.*ls” or the user-defined function or aggregate “%.*ls”, or the name is ambiguous. Severity level: 16. Description: This error message appears when either a column or a user-defined function or aggregate can not be found of the name is ambiguous. Consequences: […]

%sThe name “%ls” has already been defined.

Error Message: Msg 2230, Level 16, State 1, Line 5 %sThe name “%ls” has already been defined. Severity level: 16. Description: This error message appears when in an XQuery a name is defined more than once. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |