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: 183
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