Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Restore Gemini DB on an onther SQL Server 2000 instanz and run update script

web-app

Hi,

i've some trouble with a sql server 2000 db.
the db uses sql server auth

i make a backup from the DB and take the backup to an other sqlserver, i had
restored the database at ther new server.
i've create the db owner user on the new server and executed
spchangeuserslogin 'UpdateOne', 'username', 'loginname' 
now my gemini application works fine. but i would like to update my gemini db from 2.0.5 to 2.1.1 if, i start query analyzer and login as the db owner and
start a query
select *
rom issues
at the restored db i recieved an error
"Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 1
Ungültiger Objektname 'issues'." means the Object issues is invalid, but the
table exists. the same query on the original db Server is ok i recieved the
right result

i find out, if i run select *
from geminiuser.issues i recieved the right result
run i only issues without geniniuser. before issue i recieved an error.
My Problem is if i run the db update script, i recieved some errors, because the table names will not be found

Many Thanks for your help

labs
· 1
labs
Replies (1)
helpful
0
not helpful


Please see: http://community.countersoft.com/forums/thread/2484.aspx

basically, you need to change the owner of the Gemini tables etc...


Saar Cohen
· 5000
Saar Cohen