IWAM Login Failed When Connecting To SQL Server

I just loaded the .NET framework on one of my servers. The server is a Windows 2000 domain controller running SQL Server 7. I created an aspx file that runs fine on my Windows XP Pro machine. I copied the file to the Windows 2000 Server. When I attempt to run the file the following error message is returned:





Login failed for user 'PDMFN1IWAM_PDMFN'.


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: Login failed for user 'PDMFN1IWAM_PDMFN'.





The IWAM_PDMFN account does exist. I've never had to add the IWAM user to SQL Server users in the past.





Does anyone have any information about this error?





Here's part of the code. It fails at myConn.Open()








dim msg as new MailMessage()


dim myConn As SqlConnection


dim myCmd As SqlCommand


dim myReader As SqlDataReader


dim to_address As String





'Create the Connection object.


myConn = New SqlConnection("Initial Catalog=fnnet; Data Source=localhost;Integrated Security=SSPI;")





'Create the Command object.


myCmd = myConn.CreateCommand


myCmd.CommandText = "SELECT EMAIL FROM USERS WHERE user_id IN (SELECT user_id FROM inbox_access WHERE inbox_code = '" &


request.querystring("country") & "' and auto_notification = 1)"





'Open the connection.


myConn.Open()