question

crisansou avatar image
0 Votes"
crisansou asked crisansou commented

Visual Studio 2019 - SQL Server Database Project - Error SQL70596 while building "GRANT Administer Database Bulk Operations" command

Hello,

I created a SQL Server Database project and imported a SQL Database. However, when building the project, the error message SQL70596: Cannot determine securable object class from permission Administer Database Bulk Operations is displayed, as shown in the print below.

134679-image.png

I connected to the database using the server's administrator user, that is, he has permission to execute the command. Does anyone know how to solve this problem?

Best regards,
Cristina


azure-sql-databaseazure-synapse-analytics
image.png (42.5 KiB)
image.png (46.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered crisansou commented

@crisansou Our sincere apologies for the inconvenience you are having with Visual Studio.

Request you to kindly report this issue so that we can fix it in an upcoming release.

137328-image.png


image.png (17.9 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo commented

Please try to connect to the database using SQL Server Management Studio (SSMS) and try this:

 GRANT ADMINISTER DATABASE BULK OPERATIONS TO [pipeline];

Maybe try to remove that permission from the script in Visual Studio and run it on the Azure SQL Database using SSMS.

The issue is not with the user you are connected using VS but with the pipeline login.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AlbertoMorillo ,

Thanks for your reply. I had already run this command in SSMS with the admin user and the command was executed successfully. I wouldn't want to just run this command manually, that's why I created a project to replicate the database structure to another using dacpac.

134803-image.png


0 Votes 0 ·
image.png (9.6 KiB)

It seems like a bug with Visual Studio, that is the reason I suggested the workaround using SSMS. Could you please try to update VS 2019 SSDT to the latest? Maybe that do the trick.

0 Votes 0 ·

Hi @AlbertoMorillo ,

I tried Visual Studio 2022 Preview and the error was the same, it really looks like a tool bug.

135039-image.png


0 Votes 0 ·
image.png (92.2 KiB)

Yes. It is a bug.

1 Vote 1 ·