Hello Team,

I have setup SQL DB full backup, diff, as well log backup separately when I am going into log it is showing error 1900 in the event log and on client system it is throwing below error.

ACO5426E The SQL log on does not have the Sysadmin role: CSqlApi::LogonServer:7119:1904 Server:IsSysadmin:false

I know this is a permission issue, just to update when I am running backup from TDP GUI backup is happening, from script it is working, in the foreground it is working it just that when that runs in the background it is failing with error code 1900 and on sql server with above log , my user name is xabcd that has a system admin role on sql, schedule service i have installed from this user only.

Please advise what can be check further.

Thanks

Prem

Hi Prem,

Standard when you install a service with the TDP or dsmcutil, that service is installed with user 'Local System'.
Hence the schedule is running as Lokal System and that user has no SQL SysAdmin role.
Changing the login user in the service (Cad, schedule and agent) to your user xabcd will do the job.
Tip: When user xabcd must change his password every period, create another user, give it Sysadmin role in SQL and never change his password.

Regards,

Frank
 
In Reply to Prem Singh:

Hello Team,

I have setup SQL DB full backup, diff, as well log backup separately when I am going into log it is showing error 1900 in the event log and on client system it is throwing below error.

ACO5426E The SQL log on does not have the Sysadmin role: CSqlApi::LogonServer:7119:1904 Server:IsSysadmin:false

I know this is a permission issue, just to update when I am running backup from TDP GUI backup is happening, from script it is working, in the foreground it is working it just that when that runs in the background it is failing with error code 1900 and on sql server with above log , my user name is xabcd that has a system admin role on sql, schedule service i have installed from this user only.

Please advise what can be check further.

 

Thanks

Prem

Hello Frank,

Thank you for your knowledge sharing, I have multiple SQL Server where on tdp sqlauthetication is local user called backupuser which is created on SQL only not on local system and service is running as local system only in the script i have mention sqlautjetication=sqluser and put the userid and password and backup is working with no issue, but on this server i am using domain user and sqlauthetication is integrated and that xabcd user has sysadmin role .

Thanks

Prem

Hi Prem,

To be clear for me. On the system where the SQL backups fails with the rc 1900, how do you start the backups? I suspect starting the backup mannually on the (tdp) commandline or tdp Gui will work presuming you are logged in as xabcd. And the backup fails when you start it as a schedule? Is that the situation? You can put in the sqluser and password in the script but that is not wanted. All I say is make sure that the backup script is running as a user know to SQL when you use sqlauthentication=Integrated (=default). So if you fire off the backup script with a service, that service must be running as xabcd user.

Regards Frank

Thanks Frank for continuous Knowledge sharing I have changed the settings as below now I can see backup is running as a schedule as well what is your take on this. I have a user called backupuser in the sqlserver and it is not set on windows authentication and on tdp I have put the same backupuser in the authetication method. service is running as a local system only as of now, but backup is working.

Thanks

Prem

No problem.
Glad the backup is running now :)

Regards Frank