安装visual studio 2015和sql server 2016 [英] install visual studio 2015 and sql server 2016

问题描述

你好，



我最近安装了Visual Studio 2015然后我安装了MS sql server 2016.

使用sql server managment studio sql当我们尝试连接到服务器时，服务器名称未列在服务器名称的下拉列表中。我知道如果我们安装visual studio然后安装sql server那么它会产生一些问题。是这个问题吗？

解决方案

首先要检查的是SQL Server服务的启动和运行。如果是，请检查您的连接字符串，尤其是在实例名称中仔细查看。例如，请查看 SQL Server连接字符串 - ConnectionStrings.com [ ^ ]。这些应该可以帮助您连接到实例



如果在下拉列表中列出实例，请确保SQL Browser服务正在运行。有关此服务的详细信息，请查看 SQL Server Browser服务 [ ^ ]

Hello,

I recently installed Visual studio 2015 and then I installed MS sql server 2016.
Using sql server managment studio sql server name is not listed in the drop down list of server name when we trying to connect to server. I know that if we install visual studio and then sql server then it will give some problems. Is that this problem?

解决方案

The first thing you should check, is the SQL Server service up and running. If it is, check your connection string, especially have a close look in the instance name. For examples, have a look at SQL Server connection strings - ConnectionStrings.com[^]. These should help you to connect to the instance

What comes to listing the instances in the drop down list, make sure that SQL Browser service is running. For detailed information about this service, look at SQL Server Browser Service[^]

这篇关于安装visual studio 2015和sql server 2016的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！