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 2008 Forums
 High Availability (2008)
 Mirror setup - Unable to enter server addresses

Author  Topic 

Heinduplessis
Starting Member

23 Posts

Posted - 2011-02-23 : 13:46:22
Hi all

When setting up a mirror, on the pricipal server, I go to the DB properties / Mirroring. Just below Principal, Mirror and witness network address area there is a note "Use fully-qualified TCP addresses". SQL puts in the machine names, which I'm trying to change to the IP addresses, but the edit controls are greyed out. I'm unable to change it, as recommended by MSDN: http://msdn.microsoft.com/en-us/library/ms188712.aspx

I've followed all the other steps in preparation, I just can't get the two servers to connect because I'm unable to enter the address!

Any help apprecaited.

Thanks,
Hein

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-23 : 13:54:31
Try the T-SQL way to set it up and see what you get: http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Heinduplessis
Starting Member

23 Posts

Posted - 2011-02-23 : 14:21:32
quote:
Originally posted by tkizer

Try the T-SQL way to set it up and see what you get: http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Thank you will do.
Go to Top of Page
   

- Advertisement -