If your Microsoft SQL Server is running on a different machine than your Microsoft IIS web server and you have not changed the default ASP.NET user, you will need to perform additional configuration steps. If you do not, you will get a “user not found” error when you try to add a Microsoft SQL Server login for the “ASPNET” user. In particular, you must change the ASP.NET user to a valid domain user by configuring machine.config as follows.
Step 1: Locate your machine.config file, e.g:
C:\<WINDOWS-DIRECTORY>\Microsoft.NET\Framework\v1.0.3705\CONFIG
Be sure to use the Machine.config file specific to your active .NET Framework installation.
Step 2: Change the userName and password attributes in the processModel element to a valid Windows domain user. See Using Windows Authentication for a description of the userName and password attributes.
Step 3: Reset Microsoft IIS or stop the aspnet_wp.exe process in order for your changes to take effect.
Step 4: Create an account for the configured user (now a valid domain user) in Microsoft SQL Server
Use Enterprise Manager --> Database server --> Security --> Logins
Step 5: Grant db_owner rights to this user on any databases you plan to reference. This will allow Iron Speed Designer to create stored procedures in those databases.
You should now be able to connect from Iron Speed Designer to Microsoft SQL Server using Windows Authentication.
Configuring Database Authentication for Microsoft SQL Server Applications