SQL SERVER2008R2 errors that occur easily

A few days ago installed VS12, after the installation was completed found that SQL Server can not use the "Remote Call instance Failed", and then did not think, directly to the SQL Server uninstall, search the next vs comes with the localdb, spent two days, found that it is not good use, Today, reinstall SQL Server, installed after the discovery, or the original problem, in fact, as long as the uninstall LocalDB can use, eh, regret ah!

The cause of this problem is mostly, 1, service is not turned on, 2, the instance name is wrong, 3 did not install SQL correctly

Here are the specific steps to be done:

(1: Open SQL Server, connect to the database as Windows, log on, right-select the "Properties"

On the left, select "Security" and select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode

(2: Select "Connect", tick "Allow remote connection to this server", then click "OK"

(3: expand Security, login name, "sa", right-select "Properties", then "General" on the left, "SQL Server Authentication" to the right, and set the password; Select "Status", check "Enable", click "OK"

(4: Right-click the database, select "Facet", set the "Remoteaccessenabled" property to "True", point "OK"

(5: Now that SSMs is set up, exit first, and then log in with SA, success means that the SA account is enabled

Next, start configuring SSCM, open SSCM:

(6: Check the SQL Server service on the left to make sure that SQL Server on the right and SQL Server Browser are running

(7: TCP/IP on the right: double-click to open the Settings panel to modify it to "Enabled",

Select the "IP addersses" tab, set the port "1433",

"Client protocols" TCP/IP is also modified to "Enabled"

(8: configuration complete, restart SQL Server 2008, if Visual Studio 2010 is:

(9: You should be able to use it at this time, but check the firewall: Turn on firewall settings.) The SQLServr.exe (C:\Program Files\Microsoft SQL Server\mssql10. Sqlexpress\mssql\binn\sqlservr.exe) is added to the Allowed list.

SQL SERVER2008R2 errors that occur easily