Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error while logshipping

Status
Not open for further replies.

nowayout

Programmer
Joined
Feb 25, 2003
Messages
364
Location
US
Hi there,

I am testing logshipping and i am getting this error while it it trying to restore database from back up file on third step.

7416 16 Access to the remote server is denied because no login-mapping exists.
what i should do?

Thank you.
 
i got that solved now but i am getting error very last step whihc is exec sp_dboption to single user

Usage: sp_dboption [dbname [,optname [,'true' | 'false']]] [SQLSTATE 42000] (Error 15241). The step failed.

what should it be done here..

thanks a lot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top