SQL Server 2008 mirroring options are greyed out

Question

I am running SQL Server 2008 x64 Enterprise on 2 machines and I am trying to set up a database mirror. I have completed the backup and restore including log but when I go into properties - mirroring, all options other than "configure security" are greyed out.

The issue is that I need to use IP address as the principle but the name is showing instead.

I have tried to script it, but as the action fails there is nothing in the script

Any help would be appreciated. 

Answer 1

YES it is designed that way . In the CONFIGURE SECURITY WIZARD everything needs to be given as input like principal server , prin server sql service account , mirrored server , mirrored server sql service account and witness server properties and ENDPOINTS etc.

Mirroring always uses the server name and instances names for mirroring sessions for the primary and it can be an Ip address for mirrored server.
You might have to look at step by step mirroring configuration at these links
http://deepakrangarajan.blogspot.com/2007/07/how-to-configure-database-mirroring.html -- good one .
http://msdn.microsoft.com/en-us/library/ms188712.aspx

---

Thanks, Leks

Answer 2

Thanks for your response Leks, and I have managed to change the names, but still can't get them to mirror (the dreaded 1418 error). 

I have come to the conclusion that in order be able to do mirroring, the databases must be either 

1. On separate machines in a domain.

2. Located on the same machine. 

Thanks

Peter

Answer 3

Hi Peter,

For troubleshooting 1418 , have a look at the link
http://blog.sqlauthority.com/2007/04/22/sql-server-fix-error-1418-microsoft-sql-server-the-server-network-address-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-reissue-the-command/

http://blogs.technet.com/josebda/archive/2007/06/11/misleading-error-1418-message-in-sql-server-database-mirroring.aspx

http://geekswithblogs.net/SabotsShell/archive/2008/05/17/sql-server-2005-database-mirroring-setup-1418-error.aspx  .

And to add to your conclusion , the db mirroring can also be done between different domains using certificates .
Also Point 2 should be mentioned as , Different instances in the same machine .

---

Thanks, Leks