Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SSL Connections and Dynamic Management Views

  
   Database Forums (Home) -> Security RSS
Next:  Create a seqence of numbers  
Author Message
Charles Hawkins

External


Since: Dec 03, 2008
Posts: 2



(Msg. 1) Posted: Wed Dec 03, 2008 11:20 pm
Post subject: SSL Connections and Dynamic Management Views
Archived from groups: microsoft>public>sqlserver>security (more info?)
If I'm setting up SSL encryption for my connections to a SQL Server and I'm
forcing it from the client side (optional from the server side), is there
some dynamic management view that I can use to see which sessions are using
SSL encryption and which are not?

 >> Stay informed about: SSL Connections and Dynamic Management Views 
Back to top
Login to vote
"Rick Byham,

External


Since: Jan 15, 2007
Posts: 80



(Msg. 2) Posted: Thu Dec 04, 2008 8:58 am
Post subject: Re: SSL Connections and Dynamic Management Views [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Check out the encrypt_option column of sys.dm_exec_connections
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Charles Hawkins" wrote in message

> If I'm setting up SSL encryption for my connections to a SQL Server and
> I'm forcing it from the client side (optional from the server side), is
> there some dynamic management view that I can use to see which sessions
> are using SSL encryption and which are not?
>

 >> Stay informed about: SSL Connections and Dynamic Management Views 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSIS : how to store password of connections - I made a package that copies data from one table of a sql server database to another table of another database sql server. I use oledb connection for the two connection I want to store user and password of the two connection to avoid retype them every....

SQL 2000 Views - SQL2000 Standard Ed. DB1 has base tables needed for viewing only. Insert, upd, del, select granted to 'public' role on most tables. DB2 to have views of DB1 tables. use DB2 go create view vw_mytable as select * from DB1.dbo.MyTable For new user,..

Security of views compared to non-views - When I say "non-view" I think I mean DML; correct me if I am wrong. We are trying to retrofit another vendor's software to use better security. I think that the software uses views to process it's data. For security purposes, is there any si...

Establishing a Role JUST to create and use views - Hello all, I am interested to know if there is a way to establish a role in a database where the user can create views of tables but not able to create or modify tables? Would this be done by restricting access to the tables themselves to SELECT but...

SQL 2k5 Views Referencing Different Schemas - Permissions .. - Hello all, Hopefully, someone here can help me out. First, a little background. No user has direct access to any table. All data access is accomplished by views and stored procedures. Most views and stored procedures are granted public for select and...
   Database Forums (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]