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.
| Author |
Topic |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2007-02-01 : 09:38:47
|
| Hi there SQL TeamWe have 2 server both using win 2003 Server and SQL 2005Both of these sit behind a firewall.All traffic in both direction are allowed for both servers on both firewallsServer 1 SQL listens on Port 2043Server 2 SQL listens on Port 1433Server 2 is trying to use SQL Management Studio to connect to Server 1 and it fails?A telnet From Server2 to Server 1 on port 2043 works 100%Server 1 allows remote SQL connections.Server 1 = 196.x.x.x\SQL2005Can someone please assist in getting this to work?Our Network guy at Server 1 Firewall 1 says that he can not see any traffic coming from Server 2; he can however see the telnet connection.Please also note that if Server 2 tries to connect to our 2000 SQL instance listening on 1433 it works 100% |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-01 : 09:43:43
|
have you configured the Surface Area to allow remote connections ?
KH |
 |
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2007-02-01 : 09:49:29
|
| Hi khtanSorry what do you mean "Surface Area" Do you mean right click on the server in object explore select properties then connections, and then tick allow remote connections? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-01 : 09:51:31
|
SQL Server 2005 by default does not allow for remote connectionsGo toSTART - ALL PROGRAMS - SQL SERVER 2005 - Configuration Tool - SQL Server Surface Area Configuration
KH |
|
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2007-02-01 : 10:01:59
|
| Oh yes this has been configured to allow remote connections for both TCPIP and Named Pipes.Please also note that we also have SERVER 3 on the same network as SERVER 1 also with Win 2003 and SQL 2005 and we are able to connect to SERVER 1 |
|
|
|
|
|
|
Remote connection problem