Tony, Thank you for your comments. It was because the user who accesses the SQL DB missing sysadmin privileges.
Regards, Kang Lee On Sat, Dec 19, 2009 at 9:38 AM, <[email protected]<reddot-cms-users%[email protected]> > wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/reddot-cms-users/topics > > - Cleaning up live > server<http://mail.google.com/mail/?ui=2&view=js&name=js&ver=GRUts-X5mqs.en.&am=!JjYx-7BZhZy5A3Gi0fgEItqzkxPsWn_YCzbmWkVYDNeMvQ#125a760412eeeb52_group_thread_0>[1 > Update] > - SQL > Error<http://mail.google.com/mail/?ui=2&view=js&name=js&ver=GRUts-X5mqs.en.&am=!JjYx-7BZhZy5A3Gi0fgEItqzkxPsWn_YCzbmWkVYDNeMvQ#125a760412eeeb52_group_thread_1>[1 > Update] > > Topic: Cleaning up live > server<http://groups.google.com/group/reddot-cms-users/t/a1a5b0655adce3cd> > > Josh Carver <[email protected]> Dec 18 08:06AM -0800 > ^<http://mail.google.com/mail/?ui=2&view=js&name=js&ver=GRUts-X5mqs.en.&am=!JjYx-7BZhZy5A3Gi0fgEItqzkxPsWn_YCzbmWkVYDNeMvQ#125a760412eeeb52_digest_top> > > Hello all, > I wondered if anyone has a brilliant way of cleaning up their live > server, and I don't mean Live Server, but web server. > > There is a check box in red dot to clean up live server which is > supposed to delete the pages from your webserver that were deleted in > the CMS. However, this is terribly buggy and is deleting entire > directories from my project. I emailed some other developers and they > too have seen this behavior and no longer use the "clean up live > server" function. > > But I still need someway of auto deleting files off the server to > match whats in the CMS. What I do now is periodically ftp in to the > server and remove files with old publication dates, but the users want > something more immediate, and I am really gambling that what I am > deleting is really meant for deletion. > > Does anyone have a solution for this? > > > > Topic: SQL > Error<http://groups.google.com/group/reddot-cms-users/t/203b6836f3399647> > > TonyGayter <[email protected]> Dec 18 06:44AM -0800 > ^<http://mail.google.com/mail/?ui=2&view=js&name=js&ver=GRUts-X5mqs.en.&am=!JjYx-7BZhZy5A3Gi0fgEItqzkxPsWn_YCzbmWkVYDNeMvQ#125a760412eeeb52_digest_top> > > Your reddot user doesnt have permission son teh sql server, make sure > you have a user with the same name and password that you used to > install reddot with in the sql server security. > > When I install I always make sure I use the same username and password > to create a local admin on both the cms server and the db server and > also a sql user with the same name and password. The user in the DB > should have sysadmin privileges. > > Check your user in the sql server has permissions. > > > > > -- > 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]<reddot-cms-users%[email protected]> > . > For more options, visit this group at > http://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.
