Solved

Backup Exec 9 and SQL SERVER AGENT

Posted on 2007-03-26
8
451 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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 installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

810 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