Fail to access to my SQL file ( mdf )
-
I setup the my WCF service on server machine. The server OS is win 2008 with SQL 2008 express. I trying to access to my SQL file ( mdf file ) to read data using LINQ to SQL. I see that the DataContext is OK - but when i try to get information that in one of the table i get an exception "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 dont know what i need to define or change in the IIS 7.5 that im using in the server side.
-
I setup the my WCF service on server machine. The server OS is win 2008 with SQL 2008 express. I trying to access to my SQL file ( mdf file ) to read data using LINQ to SQL. I see that the DataContext is OK - but when i try to get information that in one of the table i get an exception "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 dont know what i need to define or change in the IIS 7.5 that im using in the server side.
Hi, Have a look at this conversation: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/fbf32aa8-2125-4919-be81-3baa399e2e0d[^]. There are specific steps defined to get rid of the problem. If the root cause in your problem is the same this could help.
The need to optimize rises from a bad design.My articles[^]