ConcourseSuite Support - Discussion - Concursive Corporation

Discuss Data Import and Export

No Access to MS SQL database

You need to be logged in to post messages

No Access to MS SQL database

10/28/2007 4:07 PM EDT (edited)

Last week I lost our Centric system. the only information (thankfully) that I was able to recover was the database from a server backup the day before. all of my resource files web server files etc... were lost!

I have tried fruitlessly to get this database back into a working installation now I have come to my wits end....

I am using the .war (5 seat license) and MS SQL system.
After I complete the installation and setup I attempt to replace the database with my original (same version) database but All I get is a Access: Invalid object name 'access' error.

I have tried to export to csv (useing MS SQL) and re-import the csv's to a new blank db with no success.

I have considered (and attempted ) tring to use the import-db.bsh script but I just don't understand how to use this.

Is there anything that I can do to fix this?!?!? I realy need to get this system up ASAP
At this point If I am willing to try just about anything to get this DB information back into a working database!

1. 10/28/2007 7:25 PM EDT

By jason smith

I found the problem.....

It was mentioned several times though out this web site, and a fix was posted but initally didn't work for me.

Any one that comes across this error

Access: Invalid object name 'access'

I found that it is a DB user name conflict.
Here is how I fixed it:

In MS SQL use this script in the query analyzer

sp_msforeachtable "sp_changeobjectowner'?','dbo'"
commit

You will be warned that this could potentially break stored proceedures but I haven't found anything broken yet!

1 result found