Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

i have a connection issue while uploading my site on web server

Hi
My application work well on local station
but it give error while uploading on web server
u can check it on
http://www.supplydirectinc.com/calling.aspx
Pls help
Any help will be appriciated.
Thanks in advance
0
psaini172000
Asked:
psaini172000
1 Solution
 
ZoooinkCommented:
Check your connection string is correct, have you tried connecting to your SQL database remotely? You could try connecting to it via Visual Studio 2005
0
 
BrandonGalderisiCommented:
Is it SQL Server Express or Standard?  Is the SQL DB local to the server or on a different machine.  Did you update the connection string when you moved it to the new server?
0
 
psaini172000Author Commented:
WE ARE USING SQL SERVER 2005 DATA BASE SERVER AND WEB SERVER ON SAME STATION

Error massage ( An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

any idea
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
ZoooinkCommented:
It sounds like a connection string issue, check your connection string and make sure it is connecting to the remote SQL Database, not your local instance. Also, try and connect to the databse through a data connection using visual studio to confirm that you can actually connect to it.
0
 
mezeusCommented:
Hi
i checked the website, sounds you have an error in connection string,
<< ....(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) >>

i assume you're using server name or instance name, if so, try to replace with server IP where the files are hosted (either on your domain or public domain)
try to change it to looks like this one
e.g.:  Data Source=IP;Initial Catalog=dbname;Integrated Security = SSPI; Trusted_Connection=Yes;
try to put instead of "IP" a " . " for local or the ip address of the station
if it didnt works, you may have a remote connection issue,
you should configure  your sql 2005 to allow remote connections
check this link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
hope that help
0
 
psaini172000Author Commented:
I just checked Remote connections is anabled tcp/ip and named pipes
Praveen
0
 
ZoooinkCommented:
What is your actual connection string, post it here so we can see if there are any errors, ommit any username and password info
0
 
psaini172000Author Commented:
SORRY MY PROBLEM REMAINS SAME
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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