• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

Unable to access external SQL Server from my Web

Dear EE
we installed an ASP.NET WebApplication in our hosting , our application suppose to access an external Sql Server ( with public ip ), we already do this issue with another hosting and it was working fine, but when we try this with our current hosting in Godaddy , we received the following error:

Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

the connectionstring that i use was
Data Source=82.205.240.148;Database=OnlineApp;User ID=****;Password=*******;

Note: i used the same Connection string from IIS installed on my Laptop and connect to the SQL Server which is based on another Network and it work Fine.

i tried to create the same data base on our hosting Sql Server , everything work fine.

but, the problem that i need the Sql Server on external Server

Your Urgent Advice is highly appreciated

Best Regards
0
nasemabdullaa
Asked:
nasemabdullaa
  • 5
  • 4
2 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
Godaddy limits access in and out of their servers to preserve the security of the servers.  They are probably much more restrictive than you are on your laptop.  You need to find out what connections are needed so you can ask Godaddy if they allow them.

You error message says 'Named Pipes'.  Is there some reason you are not trying TCP on port 1433?  I ask because that is what I have always used for remote access and I thought it was a requirement.
0
 
nasemabdullaaAuthor Commented:
Hello DaveBaldwin

Thank you for your reply . I use TCP connection but this is general error I get it

Regards
0
 
Dave BaldwinFixer of ProblemsCommented:
I don't know that it will help but here are some alternative connection strings: http://www.connectionstrings.com/sql-server-2008
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Dave BaldwinFixer of ProblemsCommented:
I just talked to Godaddy support and they said they don't block that kind of outgoing access and that it 'should' be just a matter of writing the right script to do it.
0
 
nasemabdullaaAuthor Commented:
i still have the same error , i tried many connection strings, i already try to connect to my SQL Server from another server on different network and it connect with no problem,
0
 
Dave BaldwinFixer of ProblemsCommented:
I don't have any way to check anything else so you need to click on "Request Attention" above and see if you can find someone else who can.
0
 
nasemabdullaaAuthor Commented:
Hello

Please the problem in Godady server I buy another hosting in Lunerpages and its work now

Regards
0
 
nasemabdullaaAuthor Commented:
Hello

Its part of answer
0
 
Dave BaldwinFixer of ProblemsCommented:
I'm glad you found hosting that works for you.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now