real solutions for real problems
Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Tuesday, September 01, 2009 7:19 AM

How to fix SQL error: "Too many parameters were provided in this RPC request"

Recently we were confronted with a case where we received the following SQL error: [Microsoft][SQL Native Client][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided
Posted by EMEAAXTec | 0 Comments
Filed under: , , ,
Wednesday, July 22, 2009 3:30 PM

Kerberos authentication issues in a multi server environment affecting only the KPI web part

When you are setting up Dynamics AX 2009 Role Center and Enterprise Portal in a multi server environment where each component is running on Windows Server 2008 you may get confronted with an authentication issue. The base requirement for a multi server
Posted by EMEAAXTec | 0 Comments
Thursday, July 16, 2009 2:25 PM

Debugging Microsoft Dynamics AX 2009 SSRS reports with Microsoft Visual Studio 2008

While Microsoft SQL Server Reporting Services (SSRS) reports allowed in in Dynamics AX 4.0 a user to create Ad'hoc reports that were only based on the data stored in the Dynamics AX database, in Dynamics AX 2009 Production reports allow also the execution
Posted by EMEAAXTec | 2 Comments
Friday, July 10, 2009 12:20 PM

Disabled columns are sometimes included in SQL Queries created by the Dynamics AX Kernel

Over the last month we were facing a situation where the Dynamics AX 2009 Kernel was generating incorrect SQL Queries in a specific constellation: You have one or more fields (columns) on a table that are based on an Extended Data Type (EDT) This EDT
Posted by EMEAAXTec | 0 Comments
Wednesday, July 08, 2009 6:21 PM

About locking and blocking in Dynamics AX and how to prevent it

The locking of records is necessary to ensure transactions are processed accurately and with a high level of concurrency. Unfortunately the more records are locked the higher is the chance other transactoins are getting blocked resulting in peformance
Posted by EMEAAXTec | 0 Comments
Wednesday, July 08, 2009 8:51 AM

SQL Execution Error. The multi-part identifier ... could not be bound.

We were running lately into an issue with Dynamics AX 2009 and Microsoft SQL Server 2008 Analysis Services after switching the data source provider from SQLNCLI.1 (Microsoft SQL Server 2005 Native Client) to SQLNCLI10.1 (Microsoft SQL Server 2008 Native
Posted by EMEAAXTec | 0 Comments
Monday, June 08, 2009 1:54 PM

An error has occurred during report processing. (rsProcessingAborted)

In Dynamics AX 2009 a very common scenario with Enterprise Portal and Role Center is that only users that are local Administrators on the machine where Microsoft SQL Server 2005 is installed can correctly see Microsoft SQL Server 2005 Reporting Services
Posted by EMEAAXTec | 0 Comments
Monday, June 08, 2009 1:14 PM

Connecting from Dynamics AX 4.0 Client to Microsoft SQL Server 2008 Analysis Services fails

Recently when I was trying to access an OLAP cube on Microsoft SQL Server 2008 Analysis Services from within the Dynamics AX 4.0 Client I was running into the error message: One or more required client components that support OLAP analysis are not installed
Posted by EMEAAXTec | 1 Comments
Friday, May 22, 2009 3:01 PM

Error when executing direct SQL - SqlStatementExecutePermission

Sometimes it happens that you receive an error message if you have tried to execute a native SQL statement. The reason for this is that the request for the permission of type ' SqlStatementExecutePermission ' failed. (S)\Classes\SqlStatementExecutePermission\demand
Posted by EMEAAXTec | 0 Comments
Filed under: , ,
Friday, May 22, 2009 2:48 PM

Reporting Server Security

Recently we had a question how to give users access to SSRS and report builder? The problem was an "Access denied" for users not in admin groups. Therefore we had to review the Security settings for Report Services. We found out that Report Builder can
Posted by EMEAAXTec | 1 Comments
Friday, May 08, 2009 8:03 AM

Unable to install Dynamics AX 2009 Reporting Extensions

In the Dynamics AX 2009 Setup when you are trying to install the Dynamics AX 2009 Reporting Extensions for Microsoft SQL Server Reporting Services you might run into the following error message: An error occurred during setup of Reporting extensions.
Posted by EMEAAXTec | 1 Comments
Wednesday, April 29, 2009 4:21 PM

The Dynamics AX DB Upgrade Preparation Tool (AxDbUpgrade.exe) crashes after launching

I was once launching the Dynamics AX DB Upgrade Preparation Tool (AxDbUpgrade.exe) on a Windows Server 2008. I was using the version distributed with the Dynamics AX 2009 DVD. The issue here was that the tool was crashing shortly after launching. In the
Posted by EMEAAXTec | 1 Comments
Wednesday, April 29, 2009 2:03 PM

EXTERNAL as field name in SQL Server 2005

Maybe you already ran into the issue that you are using Dynamics AX 4.0 SP1 with SQL Server 2005. You are trying to create a new table in AOT with a column called "external". You recognize, that during the synchronization of the table with SQL Server
Posted by EMEAAXTec | 1 Comments
Tuesday, April 28, 2009 4:22 PM

Dynamics AX 2009 Enterprise Portal requires Analysis Management Objects (AMO) for SQL Server

I was recently installing a new Dynamics AX 2009 environment where I was having Enterprise Portal installed on a separate machine. When running the Dynamics AX Setup for the Enterprise Portal and Role Center role the installation completed with warnings.
Posted by EMEAAXTec | 4 Comments
Tuesday, April 28, 2009 12:22 PM

Error passing Int64 parameter to the SSRS report

When you are designing new Microsoft SQL Server Reporting Services Reports with the Microsoft Dynamics AX 2009 Reporting Extension in Microsoft Visual Studio 2008, you sometimes face the following situation. The new report is based on a Microsoft Dynamics
Posted by EMEAAXTec | 1 Comments
More Posts Next page »
 
Page view tracker