troubleshooting Question
PHP MSSQL Connection issues
Hello I am trying to learn how to connect PHP with MSSQL,
However I receive the following error from my script
https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
1. SQL Server should be up and running. – is running
2. Enable TCP/IP in SQL Server Configuration – already enabled so I disabled re-enabled and rebooted
3. Open Port in Windows Firewall – already have a TCP exception for the 1 port 1433
4. Enable Remote Connection – enabled
5. Enable SQL Server Browser Service – was stopped, I restarted machine and made sure service was running (no change)
6. Create exception of sqlbrowser.exe in Firewall – I wasn’t sure to what end this was required, is there another way to do this without just letting anything connect to it.
7. Recreate Alias- there is no current alias In the machine.
1. I have also tried specifying the naming instance in the script. And get the following error: could not connect.
3. Please note that this is all for learning purposes this iis not a production server/script.
Here is my script so far:
sorry about all the white space. I made minor edits to the script to protect the integrity of the network/machines in question.
I'm going to suggest it could be something todo with the DLL files on the server, but how do I go about checking what I do and do not need.
I am using server 2012 R2,
SQL server 2008 ( I believe)
PHP 5.6 on IIS
Thank you in advance let me know if you need more info.
However I receive the following error from my script
Could not connect. Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 53 [code] => 53 [2] => [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. [message] => [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired [message] => [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 53 [code] => 53 [2] => [Microsoft][ODBC Driver 11 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. [message] => [Microsoft][ODBC Driver 11 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. ) )
https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
1. SQL Server should be up and running. – is running
2. Enable TCP/IP in SQL Server Configuration – already enabled so I disabled re-enabled and rebooted
3. Open Port in Windows Firewall – already have a TCP exception for the 1 port 1433
4. Enable Remote Connection – enabled
5. Enable SQL Server Browser Service – was stopped, I restarted machine and made sure service was running (no change)
6. Create exception of sqlbrowser.exe in Firewall – I wasn’t sure to what end this was required, is there another way to do this without just letting anything connect to it.
7. Recreate Alias- there is no current alias In the machine.
1. I have also tried specifying the naming instance in the script. And get the following error: could not connect.
Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => -1 [code] => -1 [2] => [Microsoft][ODBC Driver 11 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. [message] => [Microsoft][ODBC Driver 11 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ) [1] => Array ( [0] => HYT00 [SQLSTATE]
3. Please note that this is all for learning purposes this iis not a production server/script.
Here is my script so far:
<html>
<head>
<title>MSSQL STUFF</title>
</head>
<body>
<?php
$serverName = "(servername)";
/* Get UID and PWD from application-specific files. */
$uid = file_get_contents("X:\s\s\uid.txt");
$pwd = file_get_contents("X:\s\s\pwd.txt");
$connectionInfo = array( "UID"=>$uid,
"PWD"=>$pwd,
"Database"=>"423");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
echo "Could not connect.\n";
die( print_r( sqlsrv_errors(), true));
}
/* Set up the parameterized query. */
$tsql = "INSERT INTO 423.tss
(bur,
gur,
un,
)
VALUES
(?,?,?,)";
/* Set parameter values. */
$params = array(array1,arrt2, $today);
print "connectionInfo is $connectionInfo";
print "conn is $conn";
print "params is $params";
print "today is $today";
print "stmt is $stmt";
print "tsql is $tsql";
echo "<div id='connectionInfo'>$connectionInfo</div>";
echo "<div id='conn'>$conn</div>";
echo "<div id='params'>$params</div>";
echo "<div id='today'>$today</div>";
echo "<div id='stmt'>$stmt</div>";
echo "<div id='tsql'>$tsql</div>";
/* Prepare and execute the query. */
$stmt = sqlsrv_query( $conn, $tsql, $params);
if( $stmt )
{
echo "Row successfully inserted.\n";
}
else
{
echo "Row insertion failed.\n";
die( print_r( sqlsrv_errors(), true));
}
/* Free statement and connection resources. */
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>
</body>
</html>
sorry about all the white space. I made minor edits to the script to protect the integrity of the network/machines in question.
I'm going to suggest it could be something todo with the DLL files on the server, but how do I go about checking what I do and do not need.
I am using server 2012 R2,
SQL server 2008 ( I believe)
PHP 5.6 on IIS
Thank you in advance let me know if you need more info.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 10 Answers and 26 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
This award recognizes an author who contributes the highest volume of original works or content. Recipients of this award produce extremely valuable content that prioritizes accuracy, relevancy, and professionalism.