i just spent 4 hours trying to get YAF to connect to SQL Express 2008 R2 on my virtualized web server. I get this error message:
Failed to connect:
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.
Yes, i have found this same error in other posts on this forum, i've googled as well, but i still don't have a clear solution.
my setup:
- running Windows Server 2008 (all working good)
- my web site has been up and running (all good for months)
- .NET 4.0 set in the application pool
i did this:
- downloaded YAF, installed to /forum and moved files as directed (config to root)
- config files are in /mydomain
- updated app.config with my password
- updated web.config with my new machine key (generated by IIS)
- downloaded and installed SQL Server 2008 R2 Express
- created a new User "sqluser" (not admin, just user)
SQL Server Properties- not using a "Built-in account" (unchecked)
- logged on as ".\sqluser"
next...
- i tried to run /mydomain/forum/install
i get the error posted above.
db.config Also, i have 13 screenshots of my settings that could make it easier to see what's going on. I can provide this privately to anyone that can help.
- SQL settings
- User Account settings
- IIS settings .. connection string <--- this one may be good
If possible, please post the EXACT correct code to copy into this db.config file.
thanks for your help.
ac
Edited by user
9 years ago
|
Reason: screenshots are available