 bart
|
 |
| Joined: 11 Mar 2009 |
| Total Posts: 2 |
| |
|
Database connection issues
Posted: 11 Mar 2009 06:43 AM |
When I try to login the following error message is displayed:
"Project Assistant license cannot be validated. The connection to the database may not be established or license information may be invalid or the trial period expired."
How can I solve this?
|
|
|
 |
|
Bogdan
|
|
 |
| Joined: 01 Feb 2008 |
| Total Posts: 17 |
| |
|
Re: Database connection issues
Posted: 11 Mar 2009 07:27 AM |
There are a couple of general reasons while you may not be able to establish a connection to the database that we will describe and explain.
If none of these reasons apply to you than please send us the following information:
1. The version of OxyProject Assistant that you installed (the latest version in 2.6.6)
2. The database manager (name and version) that you use (SQL Server (2000, 2005), SQL Server Express, SQL Server 2000 Desktop Engine (MSDE) and Access (Jet Engine)). We would stringly recommend to not use MS Access if you are planning to use the web version of the product
3. If you use MS SQL Server or MS SQL Server Express the authentication mode (Windows or SQL) that you configured on installing the web version of the product.
Let us get back to your connectivity issue.
The error message that is reported is typically caused by the connection string settings. OxyProject Assistant connot establish a connection to the database due to connection/security settings that are setup on your environment.
The connection string can use 2 authentication modes:
1. SQL Authentication
A SQL login is configured to be used on connection to the database. This SQL login needs to have credentials to run SQL scripts against OxyProject Assistant database
2. Windows Authentication
The Windows account under wich the ASP.NET worker process runs needs to have credentials to run SQL scripts against OxyProject Assistant database
OxyProject Assistant release notes (http://www.techinceptions.com/FileResourceDownload.aspx?code=opaInstallNotes) describes the connection string settings and how to manually configure it (look for the paragraph: "To manually configure your Project Assistant database settings follow these steps").
We would suggest to use SQL Authentication to connect to the database so in this case it would not matter what is the Windows account configured to run the ASP.NET worker process. The following link describes how to create/configure a SQL login: http://msdn.microsoft.com/en-us/library/aa337562.aspx for SQL Server 2005/2008. You may find similar material on the Internet for other SQL Server versions.
|
|
|
|
|
bart
|
|
| Joined: 11 Mar 2009 |
| Total Posts: 2 |
| |
|
Re: Database connection issues
Posted: 11 Mar 2009 10:19 PM |
Got it working!
Thanks for the detailed answer. |
|
|
|
|