Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

Hi, The application scenario is calling WebService through Biztalk2006 from ASP.NET application. For that we have done like below: 1. We have the webservice with a DataBase call (WebMethod is getting data from database). 2. Consuming webservice (which is created in step-1) through biztalk orchestration(added the WebService reference to the BizTalk Orchestration application) . 3. Exposing orchestration (Which is created in step-2) as webservice by using ‘BizTalk Web Services Publishing Wizard’. 4. Adding reference of orchestration webservice (which is created in step-3) to ASP.NET client application. When we are trying to call from client application, we are getting following error: 1) Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. 2) An attempt to connect to “BizTalkMgmtDb” SQL Server database on server “01HW201536” failed. Error: “Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.” 3) The Messaging Engine failed to register the adapter for “SOAP” for the receive location “”. Please verify that the receive location exists, and that the isolated adapter runs under an account that has access to the BizTalk databases. Kindly help me how to resolve this issue.

I have tried folowing options:
Option-1)
goto command prompt then navigate to directory
 
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
 
Now run this command
 
aspnet_regiis -ga “NT AUTHORITY\NETWORK SERVICE”
 
Everything will wok fine.

Option 2)

 submit this line into query analyzer on master or your database to grant access:
sp_grantlogin ‘NT AUTHORITY\NETWORK SERVICE’

Thanks Sudhakar