ASG 2018 connection to SQLExpress DB

[sebastien Chanson]

Hi,

I can see if you use the correct server name? Perhaps you have used an instance name too? Like Servername\SQLExpress? If you have TCP/IP enabled and your firewall allows connections to your server it should work - did you check that the user you are using is allowed to access the database?

And port number can be specified by using SERVERNAME:PORT - why should it not work?

I found out what my mistake was. When creating the sqlexpress db with ASG a user sa is created for the database I had to use that user to define the connexion to the DB and not the user setup in asg security groups.

Thanks for your help