Hola que tal! lo que quiero hacer es lo siguiente:
Quiero mudar a otro vps el xampp + la MuCore para poder sacarla del mismo VPS donde esta el servidor.
Configuro todo:
/*------------------------------------------*\
| Server Databases: |
| |
| 0 : MuOnline [database] |
| 1 : MuOnline and Me_Muonline [databases] |
\*------------------------------------------*/
$core['server_use_2_db'] = "0";
##############################################
/*-------------------------------------*\
| MUCore SQL Connection Type: |
| |
| MSSQL : Connect using mssql_conect() |
| ODBC : Connect using odbc |
\*-------------------------------------*/
//$core['connection_type'] = "MSSQL";
$core['connection_type'] = "MSSQL";
#########################################
/*--------------------------------------------------*\
| MuOnline Database Connection Settings |
| |
| $core['db_host'] : Database host address |
| $core['db_name'] : Database name |
| $core['db_use'] : SQL Authentication user |
| $core['db_password'] : SQL Authentication password |
\*--------------------------------------------------*/
$core['db_host'] = "xxxxxxxxxxx";
$core['db_name'] = "MuOnline";
$core['db_user']= "sa";
$core['db_password'] = "xxxxxxxxxxx";
######################################################
/*------------------------------------------------------------------*\
| NOTE: |
| Edit this only if $core['server_use_2_db'] value is set to 1, |
| this mean your server use MuOnline and Me_MuOnline databases. |
| |
| Me_MuOnline Database Connection Settings |
| |
| $core['db_host2'] : Database host address |
| $core['db_name2'] : Database name |
| $core['db_use2'] : SQL Authentication user |
| $core['db_password2'] : SQL Authentication password |
\*------------------------------------------------------------------*/
$core['db_host2'] = "xxxxxxxxx";
$core['db_name2'] = "MuOnline";
$core['db_user2']= "sa";
$core['db_password2'] = "xxxxxxxx";
Pero en el paso 2 me sale: Connection with MuOnline Database Failed - Fix this.
Lo mas raro de todo esto es que instale el mu maker en el vps nuevo y me conecta a la base de datos del server.
Tengo el puerto 1433 abierto.
Tengo SQL 2000 (SIN EL SP4)