Well, I'm out of options.

Using the other account to run IE solved all the issues with me, so I have no further experience to share with you.

And if you really log into your computer using that newly created user account and you go to the website, do you still have the same issue?

Did you run IE or whatever browser under the user account that you created?

With AD I mean whatever type of Windows security that you have running 😀

I have installed MDS...

Here you go:

SELECT

c.Name

,c.City

,(

SELECT p.Project_Name...

So you did enable Windows Authentication?

I assume you have full permissions on the underlying database?

During the set-up of your database in the MDS configuration, you need to specify a user-account...

Don't be so quick...

And of the hard drive.

I think installation on a SSD drive will be a lot faster.

Almost 🙂

The sample data in the form of INSERT statements please.

Allright, glad that the issue is resolved and thanks for posting back!

And now the table DDL and sample data (read the first link in my signature).

A diagram won't help me to create the tables and to put data in it;

Please post table DDL's, sample data and your original query.

Also try XML PATH instead of XML AUTO.

Unless I'm mistaken, you will always have that issue.

When you do a failover to another database server, applications/clients always have to reconnect.

Are the servers on a cluster? You could introduce...

Did you restart the SSIS service?

MSDN says:

dtexec Utility

It's a bit vague what they mean with that.

Do...

Packages stored in the MSDB cannot be edited. The purpose is that only finished packages are stored there in orde to be scheduled by SQL Server Agent.

Regarding the dataflow error:...

You can take a backup of the database and restore it on the other server.