1,105,344 Community Members

ASP Connection and MS SQL 2008 Express Fail

Member Avatar
hatrickwah
Newbie Poster
13 posts since Jul 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

I'll try to keep this short, and to the point.
I've set up a Windows Home Server 2011, running MS SQL Server 2008R2 Express. I enabled TCP/IP protocol on 1433 static, and named pipes (no changes to named pipes). Remote connections work no problem via remote SQL Server Management Studio. However, when I try to remote connect via my ASP connect string, it fails. I can access the database with the local site address via the page I'm hosting on the server, but once I try to use the same site on my hosted accounts elsewhere, it fails.
Any ideas? Am I missing a toggle somewhere?

Member Avatar
arden_k
Newbie Poster
16 posts since Jan 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi,
where is "elsewhere"? Is there a firewall inbetween your hosted account and the db?

Member Avatar
hatrickwah
Newbie Poster
13 posts since Jul 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

My WHS is at one location, while shared hosting is another. There is a firewall on my side, but its open on 1433. I can access the WHS from remote with Management Studio via interweb, but can't get my ASP connection script to connect.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article