Object reference not set to an instance of an object

• calvin_wk_wong

  SSC Enthusiast

  Points: 156

  More actions

  April 14, 2016 at 7:45 pm

  #318117

  I have 2 SQL servers, A and B, both run a program to insert records to DB and runs for years and it is smooth.

  Suddenly, A server report HDD error few days ago, and the insert program return error :

  System.NullReferenceException: Object reference not set to an instance of an object. at MAMessage.Service1.ImpUpdate_Clnt_ResetPass(SqlConnection sqlConn, String strClntCode, String st

  SQL B is running smooth.

  I backup SQL A and restore to a new machine with same IP and config, but the problem still happen, the error message is same.

  Is any problem with the database caused the problem ?

  I think it is not coding error or program error because SQL B running smooth with same program and same SQL config

  I am pulling out my hair, and hope you can give me a good suggestion to solve it

  Thanks

• djj

  SSCoach

  Points: 18831

  More actions

  April 15, 2016 at 5:24 am

  #1872285

  Did you link the new server to B?