How to connect php with sql server a comprehensive guide: PHP 8+, sqlsrv, PDO_SQLSRV, Windows, Linux

Yes, you can connect PHP with SQL Server using the SQLSRV driver and PDO_SQLSRV extensions. In this guide, you’ll get a practical, step-by-step approach to setting up the drivers on Windows and Linux, writing robust PHP code to query SQL Server, handling errors gracefully, and keeping things secure and fast. Whether you’re migrating an existing app or starting fresh, this post covers installation, configuration, code samples, troubleshooting, and best practices so you can get a reliable connection quickly.

Useful URLs and Resources

Microsoft SQL Server Documentation – docs.microsoft.com/en-us/sql/sql-server
PHP Documentation – php.net
Microsoft PHP Drivers official – github.com/Microsoft/msphpsql
PDO_SQLSRV Documentation – aka.ms/php-pdo-sqlsrv
Stack Overflow – stackoverflow.com

Introduction overview

What you’ll learn: the two main PHP drivers for SQL Server, how to install them on Windows and Linux, how to connect with both sqlsrv and PDO, how to handle errors, and how to secure credentials.
Quick-start snapshot: install drivers, enable extensions, pick a connection method, run a simple query, and move on to production-ready patterns.

Body

Table of Contents

Why connect PHP to SQL Server in 2026

SQL Server remains a popular choice for enterprise apps on Windows and increasingly on Linux, especially when you need strong OLTP features, advanced analytics, and tight integration with .NET ecosystems.
PHP is still one of the most widely used server-side languages, powering a large share of dynamic websites and apps. The two official PHP drivers from Microsoft—sqlsrv and PDO_SQLSRV—make it practical to work with SQL Server directly from PHP.
Using the right driver and proper connection handling gives you reliable performance, good error visibility, and strong security when building data-driven PHP apps.

Prerequisites

PHP 8.0 or newer is strongly recommended for security and performance improvements.
A supported SQL Server instance SQL Server 2012+ is compatible with current drivers. SQL Server 2019/2022 is common in production.
For Windows: a PHP build that matches the driver binaries thread-safe or non-thread-safe as required and the correct architecture x64.
For Linux: a recent Linux distribution with PHP 7.4/8.x and the ability to install PECL packages or compile extensions.
Basic knowledge of environment management and security best practices env vars, not hard-coding credentials.

Choose your driver: sqlsrv vs PDO_SQLSRV

Driver	API style	Best for	Key considerations
sqlsrv	Procedural and object-oriented in PHP, native extension	Simple scripts, quick queries, smaller footprint	Great for straightforward tasks. some complex SQL might be easier with PDO
PDO_SQLSRV	PDO interface	Projects already using PDO, portable code, prepared statements across databases	Use if you want a consistent PDO-based data layer across databases

Both drivers are actively maintained by Microsoft and PHP core contributors.
PDO_SQLSRV provides a unified approach if you’re working with multiple databases. sqlsrv can be a bit leaner for pure SQL Server usage.

Installation overview

Windows: download the appropriate driver binaries from Microsoft, copy to PHP ext/ folder, enable in php.ini, restart the web server.
Linux: typically install via PECL pecl install sqlsrv and pecl install pdo_sqlsrv after installing dependencies like unixODBC and devel headers. then enable extensions in php.ini or conf.d.
After installation, verify with php -m to ensure sqlsrv and/or pdo_sqlsrv appear in the loaded modules.

Linux installation steps Ubuntu/Debian

Install prerequisites

sudo apt-get update
sudo apt-get install -y build-essential gcc g++ make autoconf pkg-config
sudo apt-get install -y unixodbc-dev
sudo apt-get install -y curl

Install PHP development headers matching your PHP version

sudo apt-get install -y php8.1-dev adjust to your PHP version

Install the drivers via PECL

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv

Enable extensions

echo “extension=sqlsrv.so” | sudo tee /etc/php/8.1/cli/conf.d/20-sqlsrv.ini
echo “extension=pdo_sqlsrv.so” | sudo tee /etc/php/8.1/cli/conf.d/20-pdo_sqlsrv.ini
Replace 8.1 with your PHP version, and apply to Apache/Nginx if needed:
- sudo systemctl restart apache2
- sudo systemctl restart php8.1-fpm

Verify

php -m | grep -E ‘sqlsrv|pdo_sqlsrv’
You should see both sqlsrv and pdo_sqlsrv listed.

Notes:

If you’re on a different PHP version, adjust the package names accordingly.
On some distros, you may need to install prerequisite libintl or libicu packages depending on your PHP build.

Windows installation steps

Determine your PHP build

Check PHP version, architecture x64, and whether it’s thread-safe ts or non-thread-safe nts.

Download drivers

Go to the Microsoft PHP drivers repository and grab the appropriate sqlsrv and pdo_sqlsrv binaries for your PHP version and architecture.

Install extensions

Copy the downloaded .dll files into your PHP ext/ directory.
Edit php.ini to enable:
- extension=php_sqlsrv.dll
- extension=php_pdo_sqlsrv.dll
Restart your web server IIS, Apache, or others.

Verify

Create a small phpinfo page or run:
php -m | findstr /R “sqlsrv|pdo_sqlsrv”

Optional tuning

If you’re using Windows authentication Trusted_Connection, note you may need additional configurations and permission alignment on SQL Server.

Code samples: connecting with sqlsrv and PDO_SQLSRV

Using sqlsrv procedural style

<?php
$serverName = "tcp:your_server.database.windows.net,1433". // or your on-prem server
$connectionInfo = 
    "Database" => "YourDatabase",
    "UID" => "your_user",
    "PWD" => "your_password",
    "CharacterSet" => "UTF-8"
.

$conn = sqlsrv_connect$serverName, $connectionInfo.

if $conn === false {
    echo "Connection failed: " . print_rsqlsrv_errors, true.
    exit.
}

$sql = "SELECT TOP 10 id, name FROM Employees".
$stmt = sqlsrv_query$conn, $sql.
if $stmt === false {
    dieprint_rsqlsrv_errors, true.

while $row = sqlsrv_fetch_array$stmt, SQLSRV_FETCH_ASSOC {
    echo $row . " - " . $row . PHP_EOL.

sqlsrv_free_stmt$stmt.
sqlsrv_close$conn.
?>

Using PDO_SQLSRV PDO style

$serverName = “your_server.database.windows.net,1433”.
$database = “YourDatabase”.
$dsn = “sqlsrv:Server=$serverName.Database=$database”.

$user = “your_user”.
$password = “your_password”.

try {
$pdo = new PDO$dsn, $user, $password.
$pdo->setAttributePDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION.

 $stmt = $pdo->prepare"SELECT TOP 10 id, name FROM Employees".
 $stmt->execute.

 $rows = $stmt->fetchAllPDO::FETCH_ASSOC.
 foreach $rows as $row {
     echo $row . " - " . $row . PHP_EOL.
 }

} catch PDOException $e {
// Use a safer error path in production
echo “Connection failed: ” . $e->getMessage. How to Add Custom Emojis to Your Discord Server Step by Step Guide

Tips:

Always use prepared statements prepare/execute to prevent SQL injection.
For Windows authentication, you’ll typically use a SQL Server login, or explore Kerberos/AD-based auth with careful server config.
For Azure SQL Database, use the fully qualified server name and TLS/SSL guidance. the drivers support encryption by default.

Connection security and best practices

Never hard-code credentials in source files. Use environment variables or a secrets manager.
Prefer prepared statements and parameter binding to avoid SQL injection.
Use TLS/SSL for all connections to SQL Server Azure or on-prem with TLS enabled.
Limit the database user’s permissions to what the app needs principle of least privilege.
Rotate credentials regularly and monitor for unusual login activity.
If you deploy on shared hosting, ensure your credentials and error messages don’t leak sensitive data.

Performance and reliability tips

Use connection pooling where supported by the driver. PDO_SQLSRV supports some pooling features. check your environment for specifics.
Enable proper error handling and logging to quickly detect and respond to issues.
Cache frequent read queries at the PHP level when it makes sense, but ensure data freshness is managed consider cache invalidation strategies.
For large result sets, fetch in chunks instead of loading everything into memory.
Prefer server-side paging SELECT TOP n or cursor-based pagination for large datasets.
Keep your PHP and driver versions up to date with the latest security and performance fixes.

Real-world example: a small CRUD scaffold

Create: insert a new employee record via prepared statements
Read: fetch a list of employees
Update: modify an employee’s role
Delete: remove an employee

This pattern translates cleanly to both sqlsrv and PDO_SQLSRV. The key is to keep your data access layer consistent and to separate concerns data access vs. business logic.

Troubleshooting common issues

Extension not loaded: verify the correct PHP version and architecture. check php.ini and the ext/ directory.
Connection timeouts: confirm server hostname, port, and firewall rules. ensure SQL Server allows remote connections.
Authentication failures: verify user credentials, SQL Server authentication mode Windows vs SQL Server, and the login’s permissions.
TLS/SSL errors: ensure proper certificates and that the driver version supports the required TLS version.
Data type mismatches: map PHP types to SQL Server types correctly and use bound parameters.

Best practice quick checklist

Use PDO when you need cross-database compatibility. otherwise sqlsrv is fine for SQL Server-specific apps.
Store credentials securely env vars or a secrets manager.
Use prepared statements for all user-supplied data.
Validate and sanitize all inputs at the PHP layer.
Enable meaningful error reporting in development. tighten in production.
Keep PHP, the web server, and drivers up to date.
Test connections across environments Windows, Linux, Azure to catch environment-specific quirks early.

Data and trends you should know

PHP remains one of the most widely used server-side languages on the web, powering a substantial share of dynamic sites worldwide. This means a lot of developers still rely on PHP-first stacks with SQL Server in enterprise contexts.
SQL Server’s cross-platform availability on Linux has grown adoption for mixed stacks, which is why these PHP drivers are crucial for developers working outside Windows-only environments.
Using Microsoft’s official drivers reduces compatibility headaches and ensures better long-term support compared to relying on third-party legacy connectors.

Quick reference: driver choice in common scenarios

If you already have a PDO-based data access layer across databases: choose PDO_SQLSRV for consistency.
If you’re starting with SQL Server and want a simpler API surface: sqlsrv is often quicker to adopt.
For Azure SQL Database: both drivers work well. ensure you use the correct server name and TLS settings.

Frequently Asked Questions

What is the difference between sqlsrv and PDO_SQLSRV?

sqlsrv is a native PHP extension with a straightforward API for direct SQL Server interaction, while PDO_SQLSRV is a PDO driver that lets you use the PDO interface and patterns you already use with other databases. If you need cross-database portability, go with PDO_SQLSRV. otherwise sqlsrv can be simpler for pure SQL Server usage.

How do I enable the extensions in PHP?

After installing the drivers, add the following lines to your php.ini adjust paths if needed:

extension=sqlsrv.so or php_sqlsrv.dll on Windows
extension=pdo_sqlsrv.so or php_pdo_sqlsrv.dll on Windows
Then restart your web server.

Can I connect to SQL Server from Linux?

Yes. The Linux drivers sqlsrv and PDO_SQLSRV are supported on modern PHP versions. You’ll typically install via PECL and ensure the unixODBC libraries are present. How to mark a discord server as nsfw: Channel NSFW, Age-Restricted, and Server Settings for Safe, Compliant Communities

How do I connect to SQL Server from Windows?

Use the Windows driver binaries, place them in your PHP ext/ folder, and enable them in php.ini as shown above. Connection strings and authentication behave the same once the extensions are loaded.

How should I store credentials securely?

Use environment variables or a secrets management tool. Avoid hard-coding credentials in source code. Consider rotating credentials and auditing access regularly.

Can I use Windows authentication Integrated Security from PHP?

Windows authentication is possible but requires the server to be configured appropriately and may require Kerberos or other AD-based setup. In many deployments, SQL Server authentication UID and PWD is simpler and widely supported.

Are there any licensing considerations?

The PHP drivers themselves are open-source, and SQL Server may have licensing requirements depending on your deployment. Check Microsoft’s licensing terms for SQL Server in your environment.

How do I prevent SQL injection when using PHP with SQL Server?

Always use prepared statements with bound parameters, and avoid interpolating user input directly into SQL strings. Both sqlsrv and PDO_SQLSRV support parameterized queries. How to Install Certificate in Windows Server 2008 R2 Step by Step Guide: SSL, CSR, IIS

How do I troubleshoot a connection error?

Start by checking:

The exact error message via sqlsrv_errors or PDOException.
Network connectivity ping, telnet to port 1433 or the SQL Server port you use.
Server configuration remote connections enabled, correct IP allowlists.
Driver version compatibility with your PHP version.
TLS/SSL requirements for your server.

Can I use these drivers with PHP 7.x?

Yes, but you should upgrade to PHP 8.x if possible for security and performance benefits. Drivers generally support newer PHP versions, but you’ll want to verify compatibility with your exact PHP and OS versions.

Is macOS supported for development with these drivers?

Officially, Linux and Windows are the primary development targets for these drivers. macOS support is not always consistent across PHP versions, so use Linux or Windows for production-grade development if possible, or test carefully on macOS.

How do I test performance of SQL Server queries from PHP?

Create a small benchmarking script that runs a representative set of queries with and without prepared statements, measure execution times and memory usage, and compare results across driver choices. Use real-world data sizes and caching patterns.

What are common pitfalls when migrating from MySQL to SQL Server with PHP?

Differences in data types and default behaviors e.g., string quoting, boolean handling.
SQL dialect differences requiring query rewrites.
Connection string variations and authentication mode differences.
Ensuring proper indexing and query plans for SQL Server.
Adjusting transaction handling and error codes to align with SQL Server.

Can I reuse existing PHP data access layers with SQL Server?

Yes, especially if you choose PDO_SQLSRV. You can abstract your data access behind a repository layer and switch the underlying driver with minimal code changes. The Ultimate Guide How To Set Up A Discord Server From Scratch: A Complete, SEO‑Optimized Playbook For General

What about error handling best practices in production?

Log errors with stack traces to a secure log avoid exposing details to end users, implement retry logic for transient errors if appropriate, and monitor SQL Server health deadlocks, blocking, long-running queries to prevent cascading failures in your PHP app.

Final quick-start recap

Decide between sqlsrv and PDO_SQLSRV based on your project needs.
Install the driver on Windows or Linux, then enable the extension in PHP.
Use prepared statements and parameter binding for all user inputs.
Secure credentials and configure TLS for connections.
Validate performance and monitor for errors in production.

If you’re starting today, grab the latest PHP 8.x stack, pick your driver PDO_SQLSRV for cross-database portability or sqlsrv for a lean SQL Server interface, set up on a local dev machine, and practice with small read/write operations. You’ll have a robust, secure PHP-to-SQL-Server connection in no time, and you’ll be ready to scale as your app grows.

Sources:

一键部署VPN：全面指南与实用技巧，让你轻松拥有自己的专属网络

免费的梯子推荐：全面指南、免费VPN对比、折扣策略与实操教程

What is vpn surfshark Download Files on Ubuntu Server Step by Step Guide: Wget, SCP, SFTP, Rsync

Clash全部节点超时怎么办？一文搞懂原因与快速解决方法，包含节点诊断、DNS 调整、配置优化、代理规则与 VPN 辅助等实用指南

一只猫 vpn 深度评测：如何在全球互联网自由上网、保护隐私、选择最佳 VPN、以及在中国使用的实测策略