I am trying to install a application with Azure SQL database as back end database. I setup a Azure SQL Server first, got a admin account dbadmin with password, tested it, I can use Management Studio to connect to the SQL server and run "create database testdb1" to create a new database.
but when I run the the application installation file, it throw out a error
Error - DB Creation Error: Invalid object name 'master.sys.master_files'.
I think the installation binary is doing something extra like read the sys.master_files, but in Azure SQL database, seems the customer owned dbadmin account doesn't have that permission:
If I run "select * from sys.master_files;" in management studio connected to the Azure SQL server's master database, I go a error: "Invalid object name 'sys.master_files';"
If I run "select * from sys.master_files;" in management studio connected to a local SQL server's master database as sa user, it shows all the database name.
Is there a way to get full permission on the Azure SQL server owned by us? If not, that seems to be big limitation and many applications will not be able to use Azure SQL server.
- Edited by Jack Chen(Dell) Monday, March 23, 2015 8:09 PM