Unable to deploy SQL Database to Azure using SQL Package

• Weegee71

  SSChasing Mays

  Points: 604

  More actions

  November 14, 2022 at 4:41 pm

  #4112804

  Hi there

  We have a SQL Server database that we want to deploy to Azure .

  We are able to connect to the Azure instance ok with Credentials using SQL Server Managment Studio.

  However we tried the following :

  SqlPackage.exe

  /SourceFile:"C:\Users\User1\source\repos\metrology\TinytagExplorerMetrology\Logger_Groups.Build\bin\Debug\netstandard2.0\Logger_Groups.Build.dacpac"

  /Action:Publish

  /TargetServerName:"XXXX.database.windows.net,1433"

  /TargetDatabaseName:"XXX"

  /TargetUser:"xxxxxadmin"

  /TargetPassword:""

  /p:AllowIncompatiblePlatform=true

  And then got the following error message:

  *** Could not deploy package.

  Unable to connect to target server 'XXXX.database.windows.net,1433'.

  Please verify the connection information such as the server name, login credentials, and firewall rules for the target server.

  Login failed for user 'xxxxxadmin'.

  What are we doin wrong here? firewall rules should be ok because we can connect to the target server in Azure

   

   

• Weegee71

  SSChasing Mays

  Points: 604

  More actions

  November 14, 2022 at 8:48 pm

  #4112889

  Hi guys

  I figured this out . Need to create a user to create the database but you must specfy the following :

  EXEC sp_addrolemember 'dbmanager', 'Ci';

  EXEC sp_addrolemember 'loginmanager', 'Ci';