Monday, March 12, 2012

Problems with iis and sql

Ok a while ago i posted that I had fixed a problem with uninstalling and reinstalling sql server (which is still fixed and is not the problem). Now, however, I've encountered a new problem. Whenever I try to access my website through IIS I get: 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. I tried searching for an answer, but I could not find one. So I went back into Visual Studio and ran a copy of my website through it, and it worked perfectly fine (but again, not in IIS). So I thought that maybe it was the .\App_Data\aspnetdb.mdf database that was causing the problems. So I tried to configure some settings by going through Website... ASP.NET Configuration... but I recived the error: An error was encountered. Please return to the previous page and try again. So I thought maybe it was just that one problem... So I created a new test website (by the way, I'm using an extened version of the Personal Web Starter Kit, so I used that as my test), and tried to run the website. The website started up (to generate the needed roles) but the website wouldn't even display properly (no images, styles, etc.) so I tried to see if I could even configure users through the ASP.NET Configuration, but I got the exact same error.

If anyone could help me with this problem I would be very happy. Thanks in advance.

Hi,

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=152338&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125227&SiteID=1

http://support.microsoft.com/default.aspx?scid=kb;en-us;896613

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment