0

Good day, I have a project developed in the Codeigniter framework (PHP) which has a connection to SQLSERVER. The project locally is working fine, but when I uploaded it to a Windows server it shows me an error, the steps you took on the server were the same as you did on the server (put the .dlls in the php ext directory and call them in the php.ini file). I attach the error that you are sending me in the connection and I also attach my connection.

SQLSERVER connection

$db['sqlserver'] = array(
    'dsn'   => '',
    'hostname' => '192.2.2.2',
    'username' => 'sa',
    'password' => 'password',
    'database' => 'name_database',
    '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' => TRUE
);

Error

enter image description here

I hope you can support me.

Thank you very much.

10
  • Not without the true error. Also, your web application should not be using the sa account. It should have it's own LOGIN and USERs with the minimal amount of permissions needed to fulfil its role. Commented Aug 26, 2020 at 14:59
  • Does this answer your question? CodeIgniter: Unable to connect to your database server using the provided settings Error Message Commented Aug 26, 2020 at 15:03
  • The SQLSERVER is on a different server where I am mounting the project. Locally it is working fine. How can I give you these permissions that you tell me? Commented Aug 26, 2020 at 15:07
  • I am making the connection to SQL SERVER. Commented Aug 26, 2020 at 15:09
  • Make a simple connection and it sends me the following error Commented Aug 26, 2020 at 15:26

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.