Solved

Backup Exec 9 and SQL SERVER AGENT

Posted on 2007-03-26
8
455 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

688 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