Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase and network

2 posts in Windows NT Last posting was on 2001-03-16 16:07:30.0Z
Voronkov Nick Posted on 2001-03-16 07:56:03.0Z
From: "Voronkov Nick" <Nikolay.Voronkov@flc-bookclub.com>
Subject: Sybase and network
Date: Fri, 16 Mar 2001 09:56:03 +0200
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2417.2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <IJD6gEfrAHA.53@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: bravo.flc-bookclub.com 193.41.49.154
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1082
Article PK: 1087684

Hi all !

Do anybody tell me where I can see information about tuning network
environment.

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
too.

Nick.


Jim Egan Posted on 2001-03-16 16:07:30.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Sybase and network
Date: Fri, 16 Mar 2001 09:07:30 -0700
Message-ID: <MPG.151be830c90a17a98b1be@forums.sybase.com>
References: <IJD6gEfrAHA.53@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
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]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com