07-02-2019, 02:39 PM
(07-02-2019, 02:28 PM)DevOma Wrote: New database - but I want to know did you create the database within ASGRD - in environment setup you can choose to "Create a new database" - then a new database is created and all schema definitions and stored procs are created to access the database - or did you choose to "Connect to an existing database" and choose an empty database on your SQL instance? That won't work…
If you have Administrator rights on the database server you should be able to access the database you just have created before. Did you create the database from the same machine using the same account?
And AZURE SQL Database should also work - if you create the database by the wizard after choosing "Create new database using AZURE SQL"
Hello,
I created the databases (PaaS and IaaS) first, added the relevant security then tried to connect.
I will try re-creating the PaaS from scratch. We tend to create PaaS database with their own backend server at the same time, however if I use ASG
I will have to put the database on an existing backend server. I'm not 100% sure "backend" is the correct terminology for what I mean so I have attached
a screenshot