WampServer
Apache, PHP, MySQL
on Windows
PHP / Apache connection to SQL Server with windows authentication under different workgroup/domain
Posted by:
banank1989
(185.66.18.---)
Date: September 09, 2018 09:42AM
Hi,
I am using WAMP Server 3 with SQL Server 2016.
My App Severs are trying to connect to SQL Server and they are working fine with SQL Server Local Authentication.
But the issue is when I am trying to connect to SQL Server via Windows Authentication, I am unable to connect.
What I am doing is I am nit giving any UID / PWD for windows authentication. Now my machines are under different workgroup / different domain.
Is it possible to achieve windows autthetication with this Infra or should I move to local authetication.
I am using WAMP Server 3 with SQL Server 2016.
My App Severs are trying to connect to SQL Server and they are working fine with SQL Server Local Authentication.
But the issue is when I am trying to connect to SQL Server via Windows Authentication, I am unable to connect.
What I am doing is I am nit giving any UID / PWD for windows authentication. Now my machines are under different workgroup / different domain.
Is it possible to achieve windows autthetication with this Infra or should I move to local authetication.
Re: PHP / Apache connection to SQL Server with windows authentication under different workgroup/domain
Posted by:
banank1989
(185.66.18.---)
Date: September 09, 2018 12:04PM
The only solution is to move the DB Servers and App Servers to same domain / workgroup or use the local SQL Server user
Sorry, only registered users may post in this forum.
