HI..

Opening office documents from sharepoint site asking username and password ..how to so

Hi!

Most of the times this is because you need to add your SharePoint site to the Trusted Sites zone in Internet Explorer. Have you done that?

Check this link for information on how to do this.

http://www.uta.edu/oit/cs/software/microsoft/sharepoint/how_to/sp_add_trusted_site/index.php

Hi..

I tried your solution but not working ..still asking for Credentials

hi

what authentication do you use: Windows or FBA? There can be many reasons of this, check this articile: Authentication requests when you open Office documents. E.g. in our case it was necessary to disable PROPFIND and OPTIONS verbs in web.config (it is one of the method in the link above). Start analysis with checking do you have client integration enabled in the Central administration > Manage web applications > Authentication providers > select provider and ensure that Enable client integration is set to Yes.