FullText Search Error 1075: The dependency service does not exist or has been marked for deletion

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Error: FullText Search Error 1075: The dependency service does not exist or has been marked for deletion Infrastructure: SQL server 2005 and onward Scenario: While I was working on Migration project for one of my prime customer from … Continue reading FullText Search Error 1075: The dependency service does not exist or has been marked for deletion

The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s subsystem failed to load [see the SQLAGENT.OUT file for details]; … Continue reading The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

Cannot open backup device. Operating system error 5(Access is denied.) while backing up\restoring SQL server Databases.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: Cannot open backup device. Operating system error 5(Access is denied.) Infrastructure: SQL server 2000 and onward Scenario: This is very famous  error which has been seen no of times … Continue reading Cannot open backup device. Operating system error 5(Access is denied.) while backing up\restoring SQL server Databases.

Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name Infrastructure: SQL server 2005 and onward Scenario: Here the scenario was, … Continue reading Only a member of the sysadmin server role can add a job for a different owner with @owner_login_name

No global profile is configured. Specify a profile name in the @profile_name parameter

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.  Note:  Best viewed in Internet Explorer 6 and above Error: No global profile is configured. Specify a profile name in the @profile_name parameter Infrastructure: SQL server 2005 and onward Scenario: Here the scenario was, client was trying … Continue reading No global profile is configured. Specify a profile name in the @profile_name parameter