May 30, 2017 at 9:32 am
Hi,
I'm testing a distributed deployment pattern of WAP with SQL 2014 to provide database as a service on private cloud.
Everything appears to be working ok and I can create a new database with a test tenant, however the db owner is a user called SqlResourceProviderLogin so when I login as the test db admin user and try to create some objects I get a warning that i'm not the owner and creation of a table (for example) fails. EDIT - My mistake. Thought it failed. Tried again and it was just a warning and if you clicked ok it would create the objects.
When I create a database through the management Portal it prompts me to provide a db admin user and password for this database and I would expect this user to be the owner or at least have permissions assigned that it can be used without further config.
I can manually grant permissions so that it works but my understanding is that this should be transparent and require no admin intervention.
Has anyone else been through this? Have I just missed something basic ?
Cheers!
Stu.
May 30, 2017 at 10:13 am
Odd. It only throws the warning up when using the GUI.
Run a script to create objects and it's ok.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply