I have very little knowledge of SQL. Running 2005 with latest SP. The backups are failing for abut a week now and I have to restart the services for one database every morning for the user to connect to his program. I see two issues but have no idea how to correct them without causing more damage. T-SQL statement from the autoarchive job is as follows:

I also saw an error that indicated "ApplicationSettings" from the T-SQL statement was an unknown variable (or something like that) but I cannot remember where I saw that.

I uninstalled an unused program last week called "ProSign" but had no idea it was tied to this instanct of SQL for another program. (or that it tied to SQL at all) The T-SQL statement refers to a user account that this program used "ProSignAdmin"

This was set up by a consultant years ago and I haven't really touched it since.

Is this too complicated for a post? Do I need to give up and hire someone? lol

4 Replies

Hmm, could you post some more details about the ProSign application you uninstalled? You could try re-creating the ProSignAdmin account (possible that this is an admin account needed for the ProSign software, and it was re-used for the backup?)

ProSign was a document handling system that was truly unrelated to the accounts payable system above. We hadn't used it in years and I did not delete any user accounts. In fact, I do no see any user account called "ProSignAdmin" I made an assumption but only found one called "ProSign". I'm not sure how they got intertwined or why. Truly weird.

Not so weird really. Many applications that are tied to SQL will create their own local or domain accounts for the software. When you uninstall the software, it might also delete the user accounts.

I would look in the services applet and see if any of your SQL services are tied to any accounts you don't know. You might need to create a new SQL-service account and use that to launch those services.

"If you use full-text searching, you must grant the NT Authority\System sysadmin rights to SQL Server if the Builtin/Administrators role is removed"

After reading that I'm reminded of a SQL issue I had with my backup software. Until the service account for the backup software was given 'sysadmin' rights within the DB server software itself, things didn't work for me.