Backups are failing after change

• ramana3327

  SSCoach

  Points: 19700

  More actions

  January 27, 2016 at 9:32 am

  #149149

  Hi,

  We are using SQL Server 2005. SQL Server is running under the service account.

  We tried to upgrade to the SQL 2008r2 but we didn't install the service pack2 for the existing sql 2005. When I use the upgrade wizard it upgraded the shared features. After that from control panel, I removed the SQL 2008r2.

  I restarted the SQL Server but it didn't came online. When I tried to start from services it throw-ed the error access is denied.

  We don't know the password for the service account so I changed the SQL Service as Local System in the log on tab.

  We used to run the maintenance plans for the backups to the network path.

  After the above change happens, the backups are failing with the error msg

  failed with the following error: "xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  When I tried to run the backup manually from SSMS, I got the error Operating system error 5(Access is denied.).

  I can't change the security on shared network path where the backups has to go

  The job owner is sa and sql agent is still running under service account only sql server service account is changed.

  Any idea?