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.
- 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"
- i tried to run /mydomain/forum/install
i get the error posted above.
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.
The database included with YAF 184.108.40.206 requires SQL 2008 R2 SP3.
If you use SQL 2008 R2 (or SP1, or SP2) it won't work.
FTR, I'm still not up and running yet.
For even more clarification, check the whole topic which will explain the issue and the path to resolution. Search rocks!
EDIT: The connection string given in above topic is for an SQLExpress server on the same machine as the webserver. If it's at a different IP or dns name, you need to update the connection string as needed.
The next issue is email. We use "POP before SMTP" mail security for legacy reasons, but that doesn't seem to be supported. I have to dig into this a bit more before posting questions.
PS ... and yes, i saw the Colleen posts before posting 🙂
minor update: The database included with YAF 220.127.116.11 requires SQL 2008 R2 SP3.If you use SQL 2008 R2 (or SP1, or SP2) it won't work.FTR, I'm still not up and running yet.
If you use the connection string that connects to the server itself, then run the install script, your database will be housed on the server, and is supported on SQL 2005/2008 full or express (express does not support Full Text Indexing)... I've never used the flatfile on an installation - always native client to the sql server and let the server instance house the db, not the webserver datastore.