July 8, 2008 at 7:51 am
I have a SQL 2005 Server named instance and can be managed by a remote machine using SQL Server Management Studio. Normally, it connection (Servername\instance) appears as green circle.
However, after I have enabled Windows Firewall, at first, I can't connect remotely. After I have changed it to static port (1435) and made exceptions of sqlserv.exe and sqlbrowser.exe in WIndows Firewall and restart SQL Server Browser service. Now I can connect to the remote SQL 2005 Server.
It seems normal - I can expand all objects under the instace. I can check all the properties of databases and components. However, the connection appears as white circle instead of green circle. According to some posts, white circle means it does not know if the instance is running.
What configurations have I missed, esp. in Windows Firewall, since the issue only happens after enabling Windows Firewall.
SQL 2005 Configuration Manager settings:
Protocols for DB Instance: Shared Memory, TCP/IP,
Client Protocols: Shared Memory, Named Pipe, TCP/IP
Can anybody help?
Thanks for your help.
July 8, 2008 at 12:55 pm
I've had a similar problem, but it solves itself if I click on the instance to open its object tree. I did pretty much the same thing as you, but it solved the problem. Don't remember any extra steps.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply