|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/5/2007 Posts: 10 Points: 30
|
I downloaded the 2.0 RC1 trial and I keep getting the following error after the SQL database has been created:
Product: eJadSPM System -- Error 27506.Error executing SQL script eJadSPM_Script. Line 67047. Password validation failed. The password does not meet Windows policy requirements because it is too short. (15116)
I've already disabled our password policy on the domain and the local server but that doesn't fix the problem.
Stefan
|
|
|
 Rank: eJadSPM Guru
Groups: Developer
Joined: 11/10/2007 Posts: 29 Points: 108
|
Are you using SQL Authentication or Windows Authentication? Do you get this error after SQL script execution is finished or at start of SQL Script Execution? We recommend to use SQL Authentication mode. Please remove eJadSPM_Db from SQL databases if it is created and uninstall eJadSPM. Reinstall eJadSPM using SQL Authentication. If problem persists then please update. M. Usman Senior Software Engineer Machine Solutions, LLC
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/5/2007 Posts: 10 Points: 30
|
I used SQL authentication as Windows authentication failed immediately. This error happens when the progress bar creating the SQL database is full.
|
|
|
 Rank: eJadSPM Guru
Groups: Developer
Joined: 11/10/2007 Posts: 29 Points: 108
|
Do the error occured when a windows form appeared or even before that? At the end of sqlscript a database user is created named "eJadSPM_Db" with password 'Null'. I think this is the issue. Please execute the script below and tell the result. Code:if not exists (select * from master.dbo.syslogins where loginname = N'eJadSPM_Db') BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'EJadSPM_Db', @loginlang = N'us_english' if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb) select @logindb = N'master' if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english') select @loginlang = @@language exec sp_addlogin N'eJadSPM_Db', N'DBPASSHERE', @logindb, @loginlang END GO M. Usman Senior Software Engineer Machine Solutions, LLC
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/5/2007 Posts: 10 Points: 30
|
I got it working. I created the account then reset the password to nothing and disabled the password policy on it. Reinstalled the product and it's working thanks. Got some other questions though but I will post those later.
|
|
|
 Rank: Management
Groups: Administration
, Member
Joined: 11/11/2007 Posts: 59 Points: 246 Location: Dubai
|
sdevries wrote:I got it working. I created the account then reset the password to nothing and disabled the password policy on it. Reinstalled the product and it's working thanks. Got some other questions though but I will post those later. sdevries I was wondering how is your experience thus far? Any feedback is appreciated Aziz Paracha Vice President/CTOeJadSPM System -- SaaS Enabled Hosted Service Delivery Platformwww.machsol.comWe offer world's only affordable consolidated platform for SaaS providers. Is there a company that beats our pricing? let me know!
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/5/2007 Posts: 10 Points: 30
|
Sorry for the delay I haven't had much time to look at the product. I installed the latest version and got an extention of the eval license (thanks) and now it's working. I'll be testing it further this week and I'm sure I'll have questions then. Some questions I already have:
-How do I import my existing user base that's in HMC into ejdadSPM?
-Will you be adding support for other microsoft products in the future? We would like to see Sharepoint, OCS and perhaps CRM included.
Thanks,
Stefan de Vries
|
|
|
 Rank: Management
Groups: Administration
, Member
Joined: 11/11/2007 Posts: 59 Points: 246 Location: Dubai
|
Hi Stefan: Welcome back and I am sure you are going to enjoy the product during and after the extended trial period. When you finally make the decision of buying the product we will provide you a utility to migrate existing HMC accounts into eJadSPM System. Our future development plans include BlackBerry, MS Dynamics CRM, MS OCS/LCS, and SharePoint services support. You should be receiving news & updates via e-mail and on this forum as we commence new product lines. Aziz Paracha Vice President/CTOeJadSPM System -- SaaS Enabled Hosted Service Delivery Platformwww.machsol.comWe offer world's only affordable consolidated platform for SaaS providers. Is there a company that beats our pricing? let me know!
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 4/1/2008 Posts: 2 Points: 6
|
i haven't installed ejadSPM : the error is "Error 27506. Error executing SQL script SqlScript.Line 288.Violation of PRIMARY KEY constraint'PH_HB_tblBillingCycles'.Can not insert duplicate key in object'dbo.HB_tblBillingCycles'" Hope you will feedback early, i have using trial and i want to buy this product
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 4/1/2008 Posts: 2 Points: 6
|
i have reinstall SQL server , but nothing change ...
|
|
|
 Rank: eJadSPM Guru
Groups: Developer
Joined: 11/10/2007 Posts: 29 Points: 108
|
Please make sure that eJadSPM_Db is not created in SQL server. If eJadSPM_Db is created already and you try to install product using same SQL server where eJadSPM_Db already exists you will get errors. You mentioned that you removed SQL server in later post. Please make sure the location where database files "mdf", "ldf" are placed do not contain "eJadSPM_Db_Data.mdf" and "eJadSPM_Db_Log.ldf". M. Usman Senior Software Engineer Machine Solutions, LLC
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/18/2007 Posts: 28 Points: 84
|
Just a suggestion. When having to do a re-install and using an external SQL server, have the installer remove the previous database including any users it created.
|
|
|
 Rank: eJadSPM Guru
Groups: Developer
Joined: 11/10/2007 Posts: 29 Points: 108
|
We did not remove database on uninstall and reinstall of eJadSPM so that client's valuable data is not removed. M. Usman Senior Software Engineer Machine Solutions, LLC
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/18/2007 Posts: 28 Points: 84
|
Does it get overwritten when using SQL Express and doing a re-install??
|
|
|
 Rank: eJadSPM Guru
Groups: Developer
Joined: 11/10/2007 Posts: 29 Points: 108
|
You mean database objects get overwritten? When you do a re-install, the sql script of database tables, data and stored procedure run again. But as the database objects already exists so error occurs without overwriting existing database. M. Usman Senior Software Engineer Machine Solutions, LLC
|
|
|
 Rank: eJadSPM Learner
Groups: Member
Joined: 12/18/2007 Posts: 28 Points: 84
|
Yes database objects. Other SQL based software I use on re-install will check to see if the db and db user exist and will ask if you want them overwritten. Such a small little thing, but irritating when starting out and having to re-install a few times and then having to go to the db server to remove them manually.
|
|
|
 Rank: eJadSPM Guru
Groups: Developer
Joined: 11/10/2007 Posts: 29 Points: 108
|
Ok we will try to make installer more friendly in future by incorporating option like you stated. M. Usman Senior Software Engineer Machine Solutions, LLC
|
|
|
|
Guest |