Click here to Skip to main content
14,331,612 members
Rate this:
Please Sign up or sign in to vote.
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
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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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
   
v2
Comments
Parviz Bazgosha 6-Jul-12 2:15am
   
thanks for your Solution
i now add alias by name parviz
i got this error at sql mangement express


TITLE: Connect to Server
------------------------------

Cannot connect to parviz.

------------------------------
ADDITIONAL INFORMATION:

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) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Sandeep Mewara 6-Jul-12 2:26am
   
Answer updated.
Prasad_Kulkarni 6-Jul-12 2:50am
   
Great answer! +5
Parviz Bazgosha 7-Jul-12 0:35am
   
sorry i cant be connect
plasee help me.

my os is windows 7 .
now error show error code 40...
please help me
Parviz Bazgosha 25-Jul-12 13:36pm
   
i can connet to sql server 2008 at windows xp no problem...
i cant at windows seven what is problem with windows seven 64 bit?

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100