SQL Windows Server 2008 R2 and DB connection |
[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 ?
[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
[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> |
Welcome Guest, Not a member yet? Register Sign In |