Skip to Content

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

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'.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 12, 2017 at 01:55 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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