my sql server cant be access from remote connetion

Question

0.00/5 (No votes)

See more:

hi every body.

my sql server cant be access from remote connetion

i enabled allow remote connetion at connetion and but
i cant access to sql server from a other computer at network

please help me

Posted 5-Jul-12 19:32pm

Parviz Bazgosha

Add a Solution

Comments

Sandeep Mewara 6-Jul-12 1:47am

It would be good if you share the EXACT error to get proper help.

Parviz Bazgosha 6-Jul-12 2:00am

oh ok.
that is connection:
Network =DBMSSOCN; Data Source=192.168.1.104,1433; Initial Catalog=reza; User ID=PB; Password=12
it is take 10 sec and get me this 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

but when i want connect to server at server computer i connected without problme

1 solution

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)

Sandeep Mewara · Accepted Answer · 2012-07-05T20:03:00

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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.

This error means, the server you are trying to connect is found, but for some reason denying the client access. Client is trying to connect through an invalid port or it does not allow remote connections or a firewall issue.

Look here for full detailed explanation here:
Error message: TCP Provider.. - Cause & Resolution[^]
MSDN Blog: (provider: TCP Provider, error: 0 - No connection..[^]

If needed, troubleshoot more following this: MSDN Blog: TCP Provider: No connection could be made because..[^]

UPDATE:

Could not open connection...
Generally, it is surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

If needed, See steps for setting up Surface area configuration here..

Here, look at the following blog entries related to the same:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running