SQL Agent didn't work after uninstall veritas backup

[Ramon_Jimenez]

Hello

I've a Window 2000 SP4 Box which had installed veritas backup exec, a
default SQL Server instance and a named SQL Server instance.

We have moved backup services into another box so we uninstall backup
software (which use an MSDE database) after that SQL Server Agent for the
default instance it's not working properly. Service starts and after a short
time stops by itself.

The errors shown are:

SQLServer Error: 14, Conexi�n no v�lida.

SQLServer Error: 14, ConnectionOpen (Invalid Instance()).

Can't connect to server '(local)'; SQLServerAgent couldn't start.

I've tried to start from the console with

sqlagent.exe -c -v
sqlagent.exe -c -v -i MSSQLSERVER

without results.

The agent of the named instance is working fine.
Which steps could I follow to bring this agent back?

[Amruta_Bhide]

Hello,
- Did you move Databse with the help of beutility?
- Did you move database in the defualt Instace of SQL Or in the named Instace?
- Do you mean you later Installed Backupexec on the machine where SQL is localy installed?

Thanks
Regards

[Ramon_Jimenez]

Hello,

I did not move any databases.

We have a machine with a 4 mm dat tape unit wich have veritas backup installed, and later we installed two more instances of SQL Server (one named and one not).

We bought a new tape unit and attach it to another machine so we uninstall backup exec from the old box and after that SQL Server Agent stop working.

Regards Ramon

[Ramon_Jimenez]

Sorry for the delay in closing the thread.

We finally solved the issue.

We had three SQL Server Instances,

one named, listening on standard SQL port
Backup Exec, listening on standard SQL port
a default instance, listening on a non standard SQL Server Port

When we uninstall Veritas Backup it seemed that SQL assigned default port to our default instance instead of the one we use.

We have changed SQL Server client connection properties to tell SQL Server Agent in which port must it listen.

Regards Ramon