Wednesday, March 28, 2012
How to use/view SQL Srv from a workstation?
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/techinf...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[vbcol=seagreen]
>--Original Message--
>_Adrian wrote:
find/download
>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.
>.
>
Wednesday, March 21, 2012
how to use sql encryption via an asp site. is this correct?
ive been playing around with encryption, just encrypting a column with a symmetric key, and having that symmetric key encrypted with a cert, and all that , and it works well through the SSMS, but i want to know how that will be used if im using sql server as a back end database for an asp web site, or an application. does the sql server have to be protected with an SSL cert, and once a user has logged in, what would the steps be to view encrypted data?
lets say i have an asp.net site wtih forms authentication, where the username and password are checked against values stored in a table, all done via https so the password data cant fall into the wrong hands. once the user is authenticate this is my idea:
each user has a status, stored in the status column of the users table : Admin or RegularUser.
if the user status is an Admin, and clicks on something that returns encrypted data, a sproc checks the user has admin status and uses impersonation to impersonate a login that has control to use the encryption key that encrypted the data. so the data is returned unencrypted.
is this a valid way of using encryption via asp.net, or are their security issues?
|||SSL protects the communication with the server; the encryption you experimented with is for protecting the data within the server. For the steps required to view the encrypted data, it is up to you to determine those in your database application - you can have the user manually decrypt or you can have him access the data via views that automatically decrypt.
Thanks
Laurentiu
You can provide access to data via a view that automatically decrypts using decryptbykeyautocert, for example. You can then group your Admin users in a role and grant permissions to that role to use the key. Admin users would then be able to decrypt the data and see it; regular users would not be able to.
Thanks
Laurentiu