Post reply

SQL SERVER 2005 SECURITY LOGIN PROBLEMS

  • December 13, 2007 at 4:39 am

    #759757

    Hi,

    May be they are already used or blocked (Make sure all your firewall and router ports are open for the port numbers http://database.ittoolbox.com/groups/technical-functional/sql-server-l/need-help-in-database-mirroring-1648286#).

    From

    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx%5B/url%5D

    Each database endpoint must specify a unique port on the server.

    When working with SQL Server instances on separate machines, these port numbers can all be the same and the Configure Database Mirroring Security Wizard will automatically suggest port 5022 as the port.

    If any of the SQL Server instances are on the same machine, each instance must have a distinct port and the port numbers must be unique.

  • December 15, 2007 at 2:03 am

    #760506

    Hi, Mr.Ahmed how are you doing? this past 2 days was week end and i was out outside. any how.

    now the problem is as you said due to the instances in the same computer, the port numbers should be different. so, i have to open the port numbers from the Router and also disable the firewall.

    what i did is i have disabled the firewall and opened the port numbers

    * mice server

    *Htuil server

    *SCPI IELNET AND thier protocol is both UDP & TCP and port numbers are 5022,5023 and 5024. and then i tried to configure it but it has the same problem the end points for the Mirror and witness server are giving errors.

    thanks

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply