On my developer machine I don't have any problems with VS2005 and SQL Server 2005 Express. Now I should set up a server (Win2003Web) for a webhosting environment.
Every website has its own application pool with its own application pool user. Now if I try to connect to a db in my data directory I get the following 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.
I already read the other threads about that subject but they didn't help me because I need to connect to the db with different application pool users.Can somebody help me, please?!
Thanks, fabianOk, I think my problem is due to the fact that my application pool users haven't got a user profile and they aren't getting one because they can't login. I tried out to give one user the rights to login und afterwards i logged in. Since then the error is gone.
Is this the only solution to my problem? Do I must login with every new application pool user? I hope there's another solution .
I could create perhaps a directory in C:\Documents and...\ for the username but I don't think that would work?! Or create a user profile with a simple c# codesnipped (don't know if there's something like that)?
Any suggestions?
No comments:
Post a Comment