I have 3 servers ,I create a domain controller on [DC] server. I joned 2 servers [Node11] and [Node2] with [DC] ,I used the same user [mirrusr] that is member in [Domain User]and [Domain Admins] to connect these 2 servers to the zone metamanager.local. on [DC]
I installed SQL Server 2005 on [Node11] and [Node2] with domain user account I Enabled the local and remote connections options and run the SQL SQLBrowser service.
from [Node1] server If I go to [Browse For Server] Page and click on [Network Service]..the page return me local database engine...How Can I see the database Engine from [Node2] on [Node1]... Please Pleae any idea any hint...
On either of the nodes when you open SSMS and chose to connect to server, you can specify the name of the server to connect to, either node1 or node2. You do not have to rely on [browse for server]. This is usually never a good idea if you have many servers in your domain as it can 1) take some time to refresh, 2) is not always all exclusive.
answered Nov 10 '12 at 02:42 PM