Re: How secure is the 2005 Management Studio?

Matt,

Although I have not done this for my installation, the Books Online discuss
encrypting communication between the client and server. You can start here
and follow the links to read about it:
http://msdn2.microsoft.com/en-us/library/ms190608.aspx

RLF

"Matt Schneider" <MattSchneider@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:89CB5AB9-A0DD-49A9-8256-674D6A2FE85B@xxxxxxxxxxxxxxxx
Let's say I'm just running a query or a report. The results are being
displayed on my desktop, so it seems that the information had to be
transmitted from the remote SQL server to my PC, right? If so, is that
data
transmitted in open text? Is it subject to hacking?

"Uri Dimant" wrote:

Matt
Do you mean run BACKUP\RESTORE commands? Or DTS?



"Matt Schneider" <MattSchneider@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:2FEE51A1-02E9-470F-9518-397A9E0691A7@xxxxxxxxxxxxxxxx
When I am transferring data from my desktop to a remote SQL Server
instance
or vice versa, is the data encrypted? Is there any way someone could
get
the
data?

I'm new to SQL Server.





.

Relevant Pages

  • Security strategy: Access client/SQL Server
    ... I will be creating an application using MS Access as a client to SQL ... SQL Server resides. ... permissions for group X to open form A, users would need to get a new ...
    (comp.databases.ms-access)
  • RE: Failed upgrade to SCCM
    ... When you only see 2 actions, that generally means that the client cannot ... I recently started the upgrade our SMS 2003 SP3 Server to SCCM. ... SQL Server security mode and as we require the SQL server to be in SQL & ... however fails at "Install SMS provider components". ...
    (microsoft.public.sms.setup)
  • SQL and Bandwidth use
    ... Dell PowerEdge server, Dual Xeon 2.4GHz processors, 4 GB ... Run Query against database, in Great Plains Client ... bandwidth usage by ... Client PC is on same segment as SQL server (not passing ...
    (microsoft.public.sqlserver.connect)
  • RE: Monolith -> layered client/server?
    ... That way you can put as many logical layers (data access, business rules, ... whatever) on a server talking to your SQL Server... ... Client would require db connection info. Using a windows app on the ... > to a layered .NET SQL server version. ...
    (microsoft.public.dotnet.general)
  • Re: error setting up ODBC for remote sqlexpress database
    ... We were able to get it to work with the ODBC native client driver. ... Server could be stopped in the client. ... is to install Management Studio for SQL Server 2005 Express ...
    (microsoft.public.sqlserver.odbc)