blocks|key|245717|text|我也遇到过类似的问题--也许我的解决方案会有所帮助。我刚刚安装了MSSQL+ex2012(默认安装)，并尝试连接VS2012+EX。一点也不快乐。然后我查看了这些服务，确认SQL+Server+(SQLEXPRESS)确实在运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|245718|但是，我看到另一个有趣的服务，称为SQL+Server浏览器，它被禁用了。我启用它，启动它，然后能够在VS2012+EX中检索新连接中的服务器名称并进行连接。|245719|奇怪的是，他们会禁用VS连接所需的服务。|245720|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I had a similar problem - maybe my solution will help. I just installed MSSQL EX 2012 (default install) and tried to connect with VS2012 EX. No joy. I then looked at the services, confirmed that SQL Server (SQLEXPRESS) was, indeed running.

However, I saw another interesting service called SQL Server Browser that was disabled. I enabled it, fired it and was then able to retrieve the server name in a new connection in VS2012 EX and connect.

Odd that they would disable a service required for VS to connect.

blocks|key|245773|text|这很奇怪，我也有类似的问题。我下载了带有工具的SQL+2012+Express包，但没有安装数据库引擎。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|245774|我从MS站点上卸载了另一个，这个安装了数据库引擎。重新启动后，服务被列出并准备就绪。|245775|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This is odd I have a similar problem. I downloaded the package for SQL 2012 Express with Tools but the Database Engine was not install.

I donloaded the other one from the MS site and this one installed the database engine. After a reboot the services were listed and ready to go.

blocks|key|245810|text|我也遇到了同样的问题，我发现这是在我为我的SQL+2012安装了更新之后发生的。对我来说，修复它的方法是进入程序和功能，并对其进行修复。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|245811|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same issue and I found that this happened after I installed an update for my SQL 2012. What fixed it for me was going into programs and features and running a repair on it.

blocks|key|462386|text|尝试从windows身份验证更改为混合模式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|462387|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try changing from windows authentication to mixed mode

blocks|key|462498|text|转到开始->程序->+Microsoft+SQL+ServerYYYY+->+Configuration+Tools+->+SQL+Server+YYYY+Configuration+Manager或运行"SQLServerManager12.msc“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|462499|确保在客户端协议下启用了TCP/IP。|462500|然后进入"SQL+Server网络配置“并双击TCP/IP。单击"IP地址“选项卡并滚动到底部。在"IP+All“下删除TCP+Dynamic+Ports+(如果存在)，并将TCP+Port+(TCP端口)设置为1433。单击“确定”，然后返回到"SQL+Server服务“并重新启动SQL+Server实例。现在你可以通过localhost连接了，至少我可以。|462501|​|462502|📷|atomic|offset|length|462503|462504|请注意，当从其他应用程序连接时，当然也会发生此错误。普通C#+web应用程序Web.config连接字符串的示例：|style|CODE|462505|<connectionStrings>
++++<add+name="DefaultConnection"+connectionString="server=localhost;database=myDb;uid=myUser;password=myPass;"+/>
</connectionStrings>|code-block|syntax|javascript|462506|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/fc5e989a30f4f16b0f1f283e070601ce.png|imageAlt^0|0|0|0|0|0|1|0|0|0|12|A|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|16|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|17|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|18|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|19|8|@]|9|@$K|1A|L|1B|1|1C]]|A|$]]|$1|M|3|G|5|6|7|1D|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1E|8|@$K|1F|L|1G|P|Q]]|9|@]|A|$]]|$1|R|3|S|5|T|7|1H|8|@]|9|@]|A|$U|V]]|$1|W|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]]]

Goto Start -> Programs -> Microsoft SQL ServerYYYY -> Configuration Tools -> SQL Server YYYY Configuration Manager or run "SQLServerManager12.msc". 

Make sure that TCP/IP is enabled under Client Protocols.

Then go into "SQL Server Network Configuration" and double click TCP/IP. Click the "IP Addresses" tab and scroll to the bottom. Under "IP All" remove TCP Dynamic Ports if it is present and set TCP Port to 1433. Click OK and then go back to "SQL Server Services" and restart SQL Server instance. Now you can connect via localhost, at least I could.

<a href="https://i.stack.imgur.com/ogkmm.png" rel="noreferrer"><img src="https://i.stack.imgur.com/ogkmm.png" alt="enter image description here"></a>

Note that this error can of course occur when connecting from other applications as well. Example for a normal C# web application <code>Web.config</code> connection string:

<pre><code>&lt;connectionStrings&gt;
 &lt;add name="DefaultConnection" connectionString="server=localhost;database=myDb;uid=myUser;password=myPass;" /&gt;
&lt;/connectionStrings&gt;
</code></pre>

blocks|key|245913|text|在SQL+SERVER+EXPRESS+2012中，应使用"(localdb)\MSSQLLocalDB“作为数据源名称。例如，可以使用如下所示的连接字符串|type|unstyled|depth|inlineStyleRanges|entityRanges|data|245914|Data+Source=(localdb)\MSSQLLocalDB;Initial+Catalog=master;Integrated+Security=True;|code-block|syntax|javascript|245915|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

in SQL SERVER EXPRESS 2012 you should use "(localdb)\MSSQLLocalDB" as Data Source name
for example you can use connection string like this

<pre><code>Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=master;Integrated Security=True;
</code></pre>

blocks|key|245941|text|尝试将拥有该服务的用户更改为本地系统或使用您的管理员帐户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|245942|在services下，我更改了Service+SQL+Server+(MSSQLSERVER)+Log+On+from+NT+Service\Sql...到本地系统。右键单击该服务并转到Log+On选项卡，然后选择单选按钮Local+System+Account。您还可以强制其他用户也运行它，如果这样更合适的话。|245943|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Try changing the User that owns the service to Local System or use your admin account.

Under services, I changed the Service SQL Server (MSSQLSERVER) Log On from NT Service\Sql... To Local System. Right click the service and go to the Log On Tab and select the radio button Local System Account. You could also force another User to run it too if that fits better.

I just downloaded the latest version of SQL Express 2012 but I cannot connect to localhost. I tried localhost\SQLExpress and Windows authentication but it gives me an error message saying cannot connect. Am I missing something here? I've used SQL Server 2008 before and I've never had issues connecting to localhost. It seems that it can't even find it. Also in the Services I only see a SQL Server VSS Writer. Is this the way it should be? Or am I missing something? Thanks

Can't connect to localhost on SQL Server Express 2012 / 2016

身份验证

SQL Server

数据库

服务器

Windows

我刚刚下载了SQL Express 2012的最新版本，但无法连接到localhost。我尝试了localhost\SQLExpress和Windows身份验证，但它给我一条错误消息，告诉我无法连接。我是不是漏掉了什么？我以前使用过SQL Server2008，连接到localhost时从来没有遇到过问题。看起来它甚至...

问无法连接到SQL Server Express 2012 / 2016上的本地主机
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法连接到SQL Server Express 2012 / 2016上的本地主机EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法连接到SQL Server Express 2012 / 2016上的本地主机
EN