Gregory Miller
asked on
SQL Server blocked from network users
EBS was installed a year ago and is running well. Installed SQL last week on a member server that has been a part of the domain from the beginning. Everything works fine from the SQL Server box but I cannot connect to it from any other system, server or workstation, on the same domain and network.
Please make suggestions as I need to solve this in a few hours or call Microsoft
Please make suggestions as I need to solve this in a few hours or call Microsoft
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
are network protocols enabled?
go to sql server configuration manager, select network configuration, protocols for <your instance name>, make sure at least named pipes and tcp/ip are enabled.
what about windows firewall?
remember to open ports and/or allow sql server and sql browser processes to receive incoming connections.
go to sql server configuration manager, select network configuration, protocols for <your instance name>, make sure at least named pipes and tcp/ip are enabled.
what about windows firewall?
remember to open ports and/or allow sql server and sql browser processes to receive incoming connections.
ASKER
If I do a netstat -a -n on the local box, should I see the tcp/1433 port or no? This is puzzling...
netstat -a -n
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:444 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1688 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2002 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2382 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:6051 0.0.0.0:0 LISTENING
TCP 0.0.0.0:16447 0.0.0.0:0 LISTENING
TCP 0.0.0.0:47001 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49152 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49153 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49154 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49155 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49172 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49217 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49227 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49604 0.0.0.0:0 LISTENING
TCP 0.0.0.0:50350 0.0.0.0:0 LISTENING
TCP 127.0.0.1:2002 127.0.0.1:57069 ESTABLISHED
TCP 127.0.0.1:10110 0.0.0.0:0 LISTENING
TCP 127.0.0.1:49605 0.0.0.0:0 LISTENING
TCP 127.0.0.1:57069 127.0.0.1:2002 ESTABLISHED
TCP 127.0.0.1:57532 0.0.0.0:0 LISTENING
TCP 127.0.0.1:58131 127.0.0.1:57532 TIME_WAIT
TCP 127.0.0.1:58135 127.0.0.1:57532 TIME_WAIT
TCP 127.0.0.1:58170 127.0.0.1:57532 TIME_WAIT
TCP 192.168.20.138:139 0.0.0.0:0 LISTENING
TCP 192.168.20.138:445 192.168.20.112:61950 ESTABLISHED
TCP 192.168.20.138:445 192.168.20.172:52491 ESTABLISHED
TCP 192.168.20.138:49604 192.168.20.138:58058 ESTABLISHED
TCP 192.168.20.138:54401 192.168.21.21:5723 ESTABLISHED
TCP 192.168.20.138:57042 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:57044 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:57460 192.168.21.21:445 ESTABLISHED
TCP 192.168.20.138:57531 64.62.195.166:443 ESTABLISHED
TCP 192.168.20.138:57706 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:57710 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:58058 192.168.20.138:49604 ESTABLISHED
TCP 192.168.20.138:58132 192.168.20.143:135 TIME_WAIT
TCP 192.168.20.138:58140 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58141 64.62.236.15:443 TIME_WAIT
TCP 192.168.20.138:58142 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58144 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58153 64.62.236.15:443 TIME_WAIT
TCP 192.168.20.138:58159 64.62.236.15:443 TIME_WAIT
TCP 192.168.20.138:58162 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58164 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58169 64.62.195.165:443 ESTABLISHED
TCP 192.168.20.138:64614 216.52.233.237:443 ESTABLISHED
TCP [::]:80 [::]:0 LISTENING
TCP [::]:135 [::]:0 LISTENING
TCP [::]:443 [::]:0 LISTENING
TCP [::]:444 [::]:0 LISTENING
TCP [::]:445 [::]:0 LISTENING
TCP [::]:1688 [::]:0 LISTENING
TCP [::]:2382 [::]:0 LISTENING
TCP [::]:3389 [::]:0 LISTENING
TCP [::]:47001 [::]:0 LISTENING
TCP [::]:49152 [::]:0 LISTENING
TCP [::]:49153 [::]:0 LISTENING
TCP [::]:49154 [::]:0 LISTENING
TCP [::]:49155 [::]:0 LISTENING
TCP [::]:49172 [::]:0 LISTENING
TCP [::]:49227 [::]:0 LISTENING
TCP [::]:49604 [::]:0 LISTENING
TCP [::]:50350 [::]:0 LISTENING
TCP [::1]:49605 [::]:0 LISTENING
UDP 0.0.0.0:123 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:5355 *:*
UDP 127.0.0.1:51640 *:*
UDP 127.0.0.1:55849 *:*
UDP 127.0.0.1:58613 *:*
UDP 127.0.0.1:64672 *:*
UDP 127.0.0.1:64673 *:*
UDP 192.168.20.138:137 *:*
UDP 192.168.20.138:138 *:*
UDP [::]:123 *:*
UDP [::]:500 *:*
UDP [::]:1434 *:*
UDP [::]:4500 *:*
UDP [::]:5355 *:*
netstat -a -n
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:444 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1688 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2002 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2382 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:6051 0.0.0.0:0 LISTENING
TCP 0.0.0.0:16447 0.0.0.0:0 LISTENING
TCP 0.0.0.0:47001 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49152 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49153 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49154 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49155 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49172 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49217 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49227 0.0.0.0:0 LISTENING
TCP 0.0.0.0:49604 0.0.0.0:0 LISTENING
TCP 0.0.0.0:50350 0.0.0.0:0 LISTENING
TCP 127.0.0.1:2002 127.0.0.1:57069 ESTABLISHED
TCP 127.0.0.1:10110 0.0.0.0:0 LISTENING
TCP 127.0.0.1:49605 0.0.0.0:0 LISTENING
TCP 127.0.0.1:57069 127.0.0.1:2002 ESTABLISHED
TCP 127.0.0.1:57532 0.0.0.0:0 LISTENING
TCP 127.0.0.1:58131 127.0.0.1:57532 TIME_WAIT
TCP 127.0.0.1:58135 127.0.0.1:57532 TIME_WAIT
TCP 127.0.0.1:58170 127.0.0.1:57532 TIME_WAIT
TCP 192.168.20.138:139 0.0.0.0:0 LISTENING
TCP 192.168.20.138:445 192.168.20.112:61950 ESTABLISHED
TCP 192.168.20.138:445 192.168.20.172:52491 ESTABLISHED
TCP 192.168.20.138:49604 192.168.20.138:58058 ESTABLISHED
TCP 192.168.20.138:54401 192.168.21.21:5723 ESTABLISHED
TCP 192.168.20.138:57042 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:57044 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:57460 192.168.21.21:445 ESTABLISHED
TCP 192.168.20.138:57531 64.62.195.166:443 ESTABLISHED
TCP 192.168.20.138:57706 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:57710 216.52.233.237:443 ESTABLISHED
TCP 192.168.20.138:58058 192.168.20.138:49604 ESTABLISHED
TCP 192.168.20.138:58132 192.168.20.143:135 TIME_WAIT
TCP 192.168.20.138:58140 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58141 64.62.236.15:443 TIME_WAIT
TCP 192.168.20.138:58142 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58144 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58153 64.62.236.15:443 TIME_WAIT
TCP 192.168.20.138:58159 64.62.236.15:443 TIME_WAIT
TCP 192.168.20.138:58162 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58164 64.62.236.10:443 TIME_WAIT
TCP 192.168.20.138:58169 64.62.195.165:443 ESTABLISHED
TCP 192.168.20.138:64614 216.52.233.237:443 ESTABLISHED
TCP [::]:80 [::]:0 LISTENING
TCP [::]:135 [::]:0 LISTENING
TCP [::]:443 [::]:0 LISTENING
TCP [::]:444 [::]:0 LISTENING
TCP [::]:445 [::]:0 LISTENING
TCP [::]:1688 [::]:0 LISTENING
TCP [::]:2382 [::]:0 LISTENING
TCP [::]:3389 [::]:0 LISTENING
TCP [::]:47001 [::]:0 LISTENING
TCP [::]:49152 [::]:0 LISTENING
TCP [::]:49153 [::]:0 LISTENING
TCP [::]:49154 [::]:0 LISTENING
TCP [::]:49155 [::]:0 LISTENING
TCP [::]:49172 [::]:0 LISTENING
TCP [::]:49227 [::]:0 LISTENING
TCP [::]:49604 [::]:0 LISTENING
TCP [::]:50350 [::]:0 LISTENING
TCP [::1]:49605 [::]:0 LISTENING
UDP 0.0.0.0:123 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:5355 *:*
UDP 127.0.0.1:51640 *:*
UDP 127.0.0.1:55849 *:*
UDP 127.0.0.1:58613 *:*
UDP 127.0.0.1:64672 *:*
UDP 127.0.0.1:64673 *:*
UDP 192.168.20.138:137 *:*
UDP 192.168.20.138:138 *:*
UDP [::]:123 *:*
UDP [::]:500 *:*
UDP [::]:1434 *:*
UDP [::]:4500 *:*
UDP [::]:5355 *:*
ASKER
I just modified the Domain, Private & Public profile in the firewall to ALLOW Incoming connections, thus disabling the firewall completely and I still get the error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
ASKER
Problem solved...
The SQL Installer does not set the default port and relies on Dynamic port communications. I set the port on the IP All option and all is good. You live and you learn.
Thanks,
-greg
The SQL Installer does not set the default port and relies on Dynamic port communications. I set the port on the IP All option and all is good. You live and you learn.
Thanks,
-greg
Take a look at the error log for the new SQL Server Instance and verify the port number used - 1433 may not be the correct port. If no Listening Ports are shown check Configuration Manager to ensure TCP/IP is enabled for the instance.
you'd better enable sql server browser service rather than manually setting port 1433.
accepted solution will work until you install another instance of SQL server, then you'll have to manually choose another port and specify it in connection string.
I prefer to let sql server browser choose ports dynamically. this way connection strings are independent from server configuration.
cheers - Lorenzo -
accepted solution will work until you install another instance of SQL server, then you'll have to manually choose another port and specify it in connection string.
I prefer to let sql server browser choose ports dynamically. this way connection strings are independent from server configuration.
cheers - Lorenzo -
ASKER