AdComplete.com, LLC
Celebration, Florida 34747
407-551-0777 Phone
 
 
 
 

>> NullReferenceException: Object not set to an instance of an object

 
 
If you are receiving NullReferenceException: Object not set to an instance of an object then Ban Man Pro is unable to connect to the database.  To track down the real cause of the database connection error, please follow these steps:
  1. In the folder where Ban Man Pro is installed, temporarily rename Global.asax to Global.asax1
  2. Now in your browser load the testconnection.aspx file.  A more explicit error should be displayed.
  3. Attempt to resolve the issue.  Either the database connection string is wrong in web.config, or there is a configuration error on your SQL server.
  4. Once the issue is resolved, TestConnection.aspx will return "Success!".  After this you must rename Global.asax1 back to global.asax.

Some things to pay attention to if you are using SQL 2005:

  • If using SQL 2005 and your SQL Server was installed using an instance name, you must connect using SERVERNAME\INSTANCENAME
  • Make sure that when you created the SQL user you unchecked the password options that require changing your password or enforcing the expiration.
  • Make sure the SQL user was made the DBO as shown below:

 
 
 
 
 
 
Copyright 1999-2015 AdComplete.com, LLC All Rights Reserved