SQL Server Performance

DB mirroring Setup

Discussion in 'SQL Server 2005 Database Mirroring' started by smounkhaty, Apr 4, 2006.

  1. smounkhaty New Member

    Hi Guru,

    Please help!!!

    SQL 2005 Standard/Windows 2003 R2
    Servers not in domain environment but they are in DMZ zone.
    SQLSERVICE runs on localsystem account
    Not default port

    This is a two dual core machine with hyper threading. We cloned this machine and put another server in our hot standby data center. Principal is the server in our main data center both mirror and witness are located on the same machine in our hot standby data center. Principal and mirror are running on standard and witness is running on sqlexpress version.

    Steps to configure for outbound connections on all three instances:

    In a master database, create a database master key
    In a master database, create an encrypted certificate for server instance
    Create endpoint for server instance using it#%92s certificate
    Backup certificate to a file and copy the file to the other server

    Steps to configure for inbound connections on all three instances:

    Create login for the other system
    Create user from this login
    Obtain certificate for mirroring endpoint of the other server instances
    Associate the certificate with the user created.
    Grant connect permission on the login for the mirroring endpoint

    However, when I tried to setup partner and mirror, the partner could not find the mirror. I was able to ping, telnet for communications between these two servers.

    Did I miss something? why not work?

    Thanks very much,

  2. simondm New Member

    Make sure the SQL Browser service is running on the machine you are trying to connect to. If it's not SQL will not know which instance you are trying to connect to and close the connection.


Share This Page