Cannot login to SelfService - Login failed for user ''

Version 1

    Details

    ITSM/HEAT Service Management 7x with Integrated SQL authentication

    Can configure and connect with client, but cannot access http://servername/selfservice

    Server Error in '/SelfService' Application
    Login failed for user ''

     


    Resolution

    The C:\Program Files (x86)\FrontRange Solutions\Service Management\selfservice\ConnectionStrings.config needs to have the following switch added:

    Trusted_Connection=True;

    For Example:

    <?xml version="1.0" encoding="utf-8"?>
    <connectionStrings>
      <add name="Connection" connectionString="Data Source=servername;Initial Catalog=ITSM;Trusted_Connection=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient">
      </add>
    </connectionStrings>