Connect SQL server with PHP

Question

Connect SQL server with PHP

Navigation

#1 by (0 votes)

-1

I am trying to connect a SQLServer 2012 using php 5.3 with the driver sqlsrv , however even getting connected to SQL management studio by php always return me the error

[Microsoft] [SQL Server Native Client 11.0] [SQL Server] Failed to log in to user 'sa'.

Code:

sqlsrv_connect('DANIEL-PC\SQLEXPRESS', array(
    'UID' => 'sa',
    'PWD' => '123456',
    'Database' => 'CTe'
));
var_dump(sqlsrv_errors());

And the output is always this

array
  0 => 
    array
      0 => string '28000' (length=5)
      'SQLSTATE' => string '28000' (length=5)
      1 => int 18456
      'code' => int 18456
      2 => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuário 'sa'.' (length=85)
      'message' => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuário 'sa'.' (length=85)
  1 => 
    array
      0 => string '42000' (length=5)
      'SQLSTATE' => string '42000' (length=5)
      1 => int 4060
      'code' => int 4060
      2 => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Não é possível abrir o banco de dados "Phoros_CTe" solicitado pelo logon. Falha de logon.' (length=143)
      'message' => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Não é possível abrir o banco de dados "Phoros_CTe" solicitado pelo logon. Falha de logon.' (length=143)
  2 => 
    array
      0 => string '28000' (length=5)
      'SQLSTATE' => string '28000' (length=5)
      1 => int 18456
      'code' => int 18456
      2 => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuário 'sa'.' (length=85)
      'message' => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuário 'sa'.' (length=85)
  3 => 
    array
      0 => string '42000' (length=5)
      'SQLSTATE' => string '42000' (length=5)
      1 => int 4060
      'code' => int 4060
      2 => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Não é possível abrir o banco de dados "CTe" solicitado pelo logon. Falha de logon.' (length=143)
      'message' => string '[Microsoft][SQL Server Native Client 11.0][SQL Server]Não é possível abrir o banco de dados "CTe" solicitado pelo logon. Falha de logon.' (length=143)

php sql-server-2012

asked by anonymous 24.07.2014 / 01:42

1 answer

How to customize the Doctrine library to work with type Timestamp How to store GPS coordinates in a PHP web application?

score 0 · Accepted Answer

<?php

$server = 'DANIEL-PC\SQLEXPRESS';
$port = '1443'; // porta padrão
$server = $port !== '1443' && is_string($port) ? $server .= ", $port": $server;
$database = 'CTe';
$user = 'sa';
$pass = '123456';

$conn = sqlsrv_connect($server, array('Database' => $database, 'UID' => $user, 'PWD' => $pass));

if($conn)
{
  // Sucesso ao se conectar
}
else
{
  // Falha ao se conectar
  echo "A conexão foi estabelecida.<br/>";
  die(print_r(sqlsrv_errors(), true));
}

// If you do not connect, make sure the information: server name, user name, password, and