The database connection information is not correct. To verify this information, check the PPM\Mariner\web.config file. The connections are listed at the bottom.
When run report from Visual Studio or Report Server, get error "A connection cannot be made to the database . Object reference not set to an instance of an object"
Creating a connection to an existing database gives this error: Could not add database connection.; Could not add database connection.; System.Web.Services.Protocols.SoapException: Could not add database connection.
Open the PPM Administration tool and Click New ( If you're running Windows 2008 right click on the PPM Administration icon and choose to "Run as Administrator" or you might get an error saying "Logon Failed: Unable to connect to database " when you finish.) Name the connection Click the "Only Connection" radio button
If you try to use the admin tool with PPM 10.2 and create a new connection but specify to create the database and tables you get an error that says "Value cannot be null" Parameter name: path1 and the db doesn't get created.
On the left menu select the Database Setup option Click the Connect button and enter the server name and credentials for the new sql server where you restored the backup to.
Before you can complete many of the functions within the Mariner Connector for Microsoft® Project, you must be connected to a Mariner database . If you are not already logged on to the Mariner Connector for Microsoft Project, and you try to complete a task that requires you to be connected to a Mariner database, the Mariner Connector Logon dialog box automatically appears.