Hello All-
We are upgrading our SDE to version 10.1, & I am having issues with error messages while running the Update Geodatabase Tool. Here's what we've done so far: Our IT person installed ArcSDE (10.1) on our new server (windows 7, SQL 2008 R2). We backed up the 9.3.1 db & restored it on the new server (setting compatibility to SQL server 2008 (100) after restoring). I created our two user logins (sde & gisadmin) & resynched them using the stored procedure SP_Change_Users_login.
I went back to my machine, added a direct connection to the new gis server (actually added two, one for sde & one for gisadmin). Now when I open ArcCatalog & try to run the Update Geodatabase tool, several issues arise:
If I run the tool under either login (our original db was created w/o any documentation but I believe sde is the owner), I get 3 error messages: "Could not pause the database." "Cannot upgrade because there are other active connections" (& then it lists the other connection - more about that in a bit). Also, "User does not have required privileges to upgrade - user must be dbo to upgrade a geodatabase."
Initially I tried it using our sde user, then I disconnected from the gdb & connected as gisadmin user & tried running the tool under our gisadmin connection. That's when the error message will say "..Other active connections" & it returns the sde user like that one is still connected. If I reboot my computer & run it I do not get the 'other active connections' error but I do get the unable to pause db & insufficient privileges errors.
My questions are: why is this happening? Why do I have to reboot in order to make the tool realize there are no other connections? Do I need to add other logins - sa or dbo, for example, & then resync them? Do I need to stop the sde service before running the tool? (that one doesn't make sense but I do get that error about unable to pause the database).
Am more than a bit lost at this point.
Thanks in advance!