July 18, 2008 at 2:48 pm
Hi,
We are facing a problem, which is, we cant take DB backup to our remote location server. eventhough we have local backup file, the remote backup file is used in our couple of reporting servers which is then later used by jobs in reporting server to burst the reports.. the backup is done as part of jobstep in one of our production servers. we are using Litespeed for Database backup. in the error, it says the error happened becuase of previous error. but i dont see any previous error...Below is the error we are getting:-
---------------BEGIN OF ERROR DESCRIPTION------------------------------------
Error: 50000, Severity: 18, State: 1
SQL LiteSpeed: There are currently no logon servers available to service the logon request.
LiteSpeed could not open the Backup file: (\\WGYUSRSQL\l$\RemoteBackups\PAS_from_PS2\pas_restore.bak). The previous system message is the reason for the failure.
---------------END OF ERROR DESCRIPTION------------------------------------
Any help would be really appreciated.
Thanks
Joseph
July 18, 2008 at 3:46 pm
Looks like it could be Domain Controller issues or Kerberos problems. Can you log onto the remote server from the SQL instance, maybe map a drive from the console?
August 6, 2009 at 12:07 am
I am also facing the similar problem on SQL Server Litespeed Log shipping job.
Error: 50000, Severity: 18, State: 1
LiteSpeed Version 4.7.0.00096 Copyright (C) 2004-2006, Quest Software Inc. All Rights Reserved. Quest Software, Inc. Registered Name: ABC Company [SQLSTATE 01000]
Msg 50005, Sev 19: Access is denied. LiteSpeed 2005 could not open the Backup file: (\\SERVER01\SQLBackup\LogShipping\DB_23451_644360B6-CA70-ASD-2BA4-2EF8287A4B_TLOG.trn). The previous system message is the reason for the failure. [SQLSTATE HY000]
Is anyone have any solution for it?
August 7, 2009 at 7:00 am
These (well at least the latter of the errors) looks like it could be a permissions problem. Does your SQL Server user have access to the file share you want to restore from?
James
--
James Moore
Red Gate Software Ltd
August 15, 2009 at 5:22 am
Change the logon service account of Litespeed to a account which has admin rights on the other server as well, like a domain account, and then try again.
possibly this should be resolved.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
August 4, 2010 at 9:21 am
hi how do you change the service account of litespeed?
September 3, 2010 at 7:58 pm
We ran into the same problem. We use Litespeed on more than one server. However, we were gettiing the same error you describe on only one of our servers.
Here was the problem: the server had been set up with the "out of the box" defaults for SQL 2005.
That meant that the SQL Server Service Account and the SQL Agent Service Accounts were local system accounts that had no privileges outside the local server.
It really doesn't matter what service account you use for Litespeed, because (I think) that account is only used for database access. The file system access is mediated by the SQL Service accounts.
Using SQL Configuration manager, change the SQL Server Service account and the SQL Agent Service account to a domain account which has access to the network share to which you want to backup your files.
Restart the SQL Services and you should be in business. Let us know if this works for you.
June 3, 2011 at 7:23 am
Still I am getting the same error after tuning the service accounts as suggested :(. Any fix for this issue is much appreciated !. Thanks.
Rgds
Arun
June 6, 2011 at 5:32 am
The Issue is because of the Previlage on Sharing the Backup file.
Share the folder which holds the Source database backup with the destination SQL server Service account.
It should work.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply