Is it possible to connect to Azure SQL Server from ABAP?

[davidbest]

I am attempting to make a connection from an ABAP system to an Azure managed SQL Server instance in transaction DBACOCKPIT. The test connection fails and I see the error messages in the dialog developer trace (below). I can't see any tables in the master database using SSMS, so my assumption is that it isn't possible to make a connection to an Azure shared MSS instance. Is this true?

C Fri Jun 09 13:17:33 2017
C  GetDbRelease: 12.00.2000.08
C  GetDbRelease: Got DB release numbers (12,0,2000,8)
C  comm. rd. spid 111
C  unc. rd. spid 115
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8295]
C  (262) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE FUNCTION permission denied in database 'master'.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8295]
C  (262) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE FUNCTION permission denied in database 'master'.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8295]
C  (262) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE FUNCTION permission denied in database 'master'.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8295]
C  (262) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE FUNCTION permission denied in database 'master'.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8295]
C  (262) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE FUNCTION permission denied in database 'master'.
B  Connection 12 opened (DBSL handle 2)
C  ERROR: -1 in function StartSelect (execute) [line 16360]
C  (208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'master..syslogins'.
C  Error 103 (dbcode 208) in StartSelect
C  StartSelect: stmt of NULL_STMTID
C  declare @id1 int set @id1=object_id('dbo.sap_tf_version','P')select (select coun
C  t(*) from sysobjects where id = @id1), (select count(*) from sysusers where name
C   = ?  ), (select count(*) from sysusers u, master..syslogins l  where u.sid = l.
C  sid and u.name = ?  )
C  dbdsmss: DBSL103 SQL208
C  Invalid object name 'master..syslogins'.

[luisdarui · Accepted solution]

Hi David,

Currently Azure SQL DB and Azure Data Warehouse (Database as a service offerings) are not supported for local installations or remote database connections. See SAP 555223.

[davidbest · Accepted solution]

Hi Luis,

Thanks for the feedback. Based on the description in the Symptom section of this note, I see this note containing a definition of supported scenarios for installing a NetWeaver using SQL Server database. I read point 4 of the note to say that it isn't possible to install a NetWeaver system into an Azure SQL Server (DBaaS) instance, which makes sense. Since this isn't what I'm trying to do, I'm not sure this answers my question.

Thanks,

David

[davidbest · Accepted solution]

I found that SAP expects to find a system view in the master database called sys.syslogins. This doesn't exist in an Azure SQL database. The remote connection obviously can't work as currently implemented by SAP, so I will mark this as answered