This content has been marked as final. Show 6 replies
Hi Nikki and others,
I have tried your suggestions Nikki and failed.
If I look inside SQL Server 2005 under Database EXPADMIN > Security > Users I have dbo, exp, guest, INFORMATION_SCHEMA and sys and the same for Database CMDEMO. Under Security > Login I have exp and sa amongst others. There are no EXPADMIN or ADMIN users/logins inside my SQL Server 2005.
I have followed the Installation and Configuration Guide for Microsoft SQL Server, but when I reach Page 110 I cannot login.
What am I doing wrong?
I do not understand why the exp login with password sql is not working?
With Thanks and Best Regards,
I have tried to install a few times on a couple of Windows machines and also delete/re-create the Group and Expadmin databases.
Inside SQL Server I do not see any EXPADMIN or ADMIN users/logins.
My %JAVA_HOME% is C:\Sun\Java\jre160, which is where I have Java 6u24 JRE installed. (I have JDK installed too).
My database host port is 1405 on 1 Server and 1433 on another.
It is a clean fresh new install. I really do not understand what I'm doing wrong.
My failure to login is consistent.
Run through dbconfigcm.cmd
default location for this is: C:\Program Files\Oracle\ContractManagement_1\utility\CMAdminConfig
This is to set the expadmin database connection.
Once successfully done, then log in to admincm.cmd in same location as above
log in with username exp and password sql
In the primavera administrator utility (admincm.cmd) confirm you have the database groups (under database settings). There should be at least one for admin and one for a group database, but can add several more group ones
I have just logged in to exponline/login.jsp as expadmin/expadmin, EXPADMIN/expadmin and ExpAdmin/expadmin (password has to be lowercase!) By chance... Phew...
(I had uninstalled, reinstalled, deleted databases, recreated databases, etc.) If only Page 110 of the CM 14 Biz Intel Pub Edition install and config gd for MS SQL Server told us this...
Thanks to Nikki and yourself for all your help.
With Best Regards,