when i'm running my project in visual web developer it work fine retrieving data from database save data to data base.
but i trying that after deployment on IIS i'm getting error i.e




Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.




Glad to hear any thing from your side
thankyou

Are you using SQL Express or the SQL Server CE? In case SQL Server CE then you need to retrieve the server path instead of a hard-coded path. SQL Express put it as localhost or provide the exact name that appears in the SQL server IDE. And what type of access permission you are providing in the IIS?

__________________
Thanks in advance.

Regards,

Senthil Kumar M.

i have sql express edition

What exception fired when you develpment on IIS?