Firewall Ports for Green Circle with White Arrow

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.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

Firewall Ports for Green Circle with White Arrow

Author

Topic

swissivan
Starting Member

30 Posts

Posted - 2013-04-25 : 01:05:10

It show a white circle icon on database instead of green circle with white arrow.

I tried to turn off the firewall, the green circle appears.

then I turn off and allow exceptions on ports
TCP
135,433,1433,1434,2382,2383,4022
UDP
500,1434,4500

still not working, any one knows which ports I am missing? thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-25 : 01:13:44

can you give us some context? are you trying to connect a remote server using client tool? are both server and client machine in same domain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

swissivan
Starting Member

30 Posts

Posted - 2013-04-25 : 01:26:54

quote:
Originally posted by visakh16

can you give us some context? are you trying to connect a remote server using client tool? are both server and client machine in same domain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Thanks.

yes, want to connect a remote server in the same internal network.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-25 : 01:48:58

if its same domain and inside firewall you dont to do any port related changes. didnt understand what issue you're facing. what happens when to connect to server through SSMS?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

swissivan
Starting Member

30 Posts

Posted - 2013-04-25 : 01:50:55

quote:
Originally posted by visakh16

if its same domain and inside firewall you dont to do any port related changes. didnt understand what issue you're facing. what happens when to connect to server through SSMS?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Thanks for your help.
There is a window firewall setup on the sql server.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-25 : 02:11:10

ok..but you've added default port (1433) to exceptions right?

see

http://msdn.microsoft.com/en-us/library/ms175043.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

swissivan
Starting Member

30 Posts

Posted - 2013-04-25 : 04:12:44

Yes, I have added default port 1433 and so many ports.
Also added exception to Sqlservr.exe still not help.

I can connect, create tables and data, but just cannot star, stop, pause, resume and restart the server by right click the server name in management studio.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-25 : 04:19:34

whats the role to which your login is mapped in server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

swissivan
Starting Member

30 Posts

Posted - 2013-04-25 : 04:36:40

user is sa

user roles
public
and
sysadmin

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-25 : 05:09:14

quote:
Originally posted by swissivan

user is sa

user roles
public
and
sysadmin

thanks

ok...but i hope your login wont be a member of admin group of the server i guess.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

swissivan
Starting Member

30 Posts

Posted - 2013-04-25 : 05:44:22

Sorry I am really new to database admin
How could I check is it a member of admin group using management studio?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources