Just moved SQL DB to Remote Server ... now new Collections can NOT be created ?? RRS feed

  • Question

  • Hi,

    We have an SMS 2003 primary child site that was running out of CPU memory, so we moved SQL from the primary to a remote server using this procedure:  http://technet.microsoft.com/en-us/library/cc180494.aspx

    Now the site seems to be functioning fine except for the fact that New collections created on the parent site are not displaying on the child primary.

    An error is seen:


    ccollectionSource_SQL could not execute SQL cmd exec sp_trasfermembership

    any ideas?


    Saturday, May 14, 2011 2:18 PM


  • collation order on the old and SQL is not the same.
    Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
    • Marked as answer by y2kBug_sp7 Monday, May 16, 2011 12:52 PM
    Saturday, May 14, 2011 3:12 PM
  • Thanks for everyone's help.  As it turns out I was able to fix the collation problem by running SQL utility Rebuildm.exe (for SQL 2000)




    This utility allows you to change the Collation...


    Thanks all... SMS is now working great...

    • Marked as answer by y2kBug_sp7 Monday, May 16, 2011 12:52 PM
    Monday, May 16, 2011 12:51 PM

All replies