CODEWITHSUNDEEP
phpsqlazure
Jeroen
Jeroen

Reputation: 241

Can I use: MyWebSQL with an AZURE SQL database?

I'm trying to get web access to my windows azure sql database (since the default web interface seems to be dropped).

Now I installed MyWebSQL and it looks like I'm connected to my host, but the page that follows is blank.

I edited the servers.php file and added the following code to the list:

'AZURE SQL' => array(
                  'host'     => 'ukwxkawvg1.database.windows.net',
                  'driver'   => 'sql'
               ),

What am I missing and is it even possible?

Upvotes: 1

Views: 115

Answers (2)

evilSnobu
evilSnobu

Reputation: 26344

If it can connect to a "classic" Microsoft SQL Server, it should also work with Azure SQL.

Make sure you have the Public IP address of your MyWebSQL's server whitelisted with Azure SQL Firewall. See my other answer here on how to do that: https://stackoverflow.com/a/39310428/4148708

I would also turn on PHP error logging for MyWebSQL. Maybe that white page is not that white with errors turned on.

Upvotes: 1

Jeroen
Jeroen

Reputation: 241

Seems that it isn't possible and I've got to use SSMS.

msdn.microsoft.com/en-us/library/mt238290.aspx

Upvotes: 0

Related Questions