SQLserver open TCP/IP logon and enable the default port 1433

PreSQLserver open TCPIP login, and enable the default port 1433 classification: SQLServer1433 remote login saTCPIP2013-04-2011: 07124 people read discussion (0) Preservation exposed SQLServer1433 remote login saTCPIP ????? Condition: the Right-click Database feature, with security-SQLserver user and windo

PreSQL server enables TCP/IP login and the default port 1433 classification: SQLServer 1433 remote login sa TCP/IP 124 people read discussion (0) Preservation expose SQLServer1433 remote login saTCPIP? ? ? ? ? Condition: the Right-click Database feature, with security-SQLserver user and windo

Enable TCP/IP on SQL serverLoginAndEnableAcquiesce1433PortCategory: SQL Server 1433 remoteLoginSa TCP/IP 124 people read discussion (0) Preservation exposure SQLServer1433 remoteLoginSaTCPIP? ? ? ? ? Condition: Right-click the database and choose security> SQL Server user and windows user verification method? And set the user name for remote access,AcquiesceThe http://www.superkp123.com is sa (Security-user name-sa-> SettingsLoginPassword andLoginSetEnable)? 1. Open the database folder-> Find the configuration item-> configuration manager? ? 2. network configuration-> click MSsqlserver-> right-click TCP/IP features? ? 3. Select an IP address for correction. 4. CorrectPortSwitch the number to 1433 (so that other computers can use your ip address to access your database )? ? ? 5. Can I check whether the configuration is successful in native client? ? 6. Select the peripheral equipment in the equipment room (that is, open the name/IP address)Login7. Select the peripheral servers? 8. Set Database Remote Control-> set to ip address and Named PipeLogin? 9. Restart and use ip sqlserver usersLogin, OK, the setting is successful. Previous Article: cainiao who have just installed Windows 2003. next article: mysql authorized IP AddressLoginTop 0 STEP 0 http://www.fp1111.info