tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 14

SQL Server 2008 sau triết lý của Microsoft hoàn toàn bảo mật''''và làm giảm diện tích bề mặt của ứng dụng. Việc cài đặt ban đầu chỉ cho phép truy cập địa phương - không có kết nối mạng cho các Express và phát triển các phiên bản (ví dụ, các ứng dụng máy khách từ xa sẽ không thể kết nối). | SQL Server 2008 follows Microsoft s philosophy of secure by default and reduces the surface area of the application. The initial installation allows local access only no network connections for the Express and Developer editions . remote client applications will not be able to connect . L C p C f Chapter 4 Installing SQL Server 2008 discusses SQL j ._ 1 Server surface area configuration as part of the installation process. The Server Configuration Manager tool installed with SQL Server can nearly always communicate with SQL Server so you can configure the server connectivity options and open the server up for network access. The connectivity relies on open paths between the client and server machines. At times there will be firewall issues to deal with. IN THIS CHAPTER Enabling server connectivity SQL Native Client development features Client software connectivity With network access allowed on the SQL Server SQL Server provides clients with a new means of accessing functionality and features through the new SQL Server Native Client SNAC . Before getting into the SNAC network access for the new server must be enabled. Enabling Server Connectivity When initially installed SQL Server enables the Shared Memory protocol and disables the remaining protocols. This provides the greatest default security because only applications running locally to the SQL Server can connect. To broaden SQL Server availability additional network protocols must be enabled on the server. 93 Part I Laying the Foundation What s New in 2008 Connectivity SNAC supports table value parameters. Table-valued parameters are a new parameter type in SQL Server 2008. There is a new SNAC OLE DB provider. You ll need to get version 10 of SNAC. Also of note for developers Microsoft Data Access Components MDAC is compatible with SQL 2008 but will not be enhanced to support the new 2008 SQL Server features. Chapter 39 Configuring SQL Server discusses SQL Server .