SQL Server Performance Forum – Threads Archive

Manage another SQL Server 2005

I’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.
Moderator
SQL-Server-Performance.com

---

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.

---

Referhttp://msdn2.microsoft.com/en-us/library/ms165724.aspx Madhu

---

Thanks Madhu…
Sorry! I missed his second question… MohammedU.
Moderator
SQL-Server-Performance.com

---

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
http://www.SQL-Server-Performance.Com
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.

---

]]>