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.

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)
-----------------------------------------------------------------------------------------------------------------------

<shivaranjaniadimulam21 (AT) gmail (DOT) com> wrote

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.

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

"shivaranjaniadimulam21 (AT) gmail (DOT) com" wrote:

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

"Vene" wrote:

Hey.. I too had same problem...
but have found solution... on my blog :

http://purusworld.blogspot.com/searc...SQL% 20server

"Vene" wrote:

I suggest reading my whitepaper on connecting. See www.betav.com/blog/billva
http://betav.com/blog/billva/2006/06...nnected_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)
__________________________________________________ __________________________________________
"Gujju............" <Gujju............ (AT) discussions (DOT) microsoft.com> wrote in
message news:BD15121C-6646-41A4-8E58-5B67D70E0455 (AT) microsoft (DOT) com...

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




*** Sent via Developersdex http://www.developersdex.com ***

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




*** Sent via Developersdex http://www.developersdex.com ***

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



*** Sent via Developersdex http://www.developersdex.com ***

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