The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P28: 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. | Configuring SQL Server 2008 Chapter 3 117 their workstations using Management Studio anymore. You log on to the server through Terminal Services and can connect to each instance without issue. What could the cause of this behavior be A. The developers haven t created a SQL Server Alias to the named instance using the Shared Memory protocol. B. The SQL Browser Service has been started C. The SQL Browser Service has been stopped D. The IP addresses of the developers workstations have been added to the Exclude list in the TCP IP properties of the named instance in Configuration Manager. 4. Your security administrator has determined that all the SQL Servers in your organization need to listen on nondefault TCP ports and she doesn t want network users to see the SQL Servers in a browse list. Which two actions would achieve this goal A. Stop and disable the browser service on each SQL Server B. Use Configuration Manager on each server to change each instance to listen on port 50000 C. Use Configuration Manager on each server to change each instance to listen different ports D. Configure the SQL Browser Service to hide each instance E. Enable Show Advanced Options using sp_configure and use the Default TCP port option to configure the port for each instance 5. The company you work for has just merged with another company that uses Novell Netware as their network operating system. The new company s developers are struggling to connect to your SQL Server. What could be the problem A. SQL Server 2008 doesn t support the Banyan Vines protocol B. You haven t enabled the IPX SPX protocol C. You haven t enabled the Banyan Vines protocol D. SQL Server 2008 doesn t support the IPX SPX protocol 6. You have just upgraded your databases from a SQL Server 2005 default instance to a SQL Server 2008 named instance called Phobos on a server named MARS. The application that uses the SQL Server sits on its own server 118 Chapter 3 Configuring SQL Server 2008 and you ve just found out that
