Solved

Backup Exec 9 and SQL SERVER AGENT

Posted on 2007-03-26
8
450 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
 
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
New! My Passport Wireless Pro Wi-Fi Mobile Storage

Portable wireless storage to offload, edit, and stream anywhere.

High-capacity, wireless mobile storage designed to accompany professional photographers and videographers in the field to easily offload, edit and stream captured photos and high-definition videos.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now