SQL Server Performance

Problem with SQL 2005 Mirror

Discussion in 'SQL Server 2005 Database Mirroring' started by blandy, Jan 11, 2007.

  1. blandy New Member

    Hi all,

    I'm having a problem setting up a SQL 2005 Mirror across 2 servers. I'm using a manual failover at the moment so I don't use a witness server. Server Details:

    Both have Win Server 2003 + SP1
    Both have SQL 2005 running but with different version:
    - One is 9.0.2047 (SP1)
    - One is 9.0.3033 (SP2)

    I've tested both server connecting via port 5022 with telnet and they connect fine, (should do as well as they are on the same gigabit switch!).

    Using SQL sa user Auth and I keep getting the following when trying to start it:

    The Server network address "TCP://192.168.1.44:5022" can not be reached or does not exist. Check the network address name as that the ports for the local and remote endpoints are operational.

    Any ideas?

    Ta.
  2. satya Moderator

    Make sure the defined port is enabled on other server and try with client alias defintion

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. blandy New Member

    I don't know what "client alias definition" is? I tested the port 5022 on both servers and they connect to each other. Also check port via cmd:

    netstat -ab

    and it showed SQL Server process with 5022 TCP open.
  4. MohammedU New Member

    I think Satya wants you to create an Alias in SQL SERVER CONFIGURATION MANAGER/SQL Client Configuration



    Mohammed U.
  5. blandy New Member

    I'm connecting the servers via the "sa" user which should be ok as it does have full database access.
  6. blandy New Member

    OK, I think I know what the problem is now, it's the "Service Accounts" as they arn't configured. Turns out that the service account on each SQL instance didn't have CONNECT permissions to the endpoint on the other instance. I haven't used the Service Accounts section so what do I configure there?

    Let's say Principal Server is "SATURN" and Mirror is "MARS". I presume I have to setup an NT account on both servers like "MirrorService" which is configured in SQL 2005 security with CONNECT permissions.

    I'm only guessing here but this is the problem. Got this from MS MSDN forums, ref:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083613&SiteID=1

    Look at the last post.
  7. blandy New Member

    The problem with the above is the fact that the 2 SQL 2005 Servers I have arn't on a domain so how can I setup the "Service Accounts" so they can connect to each other?
  8. satya Moderator

    Create an account with same name and password then try to connect each other from one of the server.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  9. Akthar New Member

  10. blandy New Member

    Hi Akthar,

    As I said, the 2 servers are not on a domain so they can't connect to each other. I've come the conclusion that it's not going to work unless they are on a domain so I'll have 2 configure that when possible.

    Thanks anyway.
  11. satya Moderator

    If the domains are TRUSTED to each other then with the WINS and Client alias they can be connected.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page