When selecting Microsoft SQL Server Express as the location for users and roles in the ArcGIS Server Manager Security-Settings configuration wizard, an error message similar to one of the following error messages may occur in the Users or Roles panels after configuring security:
"An error has occurred on the server. For details please check the Event (Application) log on the web server. Login failed for user \'\'. The user is not associated with a trusted SQL Server connection."
"Cannot open database '<database name>' requested by the login. The login failed. Login failed for user '<domain>\<username>'."
One of the above errors only occurs when all of the following conditions are true:
(a) Manager is running on Windows XP or Windows Server 2000.
(b) Microsoft SQL Server Express is selected as the user or role location.
(c) The Microsoft SQL Server Express instance is running on a separate computer under Windows Vista, Windows Server 2003 or Windows Server 2008.
(d) The 'Use trusted connection' option is selected in the security wizard.
The 'Use trusted connection' option for SQL Server requires Windows accounts for connecting to the database. The Manager Web application makes connections using the local ASPNET account with a locally-generated password. This locally-generated password is not likely to be the same as that on the machine running the Microsoft SQL Server instance. Since connections to SQL Server Express use Windows authentication, and since the ASPNET account does not exist on the database computer with the same username and password, SQL Server Express will not allow access to the remote Manager application.
Microsoft recommends using Windows authentication rather than SQL logins where possible.