Author Archives: Matt Bartlett

Resetting Hana Cloud Connector (HCC) Password

Posted on by
Reply

We’ve all been there and suddenly you need to add another developer to your Cloud Connector but alas you can’t remember your username and/or password.

Here is a quick way to find the username and reset the password.

These details are contained within the users.xml file and in order to find its location load up services from control panel or search for services.msc

Find the SAP Cloud Connector and double clickNote in my example the folder is c:\SAP\scc20\

Open up Windows Explorer and browse to the folder and you should see the following

Look inside the config folder and open the users.xml file with notepad.

Here all users are displayed – note in my example users are Administrator and Matt

If I want to reset the password these are in SHA256 format – you can simply generate one using a website such as https://passwordsgenerator.net/sha256-hash-generator/

Copy the hash and paste into the users.xml file

Save the file and restart the service

Now I can login with Administrator and a password of mynewpassword

Some sample hashes for reference

password = 5E884898DA28047151D0E56F8DC6292773603D0D6AABBDD62A11EF721D1542D8

manage = 181229424893BB65D94A74C2132B8B9E5ADFE851464FDB5CB9F49E8A8204BE7B

For more information on configuring and installing the Hana Cloud Connector I can recommend this book:

 

SAP Password Cracking with John the Ripper

Posted on by
2

With the recent releases of John the Ripper (1.7.8 and above) we now have password cracking with multiple cores available so we can crack SAP passwords faster than ever before. SAP password cracking requires the Community Edition otherwise known as the Jumbo Release to support the required hash formats.

Do not use this against systems you’re not authorised to do so.

Step 1: Dump the password hashes from SAP. You can use this ABAP Program to generate in the correct format for John the Ripper.  You could alternatively dump these direct from your backend database but it needs to be in the format the code generates.Matt Bartlett

Step 2: Download and Install John the Ripper. In the video I optionally compile for my Linux Backtrack Server and enable OpenMP for multiple core processing as this is my preference but you could alternatively download a plain precompiled version. There are also Windows binaries available you can download complete with OpenMP enabled which is partially handy if you don’t have access to multiple platforms. Which ever version you download don’t forget you need the Jumbo Community Version.

Step 3: Simply run John the Ripper against the hashes this will run through its standard rules and attempt to brute force the passwordsor with the –wordlist option to specify a dictionary attack based on any number of large word lists available.

SAP has a good note describing some features you can use to limit this type of attack – See SAP Note: 1237762

I can also recommend this book for much more information around this topic –

Connecting SAP on Microsoft SQL to an External Oracle Database Server

Posted on by
2

During a recent bit of consulting I was asked to connect SAP to various External Databases. SAP impressed me with its Multi-Connect feature and I thought it worthy of a couple of quick videos.

If you’re already running SAP on Oracle then you can skip to Step 5

Step 1: Download the database library. Under Kernel Patches and make sure you select the database version you want to connect to in this example Oracle.
Matt Bartlett
Matt Bartlett

Step 2: Unpack and copy the library itself dboraslib.dll to your application instances kernel folders. In the video I leveraged the instance.lst file to get SAP to do this for me as part of the SAP startup sapcpe process.

Step 3: Download and unpack the Oracle Client Tools
Matt Bartlett

Step 4: Install the Client Tools. Select Runtime or Administrator
(InstantClient on its own is not enough)Matt Bartlett

Step 5: Configure Oracle Net Manager to point to our External Oracle ServerMatt BartlettAs the client tools are installed its very simple to test the connection using tnspingMatt Bartlett

Step 6: In SAP transaction SM30 table maintenance for DBCON. Add the connection using the connection name we just created in Oracle Net Manager.Matt Bartlett

Step 7: Code away. You can download my sample ABAP program here.

If you’re looking for this the other way around connecting from Oracle to Microsoft SQL see – http://www.mattbartlett.co.uk/connecting-sap-on-oracle-to-an-external-microsoft-sql-db

Chapter 8 of SAP Administration – Practical Guide contains more information about how to configure database connections:

 

 

Connecting SAP on Oracle to an External Microsoft SQL Database Server

Posted on by
3

During a recent bit of consulting I was asked to connect SAP to various External Databases. SAP impressed me with its Multi-Connect feature and I thought it worthy of a couple of quick videos.

If you’re already running SAP on Microsoft SQL then you can skip Steps 2 and 3.

Step 1: Make sure your SQL server is setup to support SQL Server Authentication as the default is Windows Authentication Mode only.Matt BartlettIf in any doubt of your SQL configuration try using the standard Windows ODBC data source wizard. If you’re not getting a connection don’t forget your listeners.

Step 2: Download the database library. Under Kernel Patches and make sure you select the database version you want to connect to in this example MS SQL Server.Matt Bartlett
Matt Bartlett

Step 3: Unpack and copy the library itself dbmssslib.dll to your application instances kernel folders. In the video I leveraged the instance.lst file to get SAP to do this for me as part of the SAP startup sapcpe process.

Step 4: In SAP transaction SM30 table maintenance for DBCON. Add the connection. MSSQL_DBNAME is optional and you can use named pipes if you really want to by entering np:hostname instead of tcp:hostname.Matt Bartlett

Step 5: Code away. You can download my sample ABAP program here.

If you’re looking for this the other way around connecting from Microsoft SQL to Oracle see – http://www.mattbartlett.co.uk/connecting-sap-on-microsoft-sql-to-an-external-oracle-db/

Chapter 8 of SAP Administration – Practical Guide contains more information about how to configure database connections: