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.
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"?