Connecting to the Server
The topics in this section describe the options and procedures for connecting to SQL Server with the Microsoft Drivers for PHP for SQL Server.
The Microsoft Drivers for PHP for SQL Server can connect to SQL Server by using Windows Authentication or by using SQL Server Authentication. By default, the Microsoft Drivers for PHP for SQL Server try to connect to the server by using Windows Authentication.
In This Section
| Topic | Description |
|---|---|
| How to: Connect Using Windows Authentication | Describes how to establish a connection by using Windows Authentication. |
| How to: Connect Using SQL Server Authentication | Describes how to establish a connection by using SQL Server Authentication. |
| How to: Connect Using Microsoft Entra authentication | Describes how to set the authentication mode and connect using identities in Microsoft Entra ID (formerly Azure Active Directory). |
| How to: Connect on a Specified Port | Describes how to connect to the server on a specific port. |
| Connection Pooling | Provides information about connection pooling in the driver. |
| How to: Disable Multiple Active Resultsets (MARS) | Describes how to disable the MARS feature when making a connection. |
| Connection Options | Lists the options that are permitted in the associative array that contains connection attributes. |
| Support for LocalDB | Describes Microsoft Drivers for PHP for SQL Server support for the LocalDB feature, which was added in SQL Server 2012 (11.x). |
| Support for High Availability, Disaster Recovery | Discusses how your application can be configured to take advantage of the high-availability, disaster recovery features added in SQL Server 2012 (11.x). |
| Connecting to Microsoft Azure SQL Database | Discusses how to connect to an Azure SQL Database. |
| Connection Resiliency | Discusses the connection resiliency feature that reestablishes broken connections. |
See Also
Programming Guide for the Microsoft Drivers for PHP for SQL Server
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for