SQL Server Errors
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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: […]
XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable.
Error Message: Msg 9501, Level 16, State 2, Line 4 XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable. Severity level: 16. Description: This error message appears when in an XQuery a variable cannot be resolved to a valid TSQL variable. Consequences: The T-SQL statement can be parsed, but […]