Solved

How do I backup MS SQL Server via backup exec 11d?

Posted on 2010-11-18
4
741 Views
Last Modified: 2012-05-10
Hi,

When I try to add all the resources to backup one of my windows server 2008, Microsoft SQL Server "SQLSERVER" cannot be added and following error message appears " An error was encountrered while attempting to browse the contents of MS SQL Server "SQLSERVER". A network connection to the server could not be established."

I have made sure SQL Server Agent service is running on the remote server.

Help is greatly appreciated.

Regards
0
Comment
Question by:callis610
4 Comments
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 34166383
Does your backup exec sql login have adequate credentials to backup the database.  If not , you need to declare a login and give it the backup operator credentials.
0
 
LVL 4

Accepted Solution

by:
torque_200bc earned 400 total points
ID: 34166410
(1) Check to make sure your SQL Server credentials are correct
(2) Make sure the agent is installed on the target server
(3) Update your BE server using liveupdate
(4) Update your agent(s) using the bulk update tool or manually
(5) SQL permissions for the account you'e using to connect need to have the appropriate permissions (backup operator should be adequate?)

0
 
LVL 3

Assisted Solution

by:konathala
konathala earned 100 total points
ID: 34167344
go to sqlserver configuration manager and check whether tcpip and named pipes are enabled. And change the request timeout to a higher value.
0
 

Author Comment

by:callis610
ID: 36522867
Original post and answer did not apparently address instances of SQL Server Express. However the comments about 11d not supporting 2008 R2 are absolutely correct.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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…
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…

910 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

22 Experts available now in Live!

Get 1:1 Help Now