Error when publish: The schema update is terminating because data loss might occur

Question

Error 1 .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 8 Rows were detected. The schema update is terminating because data loss might occur.

When I build with option: "Host application service on an Internet Infomation Service (IIS Server)" in the "Application Server" group, the publish are successful.

I want to "Run application service on the end user's machine". Please guide me step by step to fix this problem. 

Thank you!

---

Triệu người quen có mấy người thân.

Answer 1

Before this error, you probably either deleted a table field or changed a field type some way.  If you know what you did, you can sometime fix at the DB.  For example, if you removed a field, then delete the field on the DB and publish again.  Backup first as always.

Answer 2

Thank you!

---

Triệu người quen có mấy người thân.