Yep, that sounds about right. I'm also checking with Microsoft regarding this and will post any new info here. Much appreciated all!!!

I think I know what the problem is; it's not the use of VS2013 per se but certain restrictions which are built in to VS around Azure and probably lagging...

What I've done is imported a database which is currently hosted in Azure SQL Database (Paas) into VS2013; I imported it as the Source database into a Database Project.

Now, I...

I would agree, the table definition is indeed:

CONSTRAINT [<...>] PRIMARY KEY NONCLUSTERED

...but this DDL I extracted directly from the database which is currently sitting in Azure SQL...

I've discovered that VS2013 does support SQL Azure Database. Obviously the licensing implications of upgrading are not insignificant.

Good call, thanks Grant. I was intending to include the scripts in the Project but the issue with Azure SQL Database syntax around CREATE LOGIN means you cannot wrap any...

Ah, thanks Grant, I guess that lends considerable weight to my design choice of independent database. I understood it that Federation will be cut from Web and Business editions,...

We are struggling with this at the moment. We cannot utilise an Azure Private Network (APN) as the Azure SQL Database cannot be placed within it (we were hoping that...

Grant

How can the WASD Firewall be configured to allow Azure Weblications? They are internal to Azure with no external IP?

Thanks Grant. That is helpful info even if it's a 'no'!

How would one configure the Azure SQL Database firewall to allow an Application hosted in Azure PaaS to connect?...

This one plays with my mind.

On the one hand it gives a demonstration of how not to write code and explains why by giving an useful insight into the way...

Again, you are right; Local database accounts are exactly that, they cannot authenticate in other instances (or servers).

Generally, it is very bad security practice to even have the sa account...

yes, you are right, that is absolutely the case that VS is using my local client account and SSRS is using its own User account. It does appear that User...

Quick Update: (I've not been able to work on this for two days)

This problem is due to User Permissions but I have yet to work out why (it's basically the...

I'm currently investigating a report under similiar circumstances. It works perfect in Visual Studio 2008 but after it's been deployed to SSRS the new parameter I added fails to return...