Access Denied error occurs when testing resource credentials for SQL databases

Article:TECH77342  |  Created: 2009-01-19  |  Updated: 2013-04-17  |  Article URL http://www.symantec.com/docs/TECH77342
Article Type
Technical Solution

Product(s)

Issue



Access Denied error occurs when testing resource credentials for SQL databases.


Error



0xa000848c - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again. If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource. 

 

  • If the System Logon Account is selected, the resource credentials test error out with access denied and the job fails with the error listed above.
 
  • If the SQL Administrator; i.e. SA is selected as the username, the resource credentials test is successful but the job hangs at a certain byte count.
 
  • The following error occurs after logging into the SQL 2005 Management Studio:

__________________________________________________________________________________________

 
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections (provider:Named Pipes Provider,error:40-Could not open connection to SQL Server).
 
___________________________________________________________________________________________
 

 


Cause




This failure may be caused by the fact that under the default settings SQL Server does not allow remote connections (provider:Named Pipes Provider,error:40-Could not open connection to SQL Server).
 


Solution




1. Open SQL Server Configuration Manager.  Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols, 'TCP/IP' and 'Named Pipes'.

2. Restart the SQL server service and retry the backup job.


 

Supplemental Materials

SourceError Code
Value0xe000848c
Description

Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again. If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource. 



Legacy ID



337848


Article URL http://www.symantec.com/docs/TECH77342


Terms of use for this information are found in Legal Notices