hi
i'm using SQL 2005
n Microsoft Visual Basic.NET 2003
need some help
now tryin 2 do a 3-tier project 4 de 1st time
tryin 2 get my datagrid 2 work, like when the page loads, de datagrid gets info from de database n show de info on de datagrid
tis is wat i get when i browse de page

Server Error in '/PresentationLayer' Application.

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Login failed for user 'justcaps'. The user is not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at CAPS_datalayer.Service1.getDataSet(String strCoonection) in c:\inetpub\wwwroot\WebService1\CAPS_datalayer\Service1.asmx.vb:line 70
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at BusinessLayer1.CAPS_DATA.Service1.getDataSet(String strCoonection) in c:\inetpub\wwwroot\BusinessLayer1\Web References\CAPS_DATA\Reference.vb:line 42
at BusinessLayer1.Service1.populateViewMR() in c:\inetpub\wwwroot\BusinessLayer1\Service1.asmx.vb:line 113
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.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Login failed for user 'justcaps'. The user is not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at CAPS_datalayer.Service1.getDataSet(String strCoonection) in c:\inetpub\wwwroot\WebService1\CAPS_datalayer\Service1.asmx.vb:line 70
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at BusinessLayer1.CAPS_DATA.Service1.getDataSet(String strCoonection) in c:\inetpub\wwwroot\BusinessLayer1\Web References\CAPS_DATA\Reference.vb:line 42
at BusinessLayer1.Service1.populateViewMR() in c:\inetpub\wwwroot\BusinessLayer1\Service1.asmx.vb:line 113

Source Error:

Line 112: <System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/BusinessLayer1/Service1/populateViewMR", RequestNamespace:="http://tempuri.org/BusinessLayer1/Service1", ResponseNamespace:="http://tempuri.org/BusinessLayer1/Service1", Use:=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _
Line 113: Public Function populateViewMR() As System.Data.DataSet
Line 114: Dim results() As Object = Me.Invoke("populateViewMR", New Object(-1) {})
Line 115: Return CType(results(0),System.Data.DataSet)
Line 116: End Function

Source File: c:\inetpub\wwwroot\PresentationLayer\Web References\CAPS_BIZ1\Reference.vb Line: 114

codes in form
Code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim cap As New CAPS_BIZ1.Service1
        vdg_mrl.DataSource = cap.populateViewMR
        vdg_mrl.DataBind()
codes in the Service1.asmx
Code:
<WebMethod()> _
Public Function populateViewMR() As DataSet

        Dim data As New CAPS_DATA.Service1

        Dim ds As New DataSet
        ds = data.getDataSet("SELECT * FROM modulerecords")

    End Function
vdg_mrl -> datagrid name
justcaps -> database name


help appreciated >.<