We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,259 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

ASP Connection and MS SQL 2008 Express Fail

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?

2
Contributors
2
Replies
12 Hours
Discussion Span
1 Year Ago
Last Updated
3
Views
hatrickwah
Newbie Poster
13 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

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

arden_k
Newbie Poster
16 posts since Jan 2012
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 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.

hatrickwah
Newbie Poster
13 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0639 seconds using 2.66MB