I'm trying to run a restore from a file. I select the file, enter my sa password and it gets the error -

Login Failed for user 'sa'
Server: BERTHA
SQL authentication
User name: sa

SQL error code: 18456

This is my first time using it. I know the password is right because I can log into SQL with it. I'm running SQL2005

NEVER MIND,

found that I had to run stored procs to reset the password, arghh, can't believe a gui doesn't give you that option.

exec sp_addextendedproc 'sqbsetlogin','xp_sqlbackup'
exec sqbsetlogin 'sa','mypassword'
gelbart
0

Add comment

Please sign in to leave a comment.