Wednesday , 26 April 2017

Tag Archives: MS SQL

How to unlock and reset Sap* and DDIC users

ABAP system running on Sybase ASE Server Login to Sybase ASE database using following command with Windows Command Prompt [crayon-59002b5b6befa506517466/] It will prompt for password [crayon-59002b5b6bf09171373031/]   To check the account status for SAP* [crayon-59002b5b6bf0e640019269/] To unlock the SAP* account [crayon-59002b5b6bf13302055985/]   To check the account status for DDIC [crayon-59002b5b6bf17817006002/] To unlock the DDIC account [crayon-59002b5b6bf1c538822461/]   MANDT = SAP …

Read More »

SQL Server 2012 Configuration Parameters for SAP Systems

The configuration of a SQL Server database consists of these areas: Startup parameters Startup parameters are the optional arguments of the executable sqlservr.exe. They are read from the registry, when starting SQL Server as a service. You can modify the startup parameters by using the SQL Server Configuration Manager. The most common startup parameter is “-T” which allows to set …

Read More »

Setting SQL Server Traceflags for SAP Systems

Trace flags offer additional information about the SQL Server engine and enable or disable functionality in the SQL Server engine. Some trace flags should only be set, if specific problems occur of if asked by SAP or Microsoft Support. The following trace flags should not be set by default: 610, 611, 652, 661, 834, 1210, 1211, 1224, 3604 The following …

Read More »

MS SQL Server Upgrade from 2008 R2 to 2012 at SAP Systems

Based on recent MS SQL upgrade project , today I am hereby tracking out all the required steps to upgrade MS SQL database of SAP SYSTEM from 2008 R2 to 2012. Platform details: 1. SAP System : SAP NetWeaver 7.0 EHP2 with EHP5 for ERP 6.0 and AFS V6.05 Running modules: SD, MM, PP, QM, FI, CO, HR, AFS, TR 2. MS SQL …

Read More »