Installation
- SQL Server Express : https://www.microsoft.com/en-us/sql-server/sql-server-downloads
- SQL Server Management Studio (SSMS): https://learn.microsoft.com/en-us/ssms/install/install
- ODBC Driver for SQL Server : https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver17
- PHP SQL Server Extensions : https://github.com/microsoft/msphpsql/releases. Extract the files into your PHP ext directory (rename it as your php folder name). Edit php.ini and enable the extensions:
extension=php_sqlsrv_82_ts_x64.dll
extension=php_pdo_sqlsrv_82_ts_x64.dll
- Create Database :
# Open SSMS
# Server name: localhost\SQLEXPRESS
# Set Encrypt to Optional.
# Right-click Databases → New Database
Laravel
- .env
DB_CONNECTION=sqlsrv
DB_HOST=127.0.0.1
DB_PORT=your_port
DB_DATABASE=your_db
DB_USERNAME=your_user
DB_PASSWORD=your_password
- php artisan migrate
FAQ
- Command to restart:
# open cmd as administrator
net stop MSSQL$SQLEXPRESS
net start MSSQL$SQLEXPRESS
# confirm run
sc query MSSQL$SQLEXPRESS
# confirm port
netstat -ano | findstr 1433
- How to set the port we want to use:
# open sql server configuration manager
# sql server network configuration -> protocols for sqlexpress
# double click tcp/ip -> tcp/ip tab
# scroll down until IPAII -> empty the dynamic and set the port
# restart services
- Create user in SSMS:
# new query in SSMS
USE master;
GO
ALTER AUTHORIZATION ON DATABASE::your_db TO your_user;
GO
- Errors:
SQLSTATE[IMSSP]: An invalid attribute was designated on the PDO object.
Need help building your app? I’m available for freelance web & Android development — raflizocky.netlify.app
☕ Support my writing: paypal.me/raflizocky · saweria.co/raflizocky
Top comments (0)