Hi all !
Do anybody tell me where I can see information about tuning network
We have ASE 11.9.2, two network cards in the server (Window NT, sercice
pack 6) and one virtual driver.
The cards : Intell PRO/100 Intelligent Server Adapter
Type of virtual adapter : Intell Adaptive Load Balancing Team.
Our trouble : XP_Server does not working if tasks start on the server.
For example I type in SQL Advantage on the server the next :
exec xp_cmdshell 'net send user_name Hello !!!' or
exec xp_cmdshell 'dir c:'
After this the session hangs. But I can type these command with client
computers. ASE and XP_Server services start with SYSTEM account. I think it
is bound with permissions of account SYSTEM for network. I find nothing in
the documentation. Our network administrator says it is possible to destroy
the virtual adapter, but then network cards will have different IP
addresses. It is not proper for us.
This future (start XP_Server on the server side) is very important for us
Subject: Sybase and network
Date: Fri, 16 Mar 2001 09:56:03 +0200
X-Newsreader: Microsoft Outlook Express 5.00.2417.2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: bravo.flc-bookclub.com 188.8.131.52
Xref: forums-1-dub sybase.public.sqlserver.nt:1082
Article PK: 1087684
Hi all !
Subject: Re: Sybase and network
Date: Fri, 16 Mar 2001 09:07:30 -0700
X-Newsreader: MicroPlanet Gravity v2.30
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 184.108.40.206
Xref: forums-1-dub sybase.public.sqlserver.nt:1079
Article PK: 1087681
I had a client last year with a very similar setup. It might be the same NIC's even.
XP_Server does work in that environment. I really freaked out their DBA group when I
started telling them about the O/S configuration information that I was able to get even
though I didn't have NT security rights to that machine.
You may need to configure the system to run xp_cmdshell under the system account (Or
whatever account ASE is running under) by using the following command:
sp_configure "xp_cmdshell context", 0
If you use 1 instead of 0 then your ASE login name must have an identically named account
on NT with rights. If you are going to leave it 0 then make sure that the right to run
xp_cmdshell is restricted. For more information see "xp_cmdshell context" in chapter 17 of
the System Administration Guide.
Jim Egan [TeamSybase]
Sybase Professional Services
Get your free subscription to PowerTimes at http://www.powertimes.com