Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

MDS error: HttpWebRequest WebException RemoteServer : Arguments:NotFound.

Discussion in 'Products running on SQL Server' started by Peter Schmitz, Mar 10, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Today, we ran into an issue when attempting to connect to MDS on our production server. MDS itself opened up fine, but when clicking on "Explorer", we were greeted with an ugly error message:

    [​IMG]

    The error message conveniently cannot be copied/pasted.

    As it turns out, this error was caused by our production server passing a memory threshold, causing MDS not to properly load. To troubleshoot this, we directly connected to the MDS service endpoint powering MDS (i.e. http://<servername>/MDS/service/Service.svc?SingleWSDL).

    There, we were greeted with the following error:

    We resolved the issue by reducing the max memory setting of SQL Server. This was done by using the following command :

    Code (TSQL):

    EXEC sys.sp_configure N'max server memory (MB)', N'45000' -- was 50000
    GO
    RECONFIGURE WITH OVERRIDE
    GO
     

    Changing this setting takes effect immediately, and does NOT require a reboot.
    Last edited: May 16, 2017

Share This Page