| 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 |
|
|
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? |
|
|
|
|
Firewall Ports for Green Circle with White Arrow