Open sa account and how to connect using JDBC

Doing experiments requires Java to connect to SQL Server because the SQL Express Edition used is installed with the installation of the Visual Studio2010 installation package, so in order to facilitate the operation of the database, a separate SQL Server is first downloaded Install the Management Studio installation package. After installation, set the SQL login mode, because the VS2010 comes with SQL Server by default, the SA account is disabled, which means that the network TCP/IP connection is not available, so the SA account must first be enabled for later operation.

the startup mode is as follows :

• Step 1: Open SSMs, connect to the database as Windows, log on, and then right-select Properties.
• Step 2: Left Select "Security" and select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode.
• Step 3: Select "Connect", check "Allow remote connection to this server", then click "OK".
• Step 4: Expand Object Data Manager security, login name "SA", right-click the "Properties" button.
• Step 5: On the left, select General, select SQL Server authentication on the right, and set the password.
• Step 6: Select "Status", select "Enable" and click "OK".
• Step 7: Right-click the database select Facet.
• Step 8: Set the "remoteaccessenabled" property to "True", click "OK" (Note: This item may not be found, You can do it without him.
• Step 9: Now that SSMs is set up, exit, restart the database, and log in with SA, success means that the SA account is enabled.

   

Before using their own method successfully opened SA account, but this time for some reason can not be successfully opened, so, re-"new login", built a new account, it has the same permissions as SA account can be used.

The SA account is now available and you need to configure SSCM (SQL Server Configuration Manager) to work correctly.

First make sure that the following services are turned on:

Configure the properties of TCP/IP "protocol", see the following:

Fill in the following information:

Fill in the IP address, pull to the bottom of the page, fill in the port.

Then configure the client protocol:

Then configure TCP/IP:

After restarting the database, you can use the SA account for remote login operation.

yuanwendizhi:http://blog.csdn.net/libenqing/article/details/6025616