?
Solved

SBS 2011, Firewall, Sql Server

Posted on 2013-06-11
14
Medium Priority
?
862 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 4
14 Comments
 
LVL 8

Expert Comment

by:Tymetwister
ID: 39238054
Did you join the new PC to the domain?
0
 

Author Comment

by:PeterNairn
ID: 39238064
Yes, user also added as administrator
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39238080
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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

Author Comment

by:PeterNairn
ID: 39238097
No, can't telnet. All firewalls disabled though !
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39238282
from both machine?
0
 

Author Comment

by:PeterNairn
ID: 39238384
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 22

Expert Comment

by:Haresh Nikumbh
ID: 39238420
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
 

Author Comment

by:PeterNairn
ID: 39238427
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
ID: 39238468
Hi, I can't telnet but I ran a port scanner and port 1433 is open.
0
 
LVL 22

Expert Comment

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

Author Comment

by:PeterNairn
ID: 39238514
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
ID: 39238519
Just restarting the server after removing kaspersky using removal tool
0
 

Accepted Solution

by:
PeterNairn earned 0 total points
ID: 39245942
SQL Browser had not been started !
0
 

Author Closing Comment

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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Suggested Courses

771 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