Configuring Network Settings for SQL Server

In this video Brian goes over the different options available for communicating with a SQL Server instance over a network. He then shows you how to enable and disable those options using the SQL Server Configuration Manager. Understanding these settings is important - they rarely change, but when they do, you'll want to know what it all means!

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Kevin Cole on 1/28/2009

Good as far as it went. But skipped any explanation of when you would be better off using dynamic port assignments. Only covered when you should turn them off in favor of a static port assignment. And, again, presenter spoke too quickly. But I like him.

Anand on 3/25/2009

cool

Vadis on 5/3/2009

good pace, very informative. thanks

Dipak Saha on 5/12/2009

Very good topic,

Jonathan on 7/2/2009

TCP disabled in Developer Edition by default is a gem, no idea why I hadnt looked or heard about that before! Thanks

Unknown Unknown on 7/2/2009

Why port 3333 in the 2nd instance? Any background on how to choose which port?

Dipak Saha on 7/2/2009

Good topic.

Christian Bahnsen on 7/2/2009

very informative

Bob Baker on 7/2/2009

Vista and Win2K8 firewall setup for SQL Server on TCP/IP would be a good follow up to this video

Josh Duncan on 7/2/2009

Very good. I didn't know that the named instance would use dynamic ports by default.

Steve Harris on 7/2/2009

Complete and helpful.

Jamshid Nouri on 7/2/2009

execellent demo

FELIX MELENDEZ on 7/8/2009

Excellent video!

aks on 10/29/2009

Good.

jafar on 12/2/2009

Excellent

malleswarareddy on 2/13/2010

Hi this good and simple

jagadeeswaran on 6/25/2010

it should be still more technical

nilanaksha on 6/25/2010

Good one..

Leigh Anne on 6/25/2010

I wish I'd seen this 5 days ago when I couldn't connect to my named SQL instance! Great explanation!

Robert McEuen on 6/25/2010

Good information. One thing that I noticed was that he was using the OS services applet to restart the SQL services. It was my understanding when SQL 2005 first came out that Microsoft made it very clear that we should use Configuration Manager or SSMS to restart services but never use the OS applet. Perhaps something changed or I got bad info.

Dennis Allen on 6/25/2010

I would like to know more about configuring a SQL Server as an appliance, meaning that SQL Server is the box's only purpose. Could be a wonderful series about the trade-offs of different parts of configuring the host hardware, host OS and SQL Server.

Leonard Peoples on 6/25/2010

Excellent tips. Thank you.

Alex Park on 6/25/2010

Great lesson! simple and great insight on network port change process. Useful info!

Charlie Bruno on 6/26/2010

I learned something new. Your video series are very good. I look forward to the emails advising of new topics.

achied on 6/26/2010

I'm already know about this. But in replication or mirroring situation SQL server only know domain name. I wish you can talk about more in security next time, like Tunneling protocol for mirror or replication, Like SSL and Encryption. Thanks bye the way

Don on 6/28/2010

Good explanation

John on 6/29/2010

Could use more information about shared memory