Solved

Backup Exec 9 and SQL SERVER AGENT

Posted on 2007-03-26
8
452 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
  • 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

809 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