Hi, it turned out that the live server was sitting on different network partition, not on the cloud. I am sorry for that. It is worth noting that i am not the admin for the Windows AD Server, hence i was unable to add CMSADProvider key to membership and CMSADRoleProvider to rolemanager section. The live server use Windows 7 ultimate.
Here's my web config for the connection string configuration.
<connectionStrings>
<clear />
<add name="CMSConnectionString" connectionString="Data Source=XX;Initial Catalog=Kentico8;Integrated Security=False;User ID=sa;Password=abc@12345;Connect Timeout=60" />
<add name="CMSADConnectionString" connectionString="OU=xx,OU=xxx,OU=xxxx,DC=xx,DC=net" />
</connectionStrings>