MODULE SQL

[peppe71]

I have server Unix with Legato 6.0.3.
In the client's configuration i've set MSSQL: in the box "save set" and nsrsqlsv in "backup command"
I have set userid and password with server's administrator privilege, but the backup fails with this error:
* db-sql:MSSQL: 2 retries attempted
* db-sql:MSSQL: Cannot authenticate user: unknown error 1326 (0x52e)
* db-sql:MSSQL: 03/26/02 16:03:17 nsrexec: Cannot authenticate user: unknown error 1326 (0x52e)
* db-sql:MSSQL: Permission denied

 

[ulsj]

Hi!

Check this
Does the user you have printed in the remot tab permission to the SQL db? If you are using sql autentication i think you have to create a user in sql and then use this on the remote tab.

 

[gerudman]

You could also check the Legato Tech Dialog on their website for for info on your problem.

http://www.legato.com

cheers
George

 

[mkkeane]

You could also make sure that the user account that starts the NetWorker services on the SQL client has SQL DB rites. If not, then give it permission and then this problem will go away.

Matthew