Control Web Panel

Other => Other => Topic started by: KatiaSisHost on August 08, 2022, 12:34:42 AM

Title: MSSQL Server Problem
Post by: KatiaSisHost 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"
);

Title: Re: MSSQL Server Problem
Post by: martinturner1990 on August 23, 2022, 03:45:06 AM

I encountered something similar, and looking for an solution as well.

Title: Re: MSSQL Server Problem
Post by: rcschaff on August 23, 2022, 05:12:54 AM

$serverName = "192.168.1.202, 1433";

or

$serverName = "MSSQLSERVER, 1433";

Not Both

Title: Re: MSSQL Server Problem
Post by: KatiaSisHost 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