Silverlight WCF services not returning any data from database, after deploying on server

Question

0.00/5 (No votes)

See more:

I have one silverlight application that reads the data from the database(SQL Server) using wcf services without using entity framework, on a click of a button. I deployed on my local system and it works fine. The same i deployed on the server and published it. I opened the page and clicked the button to get the data. But it doesn't display the data, also do not display any error. I am confused as to what could be the issue, on which side.

Posted 27-Jan-15 5:49am

nidhi86

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Winner78 · Answer 1 · 2015-01-27T21:10:00

Solution 1

Have you changed your connection string on server. You can try to test if your app becomes data from server using Fiddler.

Good luck!

Posted 27-Jan-15 21:10pm

Winner78

TheRealSteveJudge · Answer 2 · 2015-01-27T21:24:00

Your problem can have many reasons:

1) The Silverlight application cannot access the WCF service due to a cross domain issue.

Please read this: Making a Service Available Across Domain Boundaries: https://msdn.microsoft.com/en-us/library/cc197955%28VS.95%29.aspx[^]

2) The WCF service cannot access your SQL server due to missing rights

An application (your WCF service!) running in IIS
runs with a so-called Application-Pool Identity.
This is the default.

Please read:
http://www.iis.net/learn/manage/configuring-security/application-pool-identities[^]

If you run your application on your local system
everything runs with the currently logged on user and that is you.
On the productive system your WCF service runs with an application pool identity
probably "IIS AppPool\DefaultAppPool".

By using SQL Server Management Studio you must grant this user access to your database.

Moreover it is a good idea to use exception handling in your WCF service.
This article shows you how to do it:
Exception Handling in WCF[^]
This will allow you to find errors occurring during database access.