• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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 ?


#2
[eluser]EyeAmN8[/eluser]
Try using 'sqlsvr' as the db driver. You may need to install some other stuff, but it works well. I had the same issue a few months ago

#3
[eluser]Unknown[/eluser]
Most of the guide online are geared for the Mac OS users. I believe if a very detailed on comes out for windows users (Vista all the way to Windows 8.1) it will gain a 20% of CMS installs but unfortunately nothing is out there.
This is my best Activation windows 8.1: <a href='https://www.youtube.com/watch?v=_s3mjcA-8eE'> تفعيل Windows 8.1</a>


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2017 MyBB Group.