Wednesday, November 19, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  General Discussion  Problem attachi...
 Problem attaching database to sql2000
 
glennbtn
4 posts
Joined
4/28/2008
Problem attaching database to sql2000
Posted: 28 Apr 08 4:06 AM

I am following the splendidcrm 2.0 deployment guide to use this on my existing sql2000 server. I can't seem to attach the database as every time i do i get the following error

error 602. Could not find row in sysindexes for database ID8, object ID1, index ID1. Run DBCC CHECKTABLE on sysindexes.

I can't do this as I can't mount the database so does anyone have any ideas?

Cheers
support
2090 posts
1st
Joined
1/3/2006
Re: Problem attaching database to sql2000
Posted: 28 Apr 08 10:47 AM

We no longer support attaching the MDF and LDF files to SQL Server 2000 as we have upgrade the core database files to the SQL Server 2005 format.  However, you should be able to install SplendidCRM into a clean SQL Server 2000 file database.  We need to update our documentation to relect this change.
glennbtn
4 posts
Joined
4/28/2008
Re: Problem attaching database to sql2000
Posted: 28 Apr 08 11:03 AM
How can install in to a clean sql 2000 database. I have tried publishing wizard but it falls over with encrypted user data from the basic install database
support
2090 posts
1st
Joined
1/3/2006
Re: Problem attaching database to sql2000
Posted: 28 Apr 08 11:47 AM
Create a new database in SQL Server 2000.  Run the SplendidCRM Configuration Wizard and connect to the new database.  The Wizard will create all necessary SQL objects.  Just make sure that the SQL user you provide has permission to create tables, functions, views, procedures and triggers.
 Page 1 of 1
NextPreviousNo Rating
  Mainstream Forums  General Discussion  Problem attachi...
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.