Solved

Backup Exec 9 and SQL SERVER AGENT

Posted on 2007-03-26
8
454 Views
Last Modified: 2013-12-01
Hi all,
I am currently trying to PUSH INSTALL a SQL AGENT for BACKUP EXEC 9.  However, whenever I try to install the agent, I get the following error:
attempting to connect to server failed with the following error: the account name and/or password supplied is not valid.  Please re-enter the login information and try again.

Also, I notice there aren't any default shares in 'shared folders\shares' area, such as ADMIN$, or IPC$.
My DBA installed SQL, but has no clue.  Can someone please help me ASAP.
0
Comment
Question by:jsctechy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 10

Expert Comment

by:TAB8
ID: 18796080
The account that runs backup exec agent needs to have access to the sql server ..  add the account to the within sql and give it the appropriate rights  
0
 
LVL 1

Author Comment

by:jsctechy
ID: 18799930
This account is 'administrator'.  It has access to that SQL Server.  
0
 
LVL 10

Expert Comment

by:TAB8
ID: 18806687
It may require a SQL authenticated account rather than a windows account ..  possibly
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:jsctechy
ID: 18810246
What is a SQL authenticated account?  Is there a manager where you'd set that up?
0
 
LVL 1

Author Comment

by:jsctechy
ID: 18810270
Hey again,
I've checked my SQL server, I cannot even share a folder.  There is no 'sharing' tab on any properties page for any folder....
Is this common for SQL server to set parameters like those?
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 18821129
You shouldnt have to share out folders on the server ..   The BACKUP EXEC SQL Agent should back up the databse not the flat file ..   A SQL authenticated account is an account you create within SQL Server .. your dba shoudl be able to create you one .. sometimes Apps need a SQL authenticated account NOT a windows  authenticated account to connect ....
0
 
LVL 1

Author Comment

by:jsctechy
ID: 18836235
Tab8,
Thanks, I will let him know.  He has told me that Windows Authentication is enabled.  I will have him try it ASAP (he's on vacation).  Hopefully this will work.
0
 
LVL 1

Author Comment

by:jsctechy
ID: 18926730
Hi, seems to be okay now:)  Had the DBA add the account.
Thanks
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question