How to fix: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path.
If you are receiving the following error:
System.Data.SqlClient.SqlException: 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.
It means you are either trying to connect an mdf file to the SQL server or are in another way trying to create your own instance of SQL server. In a shared environment, it is not possible to do this. To use that database file, you will need to make a backup of it in a .bak format. Then, from your control panel:
1) Make a database: http://blog.arvixe.com/how-to-set-up-a-sql-2008-database/
2) Restore the .bak file into the database: http://blog.arvixe.com/how-to-backup-and-restore-a-database-in-websitepanel/
3) Change your connection string to appropriately use the SQL server instance on your server:https://support.arvixe.com/index.php?/Knowledgebase/Article/View/51/0/do-you-have-a-connection-string-i-can-use-to-connect-to-the-local-mssql-database
- 0 Users Found This Useful
