Posted on by
Connect MS-SQL Server with PHP
Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect() in G:\APPLIVE\bharatskills\__config.php:9 Stack trace: #0 G:\APPLIVE\bharatskills\__header.php(1): include() #1 G:\APPLIVE\bharatskills\index.php(1): include('G:\\APPLIVE\\bhar...') #2 {main} thrown in G:\APPLIVE\bharatskills\__config.php on line 9
Download the Microsoft Drivers for PHP for SQL Server
https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server
; Directory in which the loadable extensions (modules) reside.
; https://php.net/extension-dir
;extension_dir = "./"
; On windows:
extension_dir = "ext"
Array
(
[0] => Array
(
[0] => 28000
[SQLSTATE] => 28000
[1] => 18456
[code] => 18456
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'IIS APPPOOL\DefaultAppPool'.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'IIS APPPOOL\DefaultAppPool'.
)
[1] => Array
(
[0] => 42000
[SQLSTATE] => 42000
[1] => 4060
[code] => 4060
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "BHARAT_SKILLS" requested by the login. The login failed.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "BHARAT_SKILLS" requested by the login. The login failed.
)
[2] => Array
(
[0] => 28000
[SQLSTATE] => 28000
[1] => 18456
[code] => 18456
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'IIS APPPOOL\DefaultAppPool'.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'IIS APPPOOL\DefaultAppPool'.
)
[3] => Array
(
[0] => 42000
[SQLSTATE] => 42000
[1] => 4060
[code] => 4060
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "BHARAT_SKILLS" requested by the login. The login failed.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "BHARAT_SKILLS" requested by the login. The login failed.
)
)
-- I HAVE ADDED A USER `IIS APPPOOL\DefaultAppPool` IN MSSQL
