MS SQL Server Clients - RE: SQL error with Backup Exec 10d

Author

RE: SQL error with Backup Exec 10d

Jerry Hung

2006-10-25, 6:02 am

We are experiencing the same problem here
Backup Exec 10d worked with 1 SQL2000 server
When tried to connect to SQL2005 servers (agents installed on the sql
server), it says "A network connection to the server cannot be
established"

We had the SQL2005 installed before installing the Backup Exec SQL
Server agent, and our software has SP1 as well
SQL server allows remote connection too

Any other causes/guesses?

*** Sent via Developersdex http://www.droptable.com ***

Warren Brunk

2006-10-25, 6:02 am

Do you have the correct protocol enabled on the SQL 2005 instance?

I would open up the SQL Server 2005 Configuration Manager and check to see
if TCP/IP (or whatever protocol your backup exec is using) and make sure
they are enabled under --> SQL Server Network Configuration --> Protocols
for MSSQLServer

see if that might be an issue...

thanks,

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

"Jerry Hung" <jerryhung@hotmail.com> wrote in message
news:uqjKXWJ7GHA.4232@TK2MSFTNGP02.phx.gbl...
> We are experiencing the same problem here
> Backup Exec 10d worked with 1 SQL2000 server
> When tried to connect to SQL2005 servers (agents installed on the sql
> server), it says "A network connection to the server cannot be
> established"
>
> We had the SQL2005 installed before installing the Backup Exec SQL
> Server agent, and our software has SP1 as well
> SQL server allows remote connection too
>
> Any other causes/guesses?
>
>
>
> *** Sent via Developersdex http://www.droptable.com ***

Sponsored Links