Quick question reagarding the design of an MDS solution. If your connecting to a remote SQL Server does that it have to be in the same domain as the MDS server?
Reason I'm asking is that I'm trying to connect to an untrusted SQL server and get the following error when completing Database section of the web configuration;
'user or role '(null)' does not exist in this database'
Thanks in advance
The two servers will ultimately need to access Active Directory from the same domain. In this case, the server could not lookup the supplied user account in AD.
Refer to troubleshooting info here
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?