1. Download SQL Server PHP Drivers from below link:
https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16
Note :
Make sure you have the latest version of the ODBC driver installed to ensure optimal performance and security. For download visit the below link.
https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16
2. Extract drivers on ext directory inside your php installation directory (example : C:\xampp\php\ext)
Add the following to your php.ini file.
extension=php_sqlsrv_82_ts_x64.dll
extension=php_pdo_sqlsrv_82_ts_x64.dll
3. Update your .env file with the database connection details
DB_CONNECTION=sqlsrv
DB_HOST=CHIRAG-LAPPY\PRIMARYDB
DB_PORT=1433
DB_DATABASE=webcam_app
DB_USERNAME=sa
DB_PASSWORD=admin@123
4. Go to
Sql Server Configuration Manager -> Sql Server Network Configuration -> Protocols For <InstanceName> -> TCP/IP -> IPAddresses
Change the following
IpAll
TCP Dynamic Ports xxxxx
TCP Port
To:
IpAll
TCP Dynamic Ports xxxxx
TCP Port 1433
5. Now open the sql server management studio and connect the instance. Next create the database "webcam_app" (Create your own databse here we are creating webcam_app database for testing purpose.).
6. run the below command in the project.
php artisan migrate
