dcsimg

Attempt to perform Data Extract returns error “Login failed for user ‘MACHINENAME\ASPNET’.”

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.x

Issue

When attempting to make create a Data Extract under “Connect” > “Data Scheduler” > “Upcoming” > “New” the following error displays:

Cannot open database “wtMaster” requested by the login. The login failed.
Login failed for user ‘MACHINENAME\ASPNET’.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database “wtMaster” requested by the login. The login failed.
Login failed for user ‘CLIENTMACHINENAME\ASPNET’.

Resolution

The ASPNET user account is created automatically on the machine with the installation of ASP.Net. This user does not have access to the databases in this situation. To remedy this:
1. Log in to the database using SQL Server Management Studio or Management Studio Express.

2. Expand the Security folder, right-click on Logins and select “New Login.”

3. In the “Login name:” field, select the Search button.

4. To change the “From this location:” value, select the “Locations…” button, select the local computer, then select OK.

5. Enter “ASPNET” in the “Enter the object name to select” field, click Check Names, then select OK.

6. Select User Mapping, then select wt_sched.

7. Check db_owner under “Database role membership for:”

8. Repeat the above step for wtMaster, then click OK.

9. Attempt to export again.