ARCServe v9.0 SQL Agent Question
Posted on 2004-03-31
I have two Win2003 servers with SQL 2000 Enterprise SP3. The ARCServe Manager is installed on another Windows2003 server. The Manager shows the database on one of the servers (Server A)but not the other (Server B). The configuration of the two databases is very similar. I can see the file system for both servers but only one of the databases. I have checked the ODBC connection on both servers and these connect ok to the databases. Build of the ARCServe Manager and agents is V9.0 Build 2010. Authentication type for SQL databases is mixed. ARCServe SQL Agents are configured to use NT authentication. I don't understand why I can see the database for Server A but not for Server B when these databases are very similar? Any help will be most appreciated.
I have verified the following:
- Restart the Backup Agent RPC Server
- Install the backup agent
- Re-install the backup agent
I have also ckecked that the relevant registry key exists for the agents.
Do SQL Named Pipes need to be an enabled protocol on SQL Server even if TCP is the protocol defined for the backup?