MSDE 2000 And Web Matrix Question

Hi guys,
I have a question regarding the use of MSDE with web matrix and wonder if any1 can help me out.

First of all, I'm using the web matrix to design ms sql databases. After that, I connect an asp.net page to it and finally run it on the web matrix server. Everything turns out the way it should be. However, when I run it on the IIS, a 'Login failed' error was thrown. Below's my code for establishing connection and retrieving data:

vbnet Code:






Original
- vbnet Code





<%@ Page Language="VB" Debug="True" %>
<%@ import Namespace="System.Data.SqlClient" %>
<%
Dim conPubs As SqlConnection
Dim cmdSelectAuthors As SqlCommand
Dim dtrAuthors As SqlDataReader

conPubs = New SqlConnection( "server='(local)'; trusted_connection=true; database='pubs'" )
conPubs.Open()
cmdSelectAuthors = New SqlCommand( "Select au_lname From Authors", conPubs )
dtrAuthors = cmdSelectAuthors.ExecuteReader()
While dtrAuthors.Read()
Response.Write( "<li>" )
Response.Write( dtrAuthors( "au_lname" ) )
End While
dtrAuthors.Close()
conPubs.Close()
%>






 <%@ Page Language="VB" Debug="True" %><%@ import Namespace="System.Data.SqlClient" %><%Dim conPubs As SqlConnectionDim cmdSelectAuthors As SqlCommandDim dtrAuthors As SqlDataReader conPubs = New SqlConnection( "server='(local)'; trusted_connection=true; database='pubs'" )conPubs.Open()cmdSelectAuthors = New SqlCommand( "Select au_lname From Authors", conPubs )dtrAuthors = cmdSelectAuthors.ExecuteReader()While dtrAuthors.Read()  Response.Write( "<li>" )  Response.Write( dtrAuthors( "au_lname" ) )End WhiledtrAuthors.Close()conPubs.Close()%>



I don't know if this is the correct place to ask this question. If it is, kindly help me out as I desperately need an answer. If not, maybe somebody can direct me to the place where this type of qns is address. Thanks in advance.