Author Topic: MSSQL Server Problem  (Read 3146 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
MSSQL Server Problem
« on: August 08, 2022, 12:34:42 AM »
Hi, i have a PRO Edition, and im trying to install MSSQLServer Extension.

Im select sqlsrv in panel and i follow the instruction from:
http://wiki.centos-webpanel.com/mssql-extension-for-php7

and nothing... the old instruction say errors in "make"


Error information:
SQLSTATE: HYT00
Code: 0
Message: [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
SQLSTATE: 08001
Code: 10057
Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2749
SQLSTATE: 08001
Code: 10057
Message: [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.



My PHP:

$serverName = "192.168.1.202\MSSQLSERVER, 1433";
$connectionOptions = array(
    "database" => "user2list",
    "uid" => "sa",
    "pwd" => "Password$123456"
);
« Last Edit: August 08, 2022, 12:36:42 AM by KatiaSisHost »

Offline
*
Re: MSSQL Server Problem
« Reply #1 on: August 23, 2022, 03:45:06 AM »
I encountered something similar, and looking for an solution as well.

Offline
****
Re: MSSQL Server Problem
« Reply #2 on: August 23, 2022, 05:12:54 AM »
$serverName = "192.168.1.202, 1433";

or

$serverName = "MSSQLSERVER, 1433";

Not Both
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: MSSQL Server Problem
« Reply #3 on: August 24, 2022, 11:08:05 PM »
helo rcschaff, yes my bad in post...  i try with MSSQLSERVER and with 192.168.1.202 and nothing