【正文】 參考文獻(xiàn)[1]楊文龍，姚淑珍，吳云，軟件工程，電子工業(yè)出版社，1997[2] 楊鯤鵬，+SQL ：電子工業(yè)出版社，2006，3228[3] 蔡毅，[M] .北京：清華大學(xué)出版社，2004 [4] 張躍廷 蘇宇 貫偉，(C)(第2版) 人民郵電出版社 200901出版[5] +SQL Server動(dòng)態(tài)網(wǎng)站開發(fā)與實(shí)例清華大學(xué)出版社 200607出版) [6] 語言與SQL語言的基本知識(shí)[M]．北京： 清華大學(xué)出版社,2004,169[7] 劉聰敏．[M]．北京： 清華大學(xué)出版社，2004，1050[8] 龍馬工作室．ASP+SQL Server網(wǎng)站開發(fā)實(shí)例精講．北京：人民郵電出版社，2007，395403[10] 趙池龍，楊林，孫偉．實(shí)用軟件工程[M]．北京：電子工業(yè)出版社，2006[11]丁貴廣，(第2版) 機(jī)械工業(yè)出版社200411[12] 范立南，SQL Server2000實(shí)用教程清華大學(xué)出版社 200804 附錄附錄A 外文資料與中文譯文A1 外文資料How to troubleshoot connectivity issues in SQL Server 2000Chris Tull, Microsoft Help and SupportThis article can help you to resolve connectivity problems with Microsoft SQL Server 2000. This article contains descriptions of mon connectivity problems and the steps that you can take to help resolve your connectivity problems. SQL Server 2000 supports several methods of munication between the instance of SQL Server and the client applications. If your client application and the instance of SQL Server reside on the same puter, Microsoft Windows interprocess munication (IPC) ponents, such as local named pipes or the Shared Memory protocol, are used to municate. However, when the client application and the instance of SQL Server reside on different puters, a network IPC, such as TCP/IP or named pipes, is used to municate.SQL Server 2000 uses NetLibrary, a DLL, to municate with a particular network protocol. A matching pair of NetLibraries must be active on the client puter and the server puter to support the network protocol that you want to use. For example, if you want to enable a client application to municate with a specific instance of SQL Server across TCP/IP, the client TCP/IP Sockets NetLibrary () must be configured to connect to the server on the client puter. Likewise, the server TCP/IP Sockets NetLibrary () must listen on the server puter. In this scenario, the TCP/IP protocol stack must be installed on both the client puter and the server puter.After you install SQL Server 2000, you can configure the properties of the client NetLibraries by using Client Network Utility. You can configure the properties of the server NetLibraries by using Server Network Utility (). The server NetLibraries are installed during the installation of the server tools in SQL Server Setup. However, some of the server NetLibraries may not be active. By default, SQL Server 2000 enables and listens on TCP/IP, named pipes, and Shared Memory. Therefore, for a client to connect to a server puter, the client must connect by using a client NetLibrary that matches one of the server NetLibraries that is currently being used by the instance of SQL Server.For additional information about SQL Server munication ponents and NetLibraries, see the following topics in SQL Server Books Online: ? Communication Components? Client and Server NetLibraries? Managing ClientsTroubleshoot connectivity issuesMost of the connectivity issues that you may notice in SQL Server 2000 occur because of problems with TCP/IP, Windows authentication, or a bination of TCP/IP and Windows authentication. Important Before you start to troubleshoot connectivity issues in SQL Server 2000, make sure that the MSSQLServer service is started on the puter that is running SQL Server.Verify your DNS settingsThe name resolution process in Domain Name System (DNS) is used to resolve the IP address to the name of the instance of SQL Server. If the name resolution process does not work correctly, the instance of SQL Server is not reachable, and you may receive one or more of the following error messages: SQL Server does not exist or access deniedGeneral Network ErrorCannot Generate SSPI ContextTo verify that the name resolution process is resolving the correct server, you can ping the server by using the server name and the IP address of the server. To do so, follow these steps: 1. Click Start, and then click Run.2. In the Run dialog box, type cmd in the Open box, and then click OK.3. At the mand prompt, run the following mand:ping Server NameNote the IP address that is returned.4. At the mand prompt, run the following mand (where IP address is the IP address that you noted in step 3):ping –a IP addressVerify that the mand resolves to the correct server name. If either of the specified mands are not successful, time out, or do not return the correct values, the DNS lookup is not working correctly or the problem occurs because of other networking or routing issues. To see your current DNS settings, run the following mand at a mand prompt:ipconfig /allTo work around this problem, add an entry for the server to the %systemroot%\system32\drivers\etc\hosts file on the client puter. You can also work around the problem by connecting to the server by using the Named Pipes Netlibrary.Verify the enabled protocols and aliasesConnectivity problems may occur if the alias on the client puter is set incorrectly. You can view the aliases by using Client Network Utility. To do so, follow these steps: 1. Start Client Network Utility. If the SQL Server client tools are installed on the puter that is running the client application, follow these steps to start Client Network Utility: a. Click Start, and then point to Programs.b. Point to Microsoft SQL Server, and then click Client Network Utility.If the SQL Server client tools are not installed on the client puter, follow these steps to start Client Network Utility: a. Click Start, and then click Run.b. In the Run dialog box, type cliconfg in the Open box, and then click OK.2. In the SQL Server Client Network Utility window, click the General tab, and then enable all the protocols that you want to use.Note You must at least enable the TCP/IP protocol and the named pipes protocol.3. Click the Alias tab, and then verify the aliases that are configured for the instance of SQL Ser