Richard is correct. Please allow me to elaborate on the why. The ioapplication, ioadministrator, and project databases were imported onto another database. Whatever the user the DBA used to import becomes the database owner.
Lets say user A was used to import. In RDServer.ini, user B is configured to access the database. Two things one can do: 1. make user B have access to the database 2. user user A in RDServer.ini. Good luck, -Jian On Oct 29, 6:59 pm, Richard Hauer <[email protected]> wrote: > Check user permissions in SQL forRedDotUser against your project DBs. > > Regards, > Richard. > > Sent from my mobile. Sorry if it's brief. > > Johnny <[email protected]> wrote: > > Hi All, > > We moved all our Reddot databases to a new server today but we > encountered an issue. None of the projects in Server Manager->Administer > Project->Project cannot access the database for some > > reason. I see (database server not available) next to the project > name. The tested the database connection in Admin Database Server->Server > Connection and it told me there isn't any issue connecting to > > it. I assigned all the project to that database connection but I still > couldn't connect it for some reason. Any help and advice is > appreciated. > > Thanks, > > Johnny > > -- > You received this message because you are subscribed to the Google Groups > "RedDot CMS Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/reddot-cms-users?hl=en. -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
