Silverlight, SQL Server & Visual Studio: Create a Test Page on the Web
I am working on a SQL Server 2008 Express + silverlight project and at the moment everything is working on local machine. I have set it up where the silverlight application connects to SQL Server using service link and LINQ, and I believe SQL Server allows remote connections with TCP / IP.
However, since the silverlight application is an .aspx file, it must run on a web server. When I click "run" in visual studio (2008), IE appears with the address " http: // localhost: 1437 / SQLTestTestPage.aspx " and everything works correctly. In order to remotely use this page, I would like to be able to access the same page with http://10.215.22.57:1437/SQLTestTestPage.aspx "where 10.215.22.57 is the IP of the local machine. It doesn't work now and I am for sure don't know how to enable it Is this even possible via SQL Server or do I need to set up a separate HTTP server to host the aspx page?
Thanks, -Robert
Edit: Actually, since I am running the Silverlight application from within Visual Studio, I assume it is actually VS that is setting up the web server that hosts the .aspx page, not the SQL server.
a source to share
It looks like there could be a lot of things here. To abort the chase, your best bet is to move the web project to IIS instead of the development web server and then try to point it to the external IP. To do this, right-click the MySilverlightApp.Web project (ASP.NET project containing the .aspx page) and select Properties. Click the Web tab, then under Servers. Select Use Local IIS Web Server instead of Use VS Dev Server. You should be prompted to create a virtual directory; select "Yes". Hit F5 to debug in VS and you should see your site with a new localhost url for your IP and hopefully it will still work. The reason it doesn't work with VS Dev Server is because the server goes away when you stop debugging in VS. Besides,there are many things that can go wrong (IIS not installed, ASP.NET not registered with IIS, cross-domain policy violations, and other SQL connectivity issues) so post your results!
a source to share