Hi
I have this problem when trying to deploy to AppEngine. On local machine 
using proxy it works fine.

Microsoft.EntityFrameworkCore.Database.Connection[20004]
A network-related or instance-specific error occurred while establishing a 
connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured 
to allow remote connections. (provider: TCP Provider, error: 40 - Could not 
open a connection to SQL Server)
An error occurred using the connection to database 'dblivtron' on server 
'cloudsql'.

My config:
Appengine Flexible API = enabled
Cloud SQL Admin API = enabled
Instance public address = enabled

Instance Connection Name: livtron-testproject:europe-west1:livtrondbinstance
Data base: dblivtron

My app.yaml:
runtime: custom
env: flex
manual_scaling:
  instances: 1
resources:
  cpu: 1
  memory_gb: 0.5
  disk_size_gb: 10
beta_settings:
  cloud_sql_instances: 
livtron-testproject:europe-west1:livtrondbinstance=tcp:3306
  
My connection string in appsettings.json  
  "ConnectionStrings": {
    "DefaultConnection": "Server=cloudsql;Database=dblivtron;User 
Id=sqlserver;Password=#####;MultipleActiveResultSets=true;Encrypt=false;Pooling=true;"
  },

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/cc11f1c2-3147-4cc2-b9bf-b52a573e820en%40googlegroups.com.
  • [google-appengine]... Krzysztof Patra

Reply via email to