SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Firewall Ports for Green Circle with White Arrow
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

swissivan
Starting Member

30 Posts

Posted - 04/25/2013 :  01:05:10  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 04/25/2013 :  01:13:44  Show Profile  Reply with Quote
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
Go to Top of Page

swissivan
Starting Member

30 Posts

Posted - 04/25/2013 :  01:26:54  Show Profile  Reply with Quote
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.

Edited by - swissivan on 04/25/2013 01:27:11
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/25/2013 :  01:48:58  Show Profile  Reply with Quote
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
Go to Top of Page

swissivan
Starting Member

30 Posts

Posted - 04/25/2013 :  01:50:55  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/25/2013 :  02:11:10  Show Profile  Reply with Quote
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
Go to Top of Page

swissivan
Starting Member

30 Posts

Posted - 04/25/2013 :  04:12:44  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/25/2013 :  04:19:34  Show Profile  Reply with Quote
whats the role to which your login is mapped in server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

swissivan
Starting Member

30 Posts

Posted - 04/25/2013 :  04:36:40  Show Profile  Reply with Quote
user is sa

user roles
public
and
sysadmin

thanks

Edited by - swissivan on 04/25/2013 04:37:27
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/25/2013 :  05:09:14  Show Profile  Reply with Quote
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
Go to Top of Page

swissivan
Starting Member

30 Posts

Posted - 04/25/2013 :  05:44:22  Show Profile  Reply with Quote
Sorry I am really new to database admin
How could I check is it a member of admin group using management studio?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.48 seconds. Powered By: Snitz Forums 2000