Getting Access Denied error while trying to make a backup selections for SQL 2005 and 2008 to create a job
|Article:TECH68253|||||Created: 2009-01-26|||||Updated: 2012-09-16|||||Article URL http://www.symantec.com/docs/TECH68253|
Unable to make backup selections for SQL 2005 & 2008 to create a backup job, getting Access Denied error or Unable to query database message.
While expanding the SQL Server Icon in Backup Exec the following error occurs:
Issue would occur if the backup account does not have the required permission for the SQL 2005 or 2008 instance and databases.
2) Browse for the user being used to connect to and backup SQL from the domain.
# Click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
# Under SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER:
1. Double-click the protocol name TCP/IP and set the property ENABLED to Yes.
2. Double-click the protocol name Named Pipes and set the property ENABLED to Yes.
Article URL http://www.symantec.com/docs/TECH68253