The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P25: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 102 Chapter 3 Configuring SQL Server 2008 Launch SQL Server Management Studio and try to connect to computername SQL1. You should now be able to connect. You have just changed the SQL Server Service account changed the TCP port to a fixed nondefault value stopped dynamic port detection and created a client connection alias specifying the TCP port to which to connect. Configuring Implementing. Stopping Dynamic Port Detection Some companies require that dynamic port detection and being able to browse to SQL Servers on their network must be disabled to tighten security. They do this by stopping the SQL Browser Service on all their SQL Servers and manually configuring each SQL Server instance to listen on a fixed TCP port. All the applications that connect to the SQL Server instances either specify the port number in the connection string or have a SQL Server Alias configured on the application server which contains the port number. sp_configure and SQL Server Management Studio We ve covered installing and configuring the different SQL Server Services so far. Now we ll move on to configuring SQL Server itself. SQL Server Management Studio is the central tool for managing SQL Server and you will need to be very familiar with it for the exam. Fortunately most of the exam objectives require the use of this tool so you will get plenty of practice with it as you read through the book. For this section we re going to be focused on the Server Properties that can be changed through the Management Studio interface and by using the sp_configure command in a query window. sp_configure provides far more configuration options than the Management Studio interface and you will need to be familiar with it for the exam. Because of this we re going to focus on sp_configure and its options highlighting where a particular option is also available in Management Studio. Configuring SQL Server 2008 Chapter 3 103 To run sp_configure simply type it into a query window and click execute. In .
