Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Mirroring No DNS on machine

Author  Topic 

netsurfer
Starting Member

5 Posts

Posted - 2008-11-21 : 09:24:09
Hi all,
I'm trying to implement mirroring with certificates with 3 machines,
all in the same network.

Machine A -> Main (SQL SERVER STANDARD)
Machine B -> Mirror (SQL SERVER STANDARD)
Machine C -> Witness (SQL SERVER EXPRESS)

All sql server instances are running under a local account with same name and password (SQLMIRROR account)

My problem is when i try to do this step
quote:
alter database good set partner = 'TCP://host.domain';

I get an error that the TCP address can't be reached.

The problem is i don't have a DNS for the machine and i don't know how to discover the TCP address :/
When i run on cmd the "ipconfig /all" the result is
quote:

Host Name ...................:ServerMirror
Primary Dns Suffix ..........:
IP Routing Enabled...........:NO
WINS Proxy Enabled ..........:NO


It's possible to configure mirroring like this?
I'm stuck here Can anybody help me.

Thanks in Advance

EMendes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-21 : 10:30:32
See this :
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=113513
Also SQl Server should be running in domain account.
Go to Top of Page
   

- Advertisement -