Activity overview
Latest activity by Bill Wychor
I found out a coworker of mine had installed SQL Native Client for SQL Server 2005 on the server just prior to all the SQL backups failing. Prior to that only SQL Server 2000 and it's drivers were installed.
I uninstalled SQL Native Client and then successfuly installed SQL Backup Server Componets. Then I stopped and restarted the SQL Backup Agent service and now I can successfully complete the SQL backups. / comments
I found out a coworker of mine had installed SQL Native Client for SQL Server 2005 on the server just prior to all the SQL backups failing. Prior to that only SQL Server 2000 and it's drivers were...
I executed exec sqbsetlogin with the user id and the new password
the message returns (0 row(s) affected). I tried runing the SQBServerSetup.exe and got the message "Failed to check that the SQL Backup extended stored procedures were installed."
and a second time with EXEC sqbsetlogin '',''
the message returns (0 row(s) affected) again and again "Failed to check that the SQL Backup extended stored procedures were installed."
I ran SQL Profiler monitoring the sql and saw Reads 0 Writes 0 for the exec sqbsetlogin .
While connected as a domain admin using the domain admin user and password I uninstall the componets via add remove programs the event viewer shows uninstall successful. When I then reinstall I get the message: "Failed to check that the SQL Backup extended stored procedures were installed."
I verified that the SQL Backup Agent service was using the same domain admin user when I tried this.
I tried with creating a new SSA user id with sysadmin and still have the same errors.
Where do I find what the "sqbsetlogin" login id that is stored somewhere that it is expecting to authenticate against?
I appreciate your help / comments
I executed exec sqbsetlogin with the user id and the new password
the message returns (0 row(s) affected). I tried runing the SQBServerSetup.exe and got the message "Failed to check that the SQL ...
Thanks for the reply.
When I tried 'SQL Server Authentication' it did not pass the test. The server is steup for mixed mode and I tried 3 different user ids all of which work when connecting to the server with via Enterprise Manager.
When I used Local System account in the setup I get the following message.
Unspecified error: This installation may not be able to install the SQl Backup extended stored procedures. Use another login. / comments
Thanks for the reply.
When I tried 'SQL Server Authentication' it did not pass the test. The server is steup for mixed mode and I tried 3 different user ids all of which work when connecting to t...
SQL Backup exit code 586
I have a server (XXXXXXXX) we have been running SQL Backup 5 on for months without any problems. We are now having failures returning the following:
Windows authentification
Failed to connect to S...