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:
- In the folder where Ban
Man Pro is installed, temporarily rename Global.asax to
- Now in your browser load
the testconnection.aspx file. A more explicit error
should be displayed.
- Attempt to resolve the
issue. Either the database connection string is wrong
in web.config, or there is a configuration error on your SQL
- 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: