February 23, 2012 at 6:37 am
Hi,
I wish to know that what is port numbers available in logshipping...
can any one give me reply
February 23, 2012 at 6:53 am
the only thing that happens is outside of the local scope is the file copy so you should only need file share ports opening, typically 445 would also open up the SQL ports just incase eg 1433 etc
February 23, 2012 at 10:41 pm
How can we come to know the file share is opened, and how to check the port number is assigned for that configuration and all.
Please let me know...
February 24, 2012 at 1:35 am
disable windows firewall on your servers
if your on the same LAN for Pri and Sec servers and there is no firewall inbetween then its open
if there is a firewall speak to your network administrators who can add the right rules in
the link in the reply above tells you which ports are used for SMB/CIFS
February 25, 2012 at 2:06 am
Is there any query to find that port number assigned to partners...
February 27, 2012 at 1:05 am
what port are you trying to find out? the port which SQL is running on? you can use the SQL Server Configuration Manager to find that out, if its a default instance it will be 1433 unless you changed it
February 27, 2012 at 3:39 am
I want to know for logshipping port number has assigned to that partner. for this is there any query to find ?
Plz any one help...
February 27, 2012 at 3:41 am
they dont have any special ports in logshipping, they use file copy ports and whatever port SQL is running on, usually 1433 unless you have changed it or installed a named instance
mirroring on the other hand does use ports which are user defined
February 28, 2012 at 2:07 am
anthony.green (2/23/2012)
the only thing that happens is outside of the local scope is the file copy so you should only need file share ports opening, typically 445 would also open up the SQL ports just incase eg 1433 etc
In this you have mentioned port number 445, May i know about this port number please.....
February 28, 2012 at 2:28 am
the information on that is in the wiki link.
port 445 is the port used for file copy's so that both nodes can copy TRN files
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply