Error while connecting remote SQL server

  • Thread starter shivaranjaniadimulam21
  • Start date
S

shivaranjaniadimulam21

hi all,
I trying to connect remote sql server from my machine. but
it giving me some errors

Here are few errors listed,
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
connection to SQL Server))

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

A connection was successfully established with the server, but then
an error occurred during the pre-login handshake. 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: 0 - No process is on the other
end of the pipe.) (Microsoft SQL Server, Error: 233)

A connection was successfully established with the server, but then
an error occurred during the login process.(provider: Named Pipes
Provider, error: 0 - No process is on the other end of the pipe.)

To solve this problem I did following changes in SQL server

Enable the TCP/IP protocol using the Surface Area Configuration
Utility
Make sure the TCP/IP protocol is enabled in the SQL Server
Configuration Utility
start SQL Server browser
Exceptions are added in Firewall
Restart the computer

But still I am getting same errors.
Please give me some solution for this problem....
Thanks in advance.
 
W

William \(Bill\) Vaughn

Have you granted rights to members of the sysadmin role? This is done via
the SQL Server Surface Area Configuration tool. It launches the SS 2005 User
Provisioning Tool for Vista.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

hi all,
I trying to connect remote sql server from my machine. but
it giving me some errors

Here are few errors listed,
?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
connection to SQL Server))

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

?A connection was successfully established with the server, but then
an error occurred during the pre-login handshake. 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: 0 - No process is on the other
end of the pipe.) (Microsoft SQL Server, Error: 233)

?A connection was successfully established with the server, but then
an error occurred during the login process.(provider: Named Pipes
Provider, error: 0 - No process is on the other end of the pipe.)

To solve this problem I did following changes in SQL server

?Enable the TCP/IP protocol using the Surface Area Configuration
Utility
?Make sure the TCP/IP protocol is enabled in the SQL Server
Configuration Utility
?start SQL Server browser
?Exceptions are added in Firewall
?Restart the computer

But still I am getting same errors.
Please give me some solution for this problem....
Thanks in advance.
 
G

Guest

I understand your frustration, I have the same problem and I did what you did
and the problem still there
.......A connection was successfully established with the server, but then an
error occurred during the pre-login handshake. 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: TCP Provider, error:
0 - An invalid argument was supplied.)

PLEASE WE NEED HELP ASAP......

vene
 
R

Raghu

I had the same problem, then I changed the my connection string earlier I
used the machine name then I tried with IP address it is working fine

before that check remote connection enabled
 
G

Gujju............

I faced the same problem. I wasted almost a week. Finally I got the solution.
There are so many reasons behind the same problem.
One of then is as below.

There might be possoble you have defined aliases for the SQL server in your
machine.

To check the alias :

Go to Control Panel -> Administrative Tools -> Computer Management : Open It

Expand Services And Application-> SQL Server Configuration Manager->SQL
Native Client Configuration

Check Aliases Option Under.

If you find any aliases for the SQL Server that you are getting problem.
Delete it for time being and test it.

For me it works hope that will help you too. Thanks.
 
W

William Vaughn

I suggest reading my whitepaper on connecting. See www.betav.com/blog/billva
http://betav.com/blog/billva/2006/06/getting_and_staying_connected_1.html
While it looks like you've been working through the issues, the paper might
help identify a few more.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
T

tanya_MCAD

for the first error means (Provider: Named Pipes Provider,error:40)

open Visual Studio 2005,click on View Menu to open Server Explorer

Right Click on Data Connections and choose Add Connection... option.

A dialog box of Add Connection will be open , write server name(to find
out server name right click on my computer, what ever name u find paste
those name on server name combo box and again write /SQLEXPRESS for eg:-
'hcl-3/SQLEXPRESS'), choose Use Windows Authentication and then select
or enter database name for eg:-'master'.

try this process hope ur will be solved
 
T

tanya_MCAD

for the first error means (Provider: Named Pipes Provider,error:40)

open Visual Studio 2005,click on View Menu to open Server Explorer

Right Click on Data Connections and choose Add Connection... option.

A dialog box of Add Connection will be open , write server name(to find
out server name right click on my computer, what ever name u find paste
those name on server name combo box and again write /SQLEXPRESS for eg:-
'hcl-3/SQLEXPRESS'), choose Use Windows Authentication and then select
or enter database name for eg:-'master'.

try this process hope ur will be solved
 
T

tanya_MCAD

for the first error means (Provider: Named Pipes Provider,error:40)

open Visual Studio 2005,click on View Menu to open Server Explorer

Right Click on Data Connections and choose Add Connection... option.

A dialog box of Add Connection will be open , write server name(to find
out server name right click on my computer, what ever name u find paste
those name on server name combo box and again write \SQLEXPRESS for eg:-
'hcl-3\SQLEXPRESS'), choose Use Windows Authentication and then select
or enter database name for eg:-'master'.

try this process hope ur will be solved
 
I

isha

Hi
i had a same problem.......

but solved it!
check your Connection String ... chnage the server name to the SQl server
instance name n do trusted_connection = yes

eg;
"server=MainServer-01;database=Test Database;Trusted_Connection=yes";

it works!

isha
 
S

sush

isha said:
Hi
i had a same problem.......

but solved it!
check your Connection String ... chnage the server name to the SQl server
instance name n do trusted_connection = yes

eg;
"server=MainServer-01;database=Test Database;Trusted_Connection=yes";

it works!

isha
Click to expand...
 
S

sush

hi all sorry for my last post without any message in that..

i am having the same problem connecting to sql server 2005 and it is giving
the same error as was mentioned in all the above posts .. i tried all the
solutions that were described in the posts but of little luck.. what ever i
do i still get the same message.

i have enabled remote connection via tcp/ip and named pipes and put the
authentication mode to windows but i am still getting the same problem.

My connection string is correct ..

please post some more solutions as it is urgent..

thanks in advance
sush
 
A

aspdonetbrasil.net

I faced the same problem. I wasted almost a week. Finally I got the solution.
There are so many reasons behind the same problem.
One of then is as below.

There might be possoble you have defined aliases for the SQL server in your
machine.

To check the alias :

Go to Control Panel -> Administrative Tools -> Computer Management : Open It

Expand Services And Application-> SQL Server Configuration Manager->SQL
Native Client Configuration

Check Aliases Option Under.

If you find any aliases for the SQL Server that you are getting problem.
Delete it for time being and test it.
Click to expand...

Tente esse link: http://www.saintsilva.com/Fix-SQL-PT.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot connect a remote sql server 9
SQL 2005 Error connecting to SQL2000 1
Problem connecting to SQL 2
SQL2000 error: ... When connecting to SQL Server 2005 2
SQL Server 2000 9
SqlConnection.Open() Which ErrorCodes 11
Sql Server Express won't let me connect 8
connecting to sqlserver express 9

Top