Creating a Valid Connection String Using TCP IP.Creating a Valid Connection String Using Shared Memory Protocol.See the following topics for samples of connection strings:
WINDOWS 7 CONFIGURE SQL SERVER CLIENT PROTOCOLS SCRIPTS INSTALL
For more information, see Install SQL Server from the Command Prompt. When you are installing SQL Server with command-prompt arguments, you can specify the protocols to enable by using the TCPENABLED and NPENABLED parameters. Settings from the previous installation are preserved. Previous installation is present but is not being upgraded. The following table describes the configuration after installation. For more information, see Enable or Disable a Server Network Protocol. Use the SQL Server Services node of SQL Server Configuration Manager to configure the SQL Server Browser service to start automatically. Use the SQL Server Network Configuration node of SQL Server Configuration Manager to configure the network protocols after installation. The SQL Server Browser service might be stopped, depending on installation conditions and installation options. For all installations, shared memory protocol is enabled to allow local connections to the server.
Network connectivity using TCP/IP is not disabled if you are using the Enterprise, Standard, Evaluation, or Workgroup edition, or if a previous installation of SQL Server is present. To enhance security, SQL Server disables network connectivity for some new installations. Applies to: SQL Server (all supported versions)
0 kommentar(er)
