MSsql resource and System state not listed in selection

[Jan_Vlasak]

Hi,
my problem is following:
- OS NT5.2 + SP1 with MSsql2000 + SP4 under user acount
- Veritas 9.1 rev. 4691 SP3

This server is behind firewall. Ports from 10.000 to 10.050 are
allowed between media server and remote agent. Ports are
configured in dynamic port ranges...

Iam able to connect to remote server, but I see only the
fysical disk (c,d,e,f,etc.)...but I cannot see SQL resource nor
System state.

thx a lot for help
Jan

[Ricardo_Pistari]

sorry for this dumb question but... do you have sql agent installed at be server?

[Jan_Vlasak]

Hi,
on the remote server the RemoteAgent is installed. Is running, is listening on port 10.000 and I can conntact him from media server throw firewall.

[Ricardo_Pistari]

Did you enter serial numbers for sql agent at media server?
Are you able to see other sql's not behind firewall?

[Jan_Vlasak]

Yes...exactly. Its strange for me, because it was working before I puted the server behind firewall :(

I read documentation about which ports need to be opened. I opened them...on firewall, on server.

[Ricardo_Pistari]

Check this articles:
----------------------------------------------------------------------------
System State and the Utility Partition do not appear in Selections for a remote computer on the other side of a firewall.

http://seer.support.veritas.com/docs/258679.htm
----------------------------------------------------------------------------
275484: After installing SP1 for Windows 2003, 'Shadow Copy Components' no longer show up under 'User Defined Selections'

http://support.veritas.com/docs/275484
----------------------------------------------------------------------------
An error occurs while attempting to browse the databases of a SQL server which is beyond a firewall though the drives for that server are visible.

http://seer.support.veritas.com/docs/273169.htm

[Jan_Vlasak]

Oh, great, thx a lot Ricardo,
issue around "Restrict Anonymous" helped me and now
I can see "system state" resource. Good.

But I still cannot see MSsql resource. I opened all port on
firewall betwenn Media server and remote agent, without
success ;-(

Maybe the problem is around access privileges...SQL is running
under common NT user account, remote agent is running under
local system, and I am using credentials of administrator when
connecting to remote agent.

I tried to run remote agent under administrator`s account. No success.

[Jan_Vlasak]

ITS ok ;)

I reinstalled remote agent and everyting seems to be perfect...THX a lot again Ricardo.

Jan