Welcome Guest, Not a member yet? Register   Sign In
SQL Windows Server 2008 R2 and DB connection
#1

[eluser]Unknown[/eluser]
Hi guys, sorry for my english :-P i have a big proble with DB connection, I have been trying for several days but i can't connect it :-(

I have two configuration: local with Xammp and remote on colud with Vesta control panel and in both cases the web page is clean, if i try to see the sorce code of webpage it is clean :-(

i see this post: http://ellislab.com/forums/viewthread/208171/#968268 for the sames problem but i'dont' understand where I'm doing wrong.


This is the profile for xammp:

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = "192.168.1.251";
$db['default']['port'] = 1433;
$db['default']['username'] = 'my_username';
$db['default']['password'] = 'my_password';
$db['default']['database'] = 'my_db_name';
$db['default']['dbdriver'] = 'mssql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;


This is the profile for Remote cloud with Vesta control panel:


$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = "public_ip_of_the_server_with_SQL_Windows_Server_2008_R2";
$db['default']['port'] = 1433;
$db['default']['username'] = 'my_username';
$db['default']['password'] = 'my_password';
$db['default']['database'] = 'my_db_name';
$db['default']['dbdriver'] = 'mssql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

where is the problem ?



Messages In This Thread
SQL Windows Server 2008 R2 and DB connection - by El Forum - 04-03-2014, 02:38 AM
SQL Windows Server 2008 R2 and DB connection - by El Forum - 05-07-2014, 09:13 AM
SQL Windows Server 2008 R2 and DB connection - by El Forum - 09-07-2014, 05:50 PM



Theme © iAndrew 2016 - Forum software by © MyBB