Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error:

The query against the database caused an error.

Correlation ID:7ebc312e-db3a-46a4-afbe-04b0115c4885

w3wp.exe (0x0CB4)-0x1AD8-SharePoint Foundation-Logging Correlation Data-xmnv-Medium Name=Request (POST:http://External%20List/Read%20List.aspx)-7ebc312e-db3a-46a4fbe-04b0115c4885

Some of the guys I work with have reset the IIS, can this be the problem?

Thanks.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

After hours and hours of searching and debugging I finally found out what the problem was:

Somebody had removed read/write access from the user I created in SQL Server. When checking Read/Write boxes everything works fine again.

If you want to learn about BCS: Take a look at this video about Business Connectivity Services

Thanks.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.