Solved

Unable to access external SQL Server from my Web

Posted on 2011-09-08
10
259 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 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
 
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 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

23 Experts available now in Live!

Get 1:1 Help Now