x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 74 subscribers
  • Views 376 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
sokheng.siv@gmail.com

How to separate the pages and database to different server ?

Posted By

Hello, Can anyone tell me how can i move my CRM database to another server ? I have tested a way is that i move my database to another pc (pc name : DataServer) . i go to Administrator > System > Database and change Default Database Server (SQL Server Only): to "DataServer". Than i log out and log in again . It shows a message let me to re-create view. I have followed that but it still doesn't work.

So can anyone tell me how to that ?

Thanks.

/Sokheng

  • 0

    Go to the system log, and look at the error being written there. The 'you may need to recreate views manually....' error can mean one of many things.

  • 0

    Hi Sokheng,

    As Toby says - could be a number of things.. start with the basic though - Stop IIS and go into the SQL CRM database and delete the vSentinel View. It will be recreated upon starting up CRM again. If the error is still there, check the custom_sysparams for the database server name - Select * from custom_sysparams where parm_name like '%server%' Going on memory here :)

    Check the server is the new server name (DataServer) and if not, update the parm_value to the correct server name.

    I suspect the second option is the culprit here as you have moved the database across to another server.

    Good Luck Sokheng!

    Regards,

    Penny Vaskess

  • 0

    Look in your registry and make sure the following keys are correct to your new database instance; any of these could now be wrong since it sounds like you migrated the db to a totally different SQL instance. Make sure to reset IIS after making any changes to these.

    DatabaseTcpPort

    DatabaseUserID

    DefaultDatabase

    DefaultDatabaseDriver

    DefaultDatabaseServer

*Community Hub is the new name for Sage City