Posted on: 4/24/2013 7:49:45 AM | Views : 276

I'm investigating if it is possible to use LocalDB from a windows service that hasn't got the user profile loaded. From this site I have read that: "LocalDB stores system database files in user's AppData folder (see below). This means that when LocalDB is used from an application running as a non-interactive user account (including IIS), that user account should be configured to load user profiles, Otherwise, the instance starting process will fail." When running the service I get the following exception: System.Data.SqlClient.SqlException A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Serve ...

Go to the complete details ...