SQL Configuration Errors



  • we are using two servers for our deployment and can not get a connection to the DB

    mssql DB is located at sql.dmz.int.wakkawakka.us
    dbname - TheOpenEm DB User -
    site is located at em.wakkawakka.us

    IIS host shares exchange frontend and other iis related web hosting.

    reason for seperation is the fact we run sql in house for other applications and have it on a dedicated server (24 cores 256gb ram)

    i am constantly getting this error during the verifydb...

    Win32Exception (0x80004005): The system cannot find the file specified]

    [SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server.

    connections string configuration

    <connectionStrings>
    <remove name="LocalSqlServer" />
    <!-- Microsoft SQL Server EXAMPLE -->
    <add name="toems" connectionString="Data Source=sql.dmz.int.wakkawakka.us;Initial Catalog=theopenem;Integrated Security=False;User Id=openem_db_login;Password=??IllNeverTellYou!!;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

    As I just started the MSP side of the business any help would be greatly appreciative!



  • Did you add a firewall exception on your sql server to allow your Theopenem server in?



  • yes firewall is disabled in windows and dmz rules have been expanded for necessary ports for lan / wan access to IIS front end... we are running ms sql 2016.



  • finally found the issue...

    connectionString="Data Source=sql.dmz.int.wakkawakka.us/"INSTANCE NAME HERE";



  • new error when logging into the UI...

    [JsonReaderException: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.]
    Newtonsoft.Json.JsonTextReader.ParseValue() +1212
    Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter) +106
    Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent) +795
    Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType) +261
    Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) +170
    Newtonsoft.Json.JsonConvert.DeserializeObject(String value, JsonSerializerSettings settings) +53
    Toems_ApiCalls.TokenApi.Get(String username, String password) +1253
    Toems_FrontEnd.Default.WebLogin_Authenticate(Object sender, AuthenticateEventArgs e) +997
    System.Web.UI.WebControls.Login.AttemptLogin() +144
    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +107
    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +50
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5028



  • Is your application api url correct in the UI web.config?