Welcome Guest Search | Active Topics | Log In | Register

Installation error Options · View
sdevries
#1 Posted : Wednesday, December 05, 2007 3:22:25 PM

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
m.usman
#2 Posted : Thursday, December 06, 2007 6:34:41 AM

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
sdevries
#3 Posted : Thursday, December 06, 2007 2:59:32 PM

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.
m.usman
#4 Posted : Thursday, December 06, 2007 11:15:05 PM

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
sdevries
#5 Posted : Friday, December 07, 2007 3:56:23 AM

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.
aziz
#6 Posted : Thursday, January 24, 2008 12:50:56 AM

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 Anxious
Aziz Paracha
Vice President/CTO
eJadSPM System -- SaaS Enabled Hosted Service Delivery Platform
www.machsol.com
We offer world's only affordable consolidated platform for SaaS providers. Is there a company that beats our pricing? let me know!
sdevries
#7 Posted : Monday, March 24, 2008 8:59:20 AM

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
aziz
#8 Posted : Tuesday, March 25, 2008 12:27:01 AM

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/CTO
eJadSPM System -- SaaS Enabled Hosted Service Delivery Platform
www.machsol.com
We offer world's only affordable consolidated platform for SaaS providers. Is there a company that beats our pricing? let me know!
ducclo
#9 Posted : Tuesday, April 01, 2008 4:43:39 AM

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
ducclo
#10 Posted : Tuesday, April 01, 2008 4:44:34 AM

Rank: eJadSPM Learner

Groups: Member

Joined: 4/1/2008
Posts: 2
Points: 6
i have reinstall SQL server , but nothing change ...
m.usman
#11 Posted : Tuesday, April 01, 2008 5:42:18 AM

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
webguyz
#12 Posted : Tuesday, April 01, 2008 6:04:51 AM

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.
m.usman
#13 Posted : Tuesday, April 01, 2008 6:11:49 AM

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
webguyz
#14 Posted : Tuesday, April 01, 2008 6:15:55 AM

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??
m.usman
#15 Posted : Tuesday, April 01, 2008 6:24:52 AM

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
webguyz
#16 Posted : Tuesday, April 01, 2008 6:32:13 AM

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.Boo hoo!

m.usman
#17 Posted : Tuesday, April 01, 2008 6:41:02 AM

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
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.3 beta | YAF © 2003-2008, Yet Another Forum.NET
This page was generated in 0.213 seconds.