How to use/view SQL Srv from a workstation?

Sorry.. better email address this time..
--
I've got XP Pro as a desktop, and a need to be able to access SQL Server on
our host W2KServer box... I obviously can't install the managing apps on the
desktop... any suggestions from the masses what I might be able to do so I
can manage my databases remotely?
Side note.. the host admin really doesn't want to enable Terminal Services
on this box...
THanks_adrian wrote:
> Sorry.. better email address this time..
> --
> I've got XP Pro as a desktop, and a need to be able to access SQL
> Server on our host W2KServer box... I obviously can't install the
> managing apps on the desktop... any suggestions from the masses what
> I might be able to do so I can manage my databases remotely?
> Side note.. the host admin really doesn't want to enable Terminal
> Services on this box...
> THanks
You can install the SQL Server client tool on the client and have full
access to the server using tools like Enterprise Manger and Query
Analyzer. Is this what you are asking?
--
David G.|||Sounds about right! Any suggestions on where I could find/download the
client piece?|||_Adrian wrote:
> Sounds about right! Any suggestions on where I could find/download
> the client piece?
The client tool are a part of the SQL Server installation CD. Just throw
that CD in your PC and when the installer runs, just tell it you only
want to install the client tools. Then go to the MS web site and
download and install SQL Server service pack 3a on the client PC
(assuming you have not already downloaded the SP - or the CD has the SP
applied already). SPs are for client tools as well as the server.
--
David G.|||_Adrian wrote:
> Sounds about right! Any suggestions on where I could find/download
> the client piece?
I should point out that MS has an updated Books OnLine (BOL) on the web
site as well...
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Here's the link for the SP:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
David G.|||Ah... figures. And if the CD is in another state, there's no downloadable
install (MSDE maybe) or something of that nature?|||_adrian wrote:
> Ah... figures. And if the CD is in another state, there's no
> downloadable install (MSDE maybe) or something of that nature?
Don't think so. If you have a fast internet connection, just have
someone from the other state create an ISO image of the CD and post it
your web or ftp site.
--
David G.|||Also be careful of SP3a !
If you are using an Application (with COM+) to connect to
the Database you may experience a few problems (including
performance)...
We were experiencing various problems as soon as we
installed SP3a on our Win2K/SQL2K Server which doesn't
allow enough "simultaneous" Client connections from our
PowerBuilder/VC++ Application... Infact it was down to
MDAC2.8 (inside SQL_SP3a)!
Jerry
>--Original Message--
>_Adrian wrote:
>> Sounds about right! Any suggestions on where I could
find/download
>> the client piece?
>The client tool are a part of the SQL Server installation
CD. Just throw
>that CD in your PC and when the installer runs, just tell
it you only
>want to install the client tools. Then go to the MS web
site and
>download and install SQL Server service pack 3a on the
client PC
>(assuming you have not already downloaded the SP - or the
CD has the SP
>applied already). SPs are for client tools as well as the
server.
>--
>David G.
>.
>sql