Solved

SBS 2011, Firewall, Sql Server

Posted on 2013-06-11
14
811 Views
Last Modified: 2013-06-18
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
Comment
Question by:PeterNairn
  • 9
  • 4
14 Comments
 
LVL 8

Expert Comment

by:Tymetwister
Comment Utility
Did you join the new PC to the domain?
0
 

Author Comment

by:PeterNairn
Comment Utility
Yes, user also added as administrator
0
 
LVL 21

Expert Comment

by:Haresh Nikumbh
Comment Utility
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
 

Author Comment

by:PeterNairn
Comment Utility
No, can't telnet. All firewalls disabled though !
0
 
LVL 21

Expert Comment

by:Haresh Nikumbh
Comment Utility
from both machine?
0
 

Author Comment

by:PeterNairn
Comment Utility
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
 
LVL 21

Expert Comment

by:Haresh Nikumbh
Comment Utility
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:PeterNairn
Comment Utility
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
 

Author Comment

by:PeterNairn
Comment Utility
Hi, I can't telnet but I ran a port scanner and port 1433 is open.
0
 
LVL 21

Expert Comment

by:Haresh Nikumbh
Comment Utility
so now new pc's are able to connect SQL ?
0
 

Author Comment

by:PeterNairn
Comment Utility
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
 

Author Comment

by:PeterNairn
Comment Utility
Just restarting the server after removing kaspersky using removal tool
0
 

Accepted Solution

by:
PeterNairn earned 0 total points
Comment Utility
SQL Browser had not been started !
0
 

Author Closing Comment

by:PeterNairn
Comment Utility
No one had checked whether this serviuce had been started , duh !
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
Resolve DNS query failed errors for Exchange
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now