Hosting WCF service in Windows service

0
votes

There is a client in the form of an ASP.NET MVC application, there is a WCF service, requests to the WCF service are sent from the client, the service itself manipulates database data through the Entity Framework. Everything works locally in the Visual Studio development environment via IIS Express, but when I deploy this service on a Windows service, an error appears

"The underlying provider failed on Open."

DB connection string in app.config

<connectionStrings>
    <add name="AddressBookEntities" 
         connectionString="metadata=res://*/ContactModel.csdl|res://*/ContactModel.ssdl|res://*/ContactModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|\AddressBook.mdf;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" 
         providerName="System.Data.EntityClient" />
</connectionStrings>
1
c#sql-serverentity-frameworkwcf

1 Answers

0
votes

I suggest you use SQL Server Express, attached filename requires a particular user context