Has anyone connected ReportPlus to SQL Azure yet?
I am trying but getting frustrated.
I have used "whatsmyip.com" to find out my Ipad's IP address, and added it to the firewall rules in Azure.
I then created a connection using the following steps:
Then in the account section:
I deleted the "no credentials" account
I added a new one with no domain but the standard username/password that I know connects to the database.
I then get an error message "connection fails with the following error message: could not find stored procedure 'sp_databases'
I tried a different hostname:
Then I got a different error message: "connection fails with the following error message: Instances YYYYYYYYY not found on server XXXXXXXX"
I tried changing the username to ZZZZZZZ@YYYYYYYY but that didn't work either - I got a "server name cannot be determined"
Finally I changed the username to ZZZZZZZZ@XXXXXX but still no joy.
Has anyone done this successfully?
I must be doing something wrong!
I fixed it myself.
ReportPlus calls a procedure called sys.sp_databases when connecting to SQL.
This call isn't supported on Azure, so I made up my own stored procedure.
It can be created in your database, it doesn't need to be called sys. or be in the master database.
create procedure [sp_databases] as
set nocount on
'yyyyyyyy' DATABASE_NAME ,1 DATABASE_SIZE ,'x' REMARKS
I am glad that you have manage to fix it. Thank you for sharing your solution!