• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 873
  • Last Modified:

SBS 2011, Firewall, Sql Server

Hi, I have a new SBS 2011 standard server but seem to have firewall \ access issues. 5-6 Workstations can access a sql server without any problems but a new PC can't. I have reset the PC to factory defaults but it still can't access. I have run a port scanner and the only port it sees as open is port 137. The server has a few failed updates due to a power failure !

Help, Peter.
0
PeterNairn
Asked:
PeterNairn
  • 9
  • 4
1 Solution
 
TymetwisterCommented:
Did you join the new PC to the domain?
0
 
PeterNairnAuthor Commented:
Yes, user also added as administrator
0
 
Haresh NikumbhCommented:
can you telnet port 1433 to server?

telnet 1433 port from working machine to sbs server
and same with new pc

http://blogs.msdn.com/b/jorgepc/archive/2009/08/25/open-firewall-ports-for-sql-server-the-easy-way.aspx
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
PeterNairnAuthor Commented:
No, can't telnet. All firewalls disabled though !
0
 
Haresh NikumbhCommented:
from both machine?
0
 
PeterNairnAuthor Commented:
Hi, yes from both PCs, something on server must be blocking, had kaspersky installed , removed a few days ago, now running a kaspersky removal tool to ensure
0
 
Haresh NikumbhCommented:
If all machines are not able to access that means problem with server. but in your case few machines are working fine.. only newly added machines are not able to connect.

so you need to check it out new machine .. isn t?
0
 
PeterNairnAuthor Commented:
Yes, but connecting to Sql server works on old PCs but can't telnet to the server, weird. Also other problems with running some apps off the server which also point to blocked ports.
0
 
PeterNairnAuthor Commented:
Hi, I can't telnet but I ran a port scanner and port 1433 is open.
0
 
Haresh NikumbhCommented:
so now new pc's are able to connect SQL ?
0
 
PeterNairnAuthor Commented:
No, old PCs can, new ones cant. There is also a couple of apps on the Server that should connect to sql server but don't work on old or new !
0
 
PeterNairnAuthor Commented:
Just restarting the server after removing kaspersky using removal tool
0
 
PeterNairnAuthor Commented:
SQL Browser had not been started !
0
 
PeterNairnAuthor Commented:
No one had checked whether this serviuce had been started , duh !
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 9
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now