Windows, Apache and MSSQL Authentication

Posted by user1114330 on Server Fault See other posts from Server Fault or by user1114330
Published on 2012-07-02T04:56:14Z Indexed on 2012/07/02 9:17 UTC
Read the original article Hit count: 188

I have a create database script written in perl. I remember it working just fine another machine. A couple years later using a Vista machine I am trying to use it again and it keeps failing.

The main difference is that now I am using Apache instead of IIS. In the script the IUSR account is granted permissions as it needs to write to the database as a part of another program. IIS has been uninstalled on this machine but the IUSR account still exists.

The NT AUTHORITY\IUSR is also seen in the logins drop down in MSSQL(2012). The machine is running Vista Home Edition. However when running the script I get errors that say that NT AUTHORITY\IUSR cannot be found.

I tried also with COMPUTERNAME\IUSR just for the heck of it and of course it was not found. I also tried with IUSR alone and for some reason the user isn't being "found"?

Any ideas?

© Server Fault or respective owner

Related posts about apache2

Related posts about Windows