asp.net - SL app doesn't connect to Database from IIS, but does from VS2010 - SQL Server Auth, not Wndws Auth -


I have made two small / tested silverlight apps with VS 2010 (I'm new to this), both with one The problem is the same. .. When I run / debug inside VS2010, the app runs and it connects the database properly. But when I publish it on the IIS (same machine on VS2010), the app will run, but it will not be connected to the database.

I am using SQL Server authentication. I

Machine Windows 7 Premium (using the IIS 7.5.7600.16385 also has the same problem on my Windows 7 Pro machine)

I have had this problem on many machines (my colleagues are also) ... it is quite disappointing that we work directly from our IIS (connecting to DB) while walking from VS-2010. It is expected that this is a simple change to "fix"

I have tried to be a database on the same machine as IIS / VS2010, and when separated from one ... In both cases, the result is that when VS2010 is run, it works, but not IIS.

I have tried that there is no use here:

Otherwise, my IIS setup is mostly "out of the box".

My web .config file:

   & Lt; / ConnectionStrings & gt; & Lt; System.serviceModel & gt; & Lt; Service Hosting Environment ASPnet Compatibility Enabled = "True" Multiple SiteBindingsEnabled = "true" /> & Lt; /system.serviceModel> & Lt; System.web & gt; & Lt; Compilation debug = "true" targetFramework = "4.0" /> & Lt; HttpModules & gt; & Lt; Add name = "DomainServiceModule" type = "System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version = 4.0.0.0, Culture = Neutral, PublicKeyToken = 31bf3856ad364e35" /> & Lt; / HttpModules & gt; & Lt; /system.web> & Lt; / Configuration & gt;  

"itemprop =" text ">

Just to clarify: That your website can not connect to the database is? Are you using RIA services to get the Silverlight to connect to the database? Are you getting any errors or no data? If you have noticed in the Windows Event Viewer on the server, to see if IIS is dumping out an error for that?

I think that this is going to be permission based, then you have to connect to the SQL Server Management Studio database right wherever it lives (IIS site directory). If you have not done so, then copy the site to the InetPub / wwwroot folder and inherit permissions for IIS users.


Comments

Popular posts from this blog

Eclipse CDT variable colors in editor -

AJAX doesn't send POST query -

wpf - Custom Message Box Advice -