Geeting an error after online but in Local it runs fine

Question

0.00/5 (No votes)

See more:

, +

I am Getting this one error:-

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

the website runs perfectly but whenever i click on add to cart option on my website then it shows the error,plz plz solve anyone...........

Posted 10-Feb-13 18:05pm

garimagupta66

Add a Solution

Comments

Gunjan Bhasin 11-Feb-13 0:48am

check your connection string.

garimagupta66 11-Feb-13 1:14am

i have checked the connection string ,the entire pages runs fine but error is when i m click on add to cart option.....

4 solutions

Solution 1

The reasons for throwing this issue could be wrong server name, disabled remote connection and firewall blocking.

Please go through this link[^].

Update:

http://technet.microsoft.com/en-us/library/cc739791%28v=ws.10%29.aspx#BKMK_4[^]

http://msdn.microsoft.com/en-us/library/cc646023.aspx[^]

Posted 10-Feb-13 18:12pm

arindamrudra

Updated 10-Feb-13 19:31pm

v3

Comments

garimagupta66 11-Feb-13 1:13am

so how can i able remote connection and firewall block?????plz plz ans me.......

garimagupta66 11-Feb-13 1:51am

Thanx for this ans but actually need to know this will be i do on Local Database or on server.

Solution 2

so how can i able remote connection and firewall block?????plz plz ans me.......

Posted 10-Feb-13 19:18pm

garimagupta66

Solution 4

Actually i need to know this problem is on my end or where the database is host.our database is host on Znet Live and they said this is our end problem mean a programming error so plz plz tell me wheree this changes i do it in my Local PC or this will be do by the Support..........

Posted 10-Feb-13 19:58pm

garimagupta66

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2013-02-10T19:27:00

Check the three points listed below:
1. Make sure your database engine is configured to accept remote connections(I you are using centralized database)

Quote:
•Start -> All Programs -> SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration
•Click on Surface Area Configuration for Services and Connections
•Select the instance that is having a problem -> Database Engine -> Remote Connections
•Enable local and remote connections
•Restart instance

2. Check the SQL Server service account

Quote:
•If you are not using a domain account as a service account (for example if you are using NETWORK SERVICE), you may want to switch this first before proceeding

3.If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings in your ASweb P.NET application

Quote:
•Usually the format needed to specify the database server is machinename\instancename
•Check your connection string as well.

Refer the link below:
A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

--Amit

Geeting an error after online but in Local it runs fine

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us