Todd's Blog

Todd's Tips for System Adminstrators

  • TechDays
  • Speaking Engagements
  • Contact Me
  • About Me

Connect

  • LinkedIn

Powered by Genesis

Securing SQL Traffic using Certificates

posted on February 11, 2015

I am deploying Microsoft Bitlocker Administration and Monitoring (MBAM) for a customer and one of the things we want to do is encrypt the traffic between the front end application server and the SQL Server. Here is what the topology looks like from TechNet.

Securing the connection between the two servers is relatively straight forward. First get a certificate from your favourite Certificate authority (can be internal or can be 3rd party in this case, your choice) and import it into your personal certificate store. What kind of cert do you need, check TechNet for the answer to that question. Basically it needs to be able to handle server authentication. Once imported, right-click on the certificate and manage the keys.

Screenshot for managing certificates

Here you assign read access to the keys to the account that runs the database service which will use the certificate. In my case I used a service account of srvdbsi01 so I assign that account the rights of read.

Screenshot of the properties for manage keys

Open SQL Configuration Manager. Expand SQL Server Network Configuration and right-click on Protocols for MSSQLSERVER or whatever the name of the instance you want to secure is.

Properties-for-protocols-SQL-Server

Next set the certificate by selecting it from the pull down list.

Certificate-For-Securing-SQL-Server

Then click on the flags tab and set the Force Encryption to Yes.

Force-Encryption-SQL-Server

Now restart the SQL service and you’ll be good to go.

Filed Under: Technology Tagged With: Certificates, Encryption, SQL, SQL Server, SSL

User Group Event:SQL Server 2008 R2 Reporting Services and Self-Service Analytics

posted on May 26, 2010

Session 1:  Introduction to SQL Server 2008 R2 Reporting Services and SharePoint 2010 Integration

David E. Myers

Speaker: David E. Myers

Ever since business applications were introduced, there was a need for great data reporting tools.  With the release of SQL Server Reporting Services 2008 R2, Microsoft has made a stronger case than ever for investing in their reporting solution.  In this session David will provide an overview of SQL Server 2008 R2 Reporting Services with a focus on the key value proposition, core architecture, development tools, and integration with SharePoint 2010. [Read more…]

Filed Under: User Groups Tagged With: KITPro, Sharepoint 2010, SQL, SQL Server 2008

OttawaSQL.net User Group Meeting January 15th, 2009

posted on January 14, 2009

 

Note, this meeting is scheduled for tomorrow night.

 

OttawaSQL.net

Free Evening Event @ Microsoft Ottawa

Thursday, January 15th 6:00 – 8:00 PM

SQL Server 2008 Developer Enhancements Part 2 –

Management Studio Enhancements & PowerShell Integration, Michelle Gutzait

At our December meeting Klaus showed us a number of fantastic enhancements to T-SQL and the relational engine.  For the January session we turn our attention to the enhancements made to the Management Studio, Query Editor & Debugger, and look at some of the new capabilities provided through Performance Studio integration.  Please note that we are now starting the presentation at 6:00 PM and that pizza is not provided.  No one will be admitted after 6:00 PM.

Session: SQL Server 2008 Developer Enhancements Part 2 –

Management Studio Enhancements & PowerShell Integration, Michelle Gutzait

SQL Server 2008 provides a lot of new features for .NET and T-SQL developers.  In this Session Michelle will show you how to improve your efficiency working in the management studio by leveraging its new features.  Not using SQL Server 2008 yet?  Using the new management studio for your 2005 instances is a great way to start taking advantage of some of these productivity improvements for SQL developers and DBAs.  Following the tour of the management studio enhancements Michelle will highlight some of the new capabilities provided through the integration of Performance Studio.

Speaker: Michelle Gutzait, The Pythian Group

Michelle Gutzait

Michelle

Michelle has been involved in IT for almost 20 years as a developer, business analyst and database consultant.  She has worked exclusively with Microsoft SQL Server for the past 10 years, consulting for many and diverse clients. Her skills include infrastructure and database design, performance tuning, security, high availability and clustering, consolidation analysis, disaster recovery, very large databases, Replication, T-SQL coding and optimization, DTS/SSIS packages, administrative and infrastructure tools development, Reporting Services, Analysis Services, MIIS, training developers and DBAs and more.

REGISTRATION:

LOCATION:

RSVP: Event Registration

Arrival:  5:30 PM to 6:00 PM

Presentation:  6:00 PM to 8:00 PM

Refreshments: Pop only

Microsoft Ottawa, World Exchange Plaza

100 Queen Street, Suite 500, Ottawa

SQLTeach Special Event: BI Boot Camp, March 9th to 10th in Ottawa!!!

BI Boot Camp

Use our group’s rebate code OT00SQLNET to register and save $100 off the $999 registration!

Business Intelligence is one of the topmost IT priorities and is increasingly pervasive within organizations large and small. Business Intelligence touches many aspects of our daily lives, from enhancing our online and retail shopping experience to the healthcare we receive. BI also impacts the quality of decisions that business leaders make.

This 2 days (March 9-10,2009) boot camp has been designed to give you a head start in Business Intelligence practice. You will acquire fundamental knowledge of Business Intelligence and dimensional modeling along with understanding on how to use the various Microsoft technologies to implement a BI solution.

Instructor: Rushabh Mehta, SeQueL BI Solutions

Rushabh Mehta

Rushabh

Mehta

Rushabh is an Independent Consultant and a Business Intelligence Mentor for Solid Quality Mentors. He has been the lead architect for many large scale and complex Business Intelligence solutions for large enterprise clients such as Publix, Raymond James Financials, Jackson Hewitt, Checkers and most recently on a multi-terabyte Health Services solution for the US Department of Defense. Additionally, he has been a mentor for a large number of client such as Veterans Health Administration, Intuit, Zillow.com, Cymer, Navy Medical Center, Talbots, FM Global and Sunoco. Rushabh is also a BI trainer and has taught BI courses in countries around the world. Through his work experience, Rushabh has been instrumental in creating multiple best-practices in the implementation of the BI technologies.

Rushabh also serves on the Board of The Professional Association for SQL Server (PASS) as the Director of Technology. In his current position, Rushabh is responsible for the overhaul of their technology infrastructure in order to better serve the SQL Server user community. Rushabh is also a SQL Server MVP and a frequent speaker at large conferences as well as PASS Chapters around the world.

OttawaSQL.net is a community group of Ottawa area developers and IT professionals.  We share an interest in Microsoft’s data technologies especially:  SQL Server, SharePoint, PerformancePoint, Workflow Foundations, LINQ, ADO.NET and Entity Framework.

Unsubscribe?  This mailing list is used only to inform members of OttawaSQL.net events, which are for the most part, free events due to the contributions of sponsors and volunteers. Since our events are not possible without sponsors we will occasionally include special offers to our members from these sponsors.   If you wish to be removed from this mailing list, please respond to this message with ‘Unsubscribe’ in the subject.

Filed Under: User Groups Tagged With: OttawaSQL.net, SQL, SQLTEACH

  • 1
  • 2
  • 3
  • Next Page »

Recent Posts

  • Office 365 – Creating Custom SKUs
  • Setting a Default Printer in Windows 10
  • Deploying Windows to the Correct Drive in Configuration Manager
  • Surface Pro 4, Surface Dock and DVI Problems
  • Enabling UEV in Windows 10 1607

Recent Comments

  • Moore Details on Setting up a Delayed Charge in Quickbooks Online
  • MCP Exam Training on Using PowerShell to Get a List of Groups from Active Directory
  • Kac on Setting up an Office 2010 KMS Host Server
  • prabumedia.com | Pilih lisensi MAK atau MKS untuk aktifasi produk Microsoft ? on Setting up a KMS Server
  • prabumedia.com | Pilih lisensi MAK atau MKS untuk aktifasi produk Microsoft ? on Setting up an Office 2010 KMS Host Server

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org