Thursday, November 20, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Plug-in and Platform Forums  MS SQL Server Database  SQL Server Data...
 SQL Server Database Services setup problem
 
john_y71
2 posts
Joined
8/4/2007

SQL Server Database Services setup problem
Posted: 04 Aug 07 10:11 AM

hi,

while running the setup for splendidcrm 1.4, I encountered the following error,

"The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online."

Does anyone know how to resolve this issue?

thank you

John

john_y71
2 posts
Joined
8/4/2007

Re: SQL Server Database Services setup problem
Posted: 04 Aug 07 12:44 PM

hi,

I was able to download SQL Server 2005 expression edition separately, create a sa account, and attached it to splendidCRM.

all looks ok,

thanks

John

support
2094 posts
1st
Joined
1/3/2006

Re: SQL Server Database Services setup problem
Posted: 04 Aug 07 5:43 PM

SplendidCRM does not require that you use the SA account, but we do doing our default installation so as to avoid access rights issues.  The SplendidCRM install requires the ability to create tables, create functions, create views and create procedures.  We encourage you to create a user specific to SplendidCRM, just ensure that it has all the rights necessary.

 

bg
23 posts
Joined
8/3/2007

Re: SQL Server Database Services setup problem
Posted: 16 Aug 07 7:48 PM
I was almost too embarressed to post this but I went through the configuration dialogs and manually changed the connection string to my default SQL2005 instance "SQLEXPRESS". The configuration program connectd and created all of the schema. Wow I was excited. I imported data and thought I was done. The next do I bootup my computer and cannot find the database in sql or in ant directory that I logically thought it might be. Is there a different directory that SQL2005 will save database files to. I really felt stupid. Any ideas?
support
2094 posts
1st
Joined
1/3/2006

Re: SQL Server Database Services setup problem
Posted: 16 Aug 07 8:50 PM

Just search for all files *.MDF.  Also, check the connection string.  It is possible that you created the tables in the Master database.

 

  Plug-in and Platform Forums  MS SQL Server Database  SQL Server Data...

Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.