How to update WCF service APIs in IIS website

Question

I am new to WCF Service and IIS. Please help. Set up is mentioned below. 1. I have Entity framework project which deal with Database. 2. Then I have WCF service class library (no app.config file) which writes or read values from EF project. 3. At the end I have website project (ASP.Net Website) which hosts WCF service on IIS (This project has Web.Config file which contains WCF service configuration). 4. In IIS, I created a new application under Default Web Site. When I browse the Service.svc file, I can see all the APIs\methods exposed by WCF service.

 

Now the problem is, it worked first time. But I want to add new APIs in WCF service, but those APIs are not getting reflected in IIS hosted URL.

 

Things I tried -> 1. Building entire solution. 2. Removing reference of WCF project libraries from website project and reattaching. 3. Building website and publishing website. 4. Reset IIS Manager and refresh everything.

 

Please help how can I update the APIs exposed in IIS when update the WCF service.

Answer 1

Hey Devendra

There might be any software glitches, take the backup of your database from the physical path located at

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

 

then reinstall the Sql Server again, then try attaching all your database.

 

Hope this helps :) 

Answer 2

Go to > Security > Logins > Right click to the user > Properties

On the left navigation move to > User Mapping > Check the database and in the "Database role membership for: <>" check "db_owner"

  

Or just restart the SQL service, sometime it also helps 

Answer 3

@Rafnas, already tried, also restarted the service but :(

Answer 4

Thanks Daniel, The error still exists as master/any database was also not accessible. Logins section displays only builtin\users and sa

Answer 5

try running in administrator mode, to do that

right click on SQL Server Management Studio and select run as administrator