We have an web application server, MS SQL Server and a data storage server(separate physical machines)
Our applications are written in PHP and classical ASP. The PHP uses the CodeIgniter framework.
The applications have always worked well.
Using the command line, at the data server, login as administrator, I can access the data, read, write etc.
But the web applications can not - neither PHP or ASP - access the data storage server.
We use Windows Server 2012. We are using MS SQL 2008.
I am sure it is a permissions problem, and after viewing the event log on the data storage server.
It appears to be so since I am receiving "Login Failure - SMB session authentication failure" messages .
I am not sure of how set up permissions on the data storage server so the web applications can use it. I mean, I don't want to enter each person etc.
I am not finding much info on this problem.
Can someone guide me in what I need to check etc. to resolve this problem.
This is really urgent, any help appreciated.