MS SQL log shipping problem

wasabi3689
wasabi3689 used Ask the Experts™
on
I am using MS SQL 2008

I am configuring MS SQL 2008 log shipping method for one of the database

My primary backup is resided on my office PC, and my secondary log shipping server is resided in another location outside of my office's network.

Both primary and secondary servers have MS SQL server 2008 installed.

After I successfully set up backup  from primary server, I try to set up secondary server. I have the following trouble

I cannot connect to my secondary server by MS Management Studio. I tried Windows mode and SQL mode with user name and password. But it doesn't work?

Can someone help me with this
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Commented:
If it is in another network you should not be  able to connect to it. At least if you dont have a VPN or a Static IP for the secondary server.
Sudhanshupathak

Commented:
Are you able to ping and telnet on port 1433 of another server??which authentication method you are using for setitng up Logshipping??
wasabi3689

Author

Commented:
how to ping another server?

I am using mixed mode set up for logging shipping. I tried only MS SQL access, but it doesn't work
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Find out now!
Sudhanshupathak

Commented:
Do you have any connectivity between both server like Primary (office) to Secondary (Outside office)??
wasabi3689

Author

Commented:
No. There is no connectivity between two networks. But I can vpn to the primary network
Sudhanshupathak

Commented:
Hmmm...and what about after connecting through VPN you are able to connect to that Secondary DB Server?
wasabi3689

Author

Commented:
VPN, I mean from my secondary sever to primary server. There is no vpn from primary server to secondary server
Sudhanshupathak

Commented:
Are you able to ping and telnet from Secondary to Primary??

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial