Hello,

Generating an initial database has nothing with the credentials. Try to listen for LoadSchemaCompleted or LoadCubesCompleted events and check the arguments for an exception. Probably in SSAS you need to have a role which to give an access to the user specified in the network credentials.

If you want to play with roles there is an option to restrict the access just to the roles you want:

Create a connection settings as follows

<olap:XmlaConnectionSettings x:Key="xmlaSettings"

                                ServerUri="http://[your server name]/olap/msmdpump.dll"

                                >

    <olap:XmlaConnectionSettings.DiscoverProperties>

        <olap:XmlaQueryProperty PropertyName="Roles" Value="[PlaceYourRolesHere]"/>

    </olap:XmlaConnectionSettings.DiscoverProperties>

    <olap:XmlaConnectionSettings.ExecuteProperties>

        <olap:XmlaQueryProperty PropertyName="Roles" Value="[PlaceYourRolesHere]"/>

    </olap:XmlaConnectionSettings.ExecuteProperties>

</olap:XmlaConnectionSettings>

and pass these settings to you XmlaDataSource.ConnectionSettings propery.