SQL Server Performance Forum – Threads Archive
Manage another SQL Server 2005I’m trying to manage another SQL Server 2005 instance in another machine. I’m doing this by connecting to another computer thru Computer Management. When I go the SQL Server 2005 Services, the right pane is showing There are no items to show in this view. How can I view the services? Another problem that I have is that I have to turn off the Windows Firewall in the other machine. What exceptions are needed? I have tried by adding the specific TCP used by the instance.
Did you try using Surface Area Configuration (SAC)…
You can manage remote computer services using SAC MohammedU.
Hi MohammedU, I have just tried SAC and it show the services status. However I still need to turn off the Windows Firewall. Do you know what programs or ports need to be excepted? I have already tried the TCP port used by the instance and won’t solve the problem.
Sorry! I missed his second question… MohammedU.
check whether this helps u not …http://madhuottapalam.blogspot.com/2006/12/connect-to-remote-sql-server.html Madhu
http://support.microsoft.com/kb/914277 fyi Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.