Detailed steps for installing SQL Server after installing VS2015, vs2015server2014

Detailed steps for installing SQL Server after installing VS2015, vs2015server2014

It has always been said on the Internet that installing SQL Server 2014 and VS2015 will not cause any problems. I have installed VS2015 without any preparation. After the installation, I found that SQL2014 comes with VS2015 only supports Server connection and database management, and can operate databases, you cannot enter the management interface of SQL Server 2014 Managemengt Studio. I think another Chinese version of SQL Server 2014 is installed.

First, uninstall the SQL Server2014 component that comes with VS2015. Otherwise, the installation may fail due to a conflict. Directly use the software management and uninstall software of the Computer Manager, search for SQL Server, Uninstall all software programs with SQL Server, delete all SQL Server folders, and use the computer manager to clean up the garbage, the purpose is to clear useless registries.

The next step is to download the image file or compressed file of SQL2014. The operating systems supported by SQL Server 2014 include Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, and Windows Server 2012 R2. The standard edition also supports Windows 7, Windows 8, and Windows 8.1 operating systems.

Install. Net Framework 3.5 sp1

If the local machine does not have. Net FrameWork 3.5 sp1, an error is reported during installation. First, ensure that there is. Net FrameWork 3.5 sp1 on the local machine.

Install SQL Server2014

1. decompress the downloaded sql44, open the setup.exe file in the installation package, and start the Installation Wizard:

2. Enter the product key and click "Next ";

3. Accept the license terms;

4. Check for important updates and proceed to the next step;

5. Install the rule without warning. You only need to click Next;

6. Set the role and select the SQL Server Function for installation;

7. function Selection: instance function, connection function, client function, etc. function description is provided on the right. You can also click Select All below;

8. function rules. If. NET 3.5 sp1 is not installed, it cannot be continued.

9. Configure the instance. By default, click Next;

10. Configure the server. By default, click Next;

11. For database engine configuration, we recommend that you use "hybrid mode", enter the sa password, and click "add current user ";

12. Analysis Services Configuration

Click "add current user" according to the default configuration. If you do not select this function, this step is unavailable;

13. Configure Reporting Services

Follow the default configuration. If you do not select this function, this step is unavailable.

14. Distributed Replay Controller

Click "add current user" according to the default configuration. If you do not select this function, this step is unavailable;

15. On the Distributed Replay client, enter the Controller name;

16. Prepare for installation. Click the installation button to start. The installation may take half an hour.

17. The installation is complete when the page is displayed. If the installation fails, the SQL Server2014 component is not uninstalled.

In the control panel, fix VS2015 in the program. Otherwise, an error will be reported when VS2015 is enabled.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.