ERROR Permission denied. 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server.

[hemmo241000]

Hi,

How to avoid following problem (bug or)?

Briefly:
I connected to azure sql server
"Microsoft SQL Azure (RTM) - 12.0.2000.8 Oct 2 2025 00:38:42 Copyright (C) 2025 Microsoft Corporation"

I used "import-file" and run command

c:\work\azure>java -Xmx6g -Djava.io.tmpdir=c:\tmp -jar "-Dfile.encoding=UTF-8" ......dbptk-app-4.3.0.jar migrate -i import-config --import-file azure.yaml -e siard-2 --export-file=azure.siard

I got error "ERROR Permission denied. 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server."
and no siard file generation!

If I set following into import-file:
ignore:
users: true

It generates siard file but then I got validation problems e.g

M_5.1-1-17: [ERROR] : User node is mandatory (metadata.xml dbname:xxxx)
and
M_5.17-1: [ERROR] : Nothing found in this path /ns:siardArchive/ns:users/ns:user

Regards

Tuomo

[hemmo241000]

Hi,

It seems to be sql syntax problem!

I avoided problem by adding "user" xml element to metadata:

x.siard\header\metadata.xml

users:
<user
<name xxx</name
</user

I need to use following config in import-file to avoid error:
ignore:
users: true

In that case xml element
"user" is not filled!

I used 7zip to edit metadata.xml!

Regards

Tuomo