SQL 2008 database on another domain (not discountASP)

database access
05-18-2010 3:18 PM |

All fine in dev environment. (as usual). I have a SQL2008 database on a shared hosting site. I deploy my sl4 app to another different shared hosting site. In development I'm pointing to the remote SQL database and all works. Once deployed it returns an error (can't cut & paste the error!! ) but it saying that the remote server returned an error: Not Found. Is this a cross domain issue? if so, why does it not complain in VS2010? thank you

 

I just want to make sure I understand. You have a database at hosting company A and your application at hosting company B?

Neither are here?

Did you try publishing the app here instead of company B? Maybe company B wont allow you to connect outbound on 1433?

 

I have one domain (discountASP) that I'm deploying my SL4.
I have another domain (not discountASP) that I have my sql 2008 database.

After deploying to discountASP. I'm able to load the SL application fine, but when I request data from the database. I get the error that I list in my first message.

While testing in VS2010, my connection string is pointing to the remote database on the domain. No problems. If my problem is a cross domain issue should it not rear it's ugly head here also?

thank you.

 

We dont block attempts to connect to outside databases.

Id take SL out of the equation just to determine the root of the issue. Just make a simple asp.net page that connects to the database and see if you can.

 

OK. thanks I will try that asp.net idea.