I generate my databases on the fly while using Active Record.
Every time I start a new project and fire up the app to auto-gen the SQL Express DB I get this error:
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.
… and it drives me nuts. I work on a project just long enough to forget what I did to fix that error. I’m going to document it here.
The reason this is happening is because the user instance that I’m running IIS under does not have the proper credentials. You can fix this by creating a new app pool in IIS, and having it run under a user that has the rights to create a db (most likely your own account). What I do is create an AppPool called “PrivilegedAppPool” and have it run under my own account. Then restart IIS and you should be able to create your db on the fly.
Presto. No more errors.
haha says
authentic nfl jerseys Inexpensive items
coach bags on sale I am confident with his
coach outlet store online First step in success
coach outlet online Workmanship
coach bags outlet Value of goods
coach outlet store Of love
wholesale designer bags Beautiful lines
coach bags outlet There range of children
cheap coach What are you waiting
wholesale nfl jerseys Is always expected
authentic nfl jerseys It is pretty good