SWPM - Distributed SAP system - Database Instance --> no connection to MS SQL Server Database

[wlourens2]

Hi,

I’m installing a new distributed SAP NetWeaver 7.5 MS SQL Server Process Orchestration system.

I received access on an existing database server, and created a new database tenant as follows:

SAP ASCS instance successfully installed.

SWPM launched on database server for SAP Netweaver 7.5 – MS SQL Server – Database Instance Installation:

On screen for “MS SQL Server Database Connection“, only the following Database Instance options available:

Option for new database POD_PPODEV not available.

When selecting CSMSQL, I get: “Caught ESAPinstException in module call: ERR_SQL.”

Please advise how to get SWPM to connect to the new database?

I already installed the ODBC driver as per SAP note 1902794, checked the authentication mode, default database and checked Network protocols enabled doe TCP/IP and Named Pipes.

Kind Regards,

[mamartins · Accepted solution]

MSSQL don't use the concept of tenant as on SAP HANA.

First, you don't need to create any database prior to SWPM execution, so remove the one already created.

Second, the user that the DBA provided should be an DB Administrator in order to SWPM properly executes it's job. During the "Database Instance" process, a new user will be created with the proper and sufficient permissions to let SAP connect to the DB, so the user the DB Administration will no longer be used and can be locked or the password changed.

Please refer to the SWPM documentation on Installation Guides - Application Server Systems - Software Provisioning Manager 1.0

[HRaj5 · Accepted solution]

Hi Mamartins,wlourens2,
I have a requirement where the database host is separate from the host where the NWAS needs to be installed, needing a distributed installation.
Does SWPM need to be launched in the DB host to install the database instance? Or can it is be done remotely via the host where i am going to install ASCS and PAS, with ODBC connection to the Database on the separate server?
Thank you in advance!

[HRaj5 · Accepted solution]

Hi Mamartins,wlourens2, I have a requirement where the database host is separate from the host where the NWAS needs to be installed, needing a distributed installation. Does SWPM need to be launched in the DB host to install the database instance? Or can it is be done remotely via the host where i am going to install ASCS and PAS, with ODBC connection to the Database on the separate server? Thank you in advance!