SplendidCRM Software

Forum 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

2240 posts

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

2240 posts

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

Mainstream Forums

General Discussion

Problem attachi...