Vahn Marty Cagalawan Vahn Marty Cagalawan - 28 days ago 15
PHP Question

Laravel to MS SQL Server on Ubuntu : Error 262, Severity 14

After i run

php artisan migrate
, this is the error I got.

[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 262 General SQL Server error: Check message
s from the SQL Server [262] (severity 14) [(null)] (SQL: create table "migr
ations" ("migration" nvarchar(255) not null, "batch" int not null))



[PDOException]
SQLSTATE[HY000]: General error: 262 General SQL Server error: Check message
s from the SQL Server [262] (severity 14) [(null)]


This has been my long road to connect my Laravel to MS SQL Server using Ubuntu.

Answer

I have solved it. The problem was not the connectivity. The DB Administrator just provided me a limited user in Database. I just found out that MS SQL Server has different users with different accessibility. I requested the DBA to give me full access, then it's all good.

Comments