Webbstackar

Webbstackar

PHP to MSSQL (Windows 7, PHP 5.4.22 nts, SQL SERVER 2008 R2 SP 2)

Install this:

The problem:

[SQL Server]Login failed for user 'NT instans\IUSR'.

The solution:

(SQL Server 2008 R2 SP2 NT instance\IUSR login howto)

SQLSRV 3.0 / IIS 7 uses the NT instance\IUSR login as default login

In Object Explorer in SQL Server Management Studio:

The login/user is displayed as PCNAME/IUSR in the Login name field

Create a MSSQL user that uses the NT instance\IUSR login:

In Object Explorer in SQL Server Management Studio: