🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #10265

Re: SQL Server Remote Administration

#10265
From: Steve Midgley
Date: Mon, 23 Mar 1998 00:00
49 lines
2199 bytes
I do this also, and I have found that I can also specify the hosts
Internet name (e.g. sql.company.com), if NT networking is setup for DNS
name resolution.

I only have a short hop to the server I administer. I don't know how
well this system will work all the way to India (i.e. can you crash
anything with lots of dropped packets??)

Let us know how you make out! Good luck,

Steve Midgley

Alexander Kalinin wrote:

> I've been adminsitering 4 SQL Servers over Internet for a long time
> and it
> seems to be exactly the same as in the intranet. The main thing to do
> is
> setting your default Net-library to TCP/IP Sockets (dmssocn.dll, and
> of
> course you must be sure that this prot. is installed on the server
> sode).
> Then you register SQL Server in Enterp. Manager by its IP address
> (it's to
> avoid various name resolution problems) and administer in usual way.
>
> Hope this is of help,
> Alex Kalinin.
>
> pghosh@ascsol.com wrote in article <6et6ea$da$1@nnrp1.dejanews.com>...
>
> > Hi,
> > === I urgently need to know a way by which I can administrate
> completely
> my
> > SQL Server which is located in US over Internet sitting in India.
> > === Please send me any type ideas that can lead to a solutions to
> this
> > problem, this may include setting of VPN and etc.
> >
> > Thanks,
> > Prasun Ghosh
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> > http://www.dejanews.com/   Now offering spam-free web-based
> newsreading
> >
Technical Details
Message-ID: <35169BC1.46EFDD7C@abomb_anti-spam.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <6et6ea$da$1@nnrp1.dejanews.com> <01bd53f8$955e9340$0c7ce8c1@next>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f695,86b9c13d60660159
X-Google-Attributes: gid10f695,public
X-Google-Thread: 101948,86b9c13d60660159
X-Google-Attributes: gid101948,public
From: Steve Midgley <steve@abomb_anti-spam.com>
Subject: Re: SQL Server Remote Administration
Date: 1998/03/23
Message-ID: <35169BC1.46EFDD7C@abomb_anti-spam.com>
X-Deja-AN: 336879528
Content-Transfer-Encoding: 7bit
References: <6et6ea$da$1@nnrp1.dejanews.com> <01bd53f8$955e9340$0c7ce8c1@next>
X-Priority: 3 (Normal)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: cn.bbs.comp.database,microsoft.public.sqlserver.server