HI all,
I downloaded and installed Splendid 2.1 open source on W2k3 server running IIS.
The install feature for Splendid, letting it install SQL 2005, fails, b/c the password for 'sa' that is entered somewhere does not confirm to SQL security...it appears it's trynig to put in splendid2005 as the password. Being new with Splendid, I don't know what file can be changed to set the sa password to anything else. So...
I installed SQL 2005 express seperatly, created the SplendidCRM database as per another instruction on the forum and the deployment guide, I also created a user for the SplendidCRM database.I then went through the install of Splendid and it appears to have worked, I can check the SplendidCRM db and there are tables that exist. However, when I go to the URL to load Splendid, I get a
screen. As you can see I'm getting an error at this stage. According to the Users table in Splendid, the username should be admin and password is NULL -- this doesn't work, neither does putting in sa and the password I assigned to sa or the new user I had set up when I installed SQL 2005 Express.
Does anyone know what I can look at to log into Splendid?
Thanks.
Hi all,
I got the issue sorted out. Came across a message on another site and it said that the admin p/w was admin That got me in. :)
As a side note, hopefully someone knows how to do this. I want to say create 5 users (employees), but I don't want these 5 employees to see each other when they click on the 'employees' button nor do I want them to see each other contacts. In essence, I want to isolate each employee from one another, have their incoming email only display for them (not the current all employees email when you click on the 'emails' module and make sure they can only see their contacts (unless a user wants to add an 'employee'...then we can set a group for the two users.
Let me know if you need clarification.
Tnx.
Did you have some version of SQL Server 2005, possibly the Management Studio, on the machine before installing SplendidCRM the first time? We have tested the install of SplendidCRM on a clean machine and the SQL security does not restrict the password. Could this restriction be coming from a domain policy?
I'm glad to hear that you solved the problem, but I would appreciate a little more information so that we can try to resolve the issue for future customers.
Yes there was a previous install of SQL 2005 that was used to try and install Sugar 5.0 & 5.1 (both I was never able to install). so I ran the uninstaller for Sugar, then removed SQL 2005 and started from scratch with the installer for Splendid 2.1. At one point, there is a window that appears that gives you a running status of what is occuring. One of the lines contained SAPWD=splendid2005 Later when the step (of what I'm assuming) is the database being created (prior to the tables, sp, etc being generated), I receved the error.
I remember from working with SQL on several other unrelated projects, user passwords including SA need to be strong (i.e. at least one Capital, one small case, one digit and/or a special symbol !#?) When I removed Splendid and the SQL database again and then installed SQL 2005 Express myself, I could at least complete the Splendid 2.1 install...problem just lied with the admin/admin login. Not sure why the 'Users' table showed NULL for the admin user though for the p/w.
