I installed apache2.2 and php5 on a windows 2008 server (R2, standart edition). The php files are reading data from MS SQL. MSSQL connection is with ODBC, and everything works fine at the server.
[login to view URL]
page is working on the browser, but other clients can not open this page, getting an error like "page can not be loaded, server error".
Clients can ping the server, and even make remote connection to the server without problem, which means that network is working. But somehow the server seems to be blocking the requests...
Our second problem, is we have to create ODBC DSN connections from clients and see the SQL server. When we try to add ODBC, the system see the name of SQL server in the list, but cant login it with the user sa.
I dont have any idea why this problem occurs also.
So, i will give you the remote connection of a server, you can make remote connection to our server, then test and solve these 2 issues.
Im not sure what the problem is related with. Is it windows setup? Is it apache / PHP setup? or is it SQL server setup?
All i want is to see the ODBC connection working on the 1st computer, and see [login to view URL] working on the browser.
Thanks.
Freelance professional. I can already visualise the most common scenarios for the misconfiguration. Happy to assist once we have an accepted bid and milestones in place.
The first issue sounds like it's a simple Apache configuration problem. The second one sounds like the root cause may be similar, but I'll need to see the error messages. I can set up a conference call so we can talk, but once remoted in, this shouldn't take more than an hour to fix.
MasterAdmins is a group of experienced and certified system and network administrators. You will get service of a company for the price of a single admin.
For the frist one It is the permission problem on apache2.2 and mysql database permission. I think use of MSW4 can easily solve the problem.
For the second one the problem is due to Installation. Need to activate the sa user and need activate mixed mode auth rather than windows Auth.