• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Unable to connect to your database server using the provided settings

#3
(10-05-2018, 04:39 AM)qury Wrote: Hi,
This is the section from config/database.php of a project that is using sqlsrv driver.

PHP Code:
$db['mssql'] = array(
 
   'dsn'          => '',
 
   'hostname'     => 'hostname',
 
   'username'     => 'username',
 
   'password'     => 'secretpassword',
 
   'database'     => 'DATABASENAME',
 
   'dbdriver'     => 'sqlsrv',
 
   'dbprefix'     => '',
 
   'pconnect'     => FALSE,
 
   'db_debug'     => (ENVIRONMENT !== 'production'),
 
   'cache_on'     => FALSE,
 
   'cachedir'     => '',
 
   'char_set'     => 'utf8',
 
   'dbcollat'     => 'utf8_general_ci',
 
   'swap_pre'     => '',
 
   'encrypt'      => false,
 
   'compress'     => FALSE,
 
   'stricton'     => FALSE,
 
   'failover'     => array(),
 
   'save_queries' => FALSE
); 

Thanks,

It's almost the same as mine, the only difference being save_queries, which I just set to FALSE.

Mine is Windows Authentication, so the userid and password aren't relevant.

I'll try and trace through to the point where the actual connection is made, and see how that compares to a known dsn.
Reply


Messages In This Thread
RE: Unable to connect to your database server using the provided settings - by IgniterExplorer - 10-05-2018, 06:27 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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