Solved

Unable to access external SQL Server from my Web

Posted on 2011-09-08
10
258 Views
Last Modified: 2013-11-05
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
Comment
Question by:nasemabdullaa
  • 5
  • 4
10 Comments
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 36508589
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
 

Author Comment

by:nasemabdullaa
ID: 36508958
Hello DaveBaldwin

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

Regards
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 36509051
I don't know that it will help but here are some alternative connection strings: http://www.connectionstrings.com/sql-server-2008
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 36509079
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:nasemabdullaa
ID: 36515381
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
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 36515471
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
 

Assisted Solution

by:nasemabdullaa
nasemabdullaa earned 0 total points
ID: 36521020
Hello

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

Regards
0
 

Author Closing Comment

by:nasemabdullaa
ID: 36547928
Hello

Its part of answer
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 36521121
I'm glad you found hosting that works for you.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now