cant connect to server from a remote machine

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - SQL Server 2005/Yukon

cant connect to server from a remote machine

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-01 : 16:59:59

Hi Friends
I have a sql server (2005 standard edition) on Win xp machine. i can connect to this server from my machine ok but others on the network try to connect i get following error

"An error has occurred during report processing.
Cannot create a connection to data source 'dataSource1'.
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.) "

but my remote connection allows remote connects. i also enabled "Named pipes" and "VIA" protocols under sql configuration manager but no avail.
any ideas on this one.
Thanks for your help.

Cheers

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-01 : 18:29:26

Change your connection settings to TCP/IP.

You connection would work on a sinlge computer, but the communication protocol accross your network is TCP/IP

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-01 : 18:33:17

how do i do that plz ?
Thanks

Cheers

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-01 : 18:41:28

>>i also enabled "Named pipes" and "VIA" protocols under sql configuration manager but no avail.

Change it to TCP/IP

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-01 : 19:11:48

"TCP/IP" is already enabled but still get this error.
BTW after enabling "VIA" protocol i restarted sql server service now i get different error.
and it says request timed out !!

Cheers

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-01 : 19:26:02

Maybe the problem is elsewhere :(

But i would ask, are your network users.
1. able to ping the server
2. all using TCP/IP ?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-01 : 19:39:42

Yes to both questions .

Cheers

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-01 : 20:01:31

Have you run the Surface Area Config ?

----------------------------------
'KH'

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-01 : 20:13:04

no,i have not touched yet.
what i need to look in this one ,KH?

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-01 : 20:18:23

BTW i just ran Surface Area Config and under "remote connections" i have "TCP/IP" only option selected .

Cheers

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-01 : 21:16:43

Did you enabled for Local connection only or Local & Remote ?

----------------------------------
'KH'

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-02 : 00:00:18

yes, i selected "Local & Remote"

Cheers

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-02 : 00:31:06

Than remote client should be able to connect to the SQL Server. If not, check for any firewall installed on server

----------------------------------
'KH'

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-02 : 01:50:08

What is the error message now ?

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-02 : 14:50:19

today i get same error as i originally posted !!!

Cheers

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-02 : 17:33:50

If you dont have name pipes installed, i wonder why it would give you an error with name pipes.

Use TCP/IP ONLY

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-02 : 17:40:00

i just selected "TCP/IP and Named Pipes" option in remote connections area in surface area config and now i get following error

An error has occurred during report processing.
Cannot create a connection to data source 'dataSource1'.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Cheers

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-02 : 17:47:04

>>i just selected "TCP/IP and Named Pipes" option in remote connections

Remote connections ?

1. What are you trying to do ???
2. How did you setup the remote connection ???

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-02 : 18:00:01

i mean under surface area config tool
under database engine >> we have a "remote connections" , right ?
thats what i was talking abt.

Cheers

mr_mist
Grunnio

1870 Posts

Posted - 2006-02-03 : 03:45:39

Have you got windows firewall enabled and if so have you allowed traffic for file and print sharing ?

-------
Moo. :)

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-02-06 : 15:06:41

No . i disabled it.

Cheers