[AccessD] Article: "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"

 Hi Gustav --

AFAIU Sharepoint uses Azure SQL Databases. Yes, you can migrate normal SQL Server database to Sharepoint (Azure SQL Database) for the use as the backend to an Access desktop frontend. But there are some limitations. Here is a set of links describing migration process(es) and limitations:

Comparison of SQL Server with Azure SQL Database
http://social.technet.microsoft.com/wiki/contents/articles/996.comparison-of-sql-server-with-azure-sql-database.aspx

Migrating Databases to Azure SQL Database
http://msdn.microsoft.com/en-us/library/azure/ee730904.aspx
How to: Use the SQL Database Migration Wizard
http://msdn.microsoft.com/en-us/library/azure/jj156144.aspx
Azure SQL Database Transact-SQL Support
http://msdn.microsoft.com/library/azure/ee336250.aspx
Azure SQL Database Tools and Utilities Support
http://msdn.microsoft.com/library/azure/ee621784.aspx
I have tried to connect to the Azure SQL database from MS SQL Server Management Studio 2012 but I have failed:

"Cannot connect to {SQLAzureServerCode}.database.windows.net
Additional Information:
Cannot open server '{SQLAzureServerCode}' requested by the login. 
Client with IP address 'xxx.xxx.xxx.xxx' is not allowed to access the server.
To enabled access, use the Windows Azure Management portal or
run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or
address range. It may take up to five minutes for this change to take effect.
Login failed for user '{UserName}'. This session has been assigned a tracing ID of '{tracingId}'.
Provide this tracing ID to customer support when you need assistance. (Microsoft SQL Server, Error 40615)"

When I tried to execute sp_set_firewall_rule I have found that SQL Server 2012 master db doesn't have it - I have to install MS SQL Server 2014 (Express)....

Thank you. -- Shamil

Wed, 5 Nov 2014 21:33:39 +0000 from Gustav Brock <gustav at cactus.dk>:
>Hi Shamil
>
>I haven't done so but it looks interesting as the web based Access apps are so limited. This could be the best of both worlds regarding Access desktop applications.
>
>A simpler option is, of course and also noted in one of the comments to the article, to use a "clean" SQL Server account on Azure. 
>
>By the way, can an existing database from a normal SQL Server be exported to SharePoint for the use as the backend to an Access desktop frontend?
>
>/gustav
>
>________________________________________
>Fra:  accessd-bounces at databaseadvisors.com < accessd-bounces at databaseadvisors.com > på vegne af Salakhetdinov Shamil < mcp2004 at mail.ru >
>Sendt: 5. november 2014 21:01
>Til: Access Developers discussion and problem solving
>Emne: [AccessD] Article: "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"
>
> Hi All --
>
>Does anybody use "hybrid" MS Access FE/SQL Azure BE (Office 365) applications in production?
>
>"How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database"
>http://www.devhut.net/2014/01/13/how-to-hybridize-your-ms-access-database-in-office-365-azure-database/
>
>I have just followed the referred article's instructions using my Office 365 dev account and I have got a sample "hybrid" database up& running.
>And MS Access 2013 .accdb bound forms have read-write access to the linked via 'ODBC;DRIVER=SQL Server Native Client 11.0;'  SQL Azure database tables.
>I wonder if such .accdb forms can be bound to SQL Azure insert/update/delete stored procedures?
>
>FYI: Here is a good set of information on SQL Azure and MS Access:
>
>http://gainingaccess.net/SQLAzure/AccessAndSQLAzureLinks.aspx
>
>
>Thank you.
>
>--
>Салахетдинов Шамиль
>
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website:  http://www.databaseadvisors.com