Unable to update db for deployment #10179

TimMackey created 3 years ago

ANZ version 8.1.0 Angular/.net core

Following instructions here: https://docs.aspnetzero.com/en/aspnet-core-angular/latest/Deployment-Angular-Publish-Azure Apply Migrations section.

The following error occurs when attempting 'update-database'. Please advise on how to proceed. Thank you.

Package Manager Console:

Each package is licensed to you by its owner. NuGet is not responsible for, nor does it grant any licenses to, third-party packages. Some packages may include dependencies which are governed by additional licenses. Follow the package source (feed) URL to determine any dependencies.

Package Manager Console Host Version 5.9.0.7134

Type 'get-help NuGet' to see all available NuGet commands.

PM> update-database
Build started...
Build succeeded.
RequestId:28362d0d-501a-0068-27a9-1b74df000000
Time:2021-03-18T03:51:27.6418034Z
An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application service provider. Error: The resource doesn't support specified Http Verb.
RequestId:28362d0d-501a-0068-27a9-1b74df000000
Time:2021-03-18T03:51:27.6418034Z
Status: 405 (The resource doesn't support specified Http Verb.)
ErrorCode: UnsupportedHttpVerb

Headers:
Server: Windows-Azure-File/1.0,Microsoft-HTTPAPI/2.0
x-ms-request-id: 28362d0d-501a-0068-27a9-1b74df000000
x-ms-client-request-id: 64972fb1-e660-4a27-8059-175e9ddc04ee
x-ms-version: 2020-04-08
x-ms-error-code: UnsupportedHttpVerb
Date: Thu, 18 Mar 2021 03:51:27 GMT
Allow: REDACTED
Content-Length: 237
Content-Type: application/xml

System.ArgumentException: Keyword not supported: 'perpendere-dev-dbserver.database.windows.net; database'.
   at Microsoft.Data.Common.DbConnectionOptions.ParseInternal(Dictionary`2 parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey)
   at Microsoft.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary`2 synonyms)
   at Microsoft.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at Microsoft.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at Microsoft.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
   at Microsoft.EntityFrameworkCore.Diagnostics.RelationalLoggerExtensions.MigrateUsingConnection(IDiagnosticsLogger`1 diagnostics, IMigrator migrator, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Keyword not supported: 'perpendere-dev-dbserver.database.windows.net; database'.
PM>

for security reasons 'appsettings.json' sent by email.

2 Answer(s)