Solved

Unable to access external SQL Server from my Web

Posted on 2011-09-08
10
261 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 83

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 83

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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 83

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
 

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 83

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 83

Expert Comment

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

Featured Post

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

756 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