blocks|key|1743061|text|上面提到的问题发生在我的本地系统中。签入sql+server配置管理器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1743062|步骤1：|1743063|SQL+server网络配置|1743064|第2步：|1743065|本地服务器名称的|1743066|协议名称|unordered-list-item|1743067|协议名称已禁用或未禁用..|1743068|如果未禁用，请禁用并检查|1743069|1743070|。。进行更改后，sql+server浏览器开始工作。|1743071|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|L|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|L|7|12|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|14|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|U|$]]

Above mentioned issue happened in my local system. Check in sql server configuration manager. 
Step 1: 
SQL server Network configuration 
step 2: 

<ul>
<li>Protocols for local server name</li>
<li>Protocol name VIA Disabled or not..</li>
<li>if not disabled , disable and check</li>
</ul>

.. after I made changes the sql server browser started working

blocks|key|434839|text|也有同样的问题，我解决了它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|434840|434841|Open+SQL+Server+Configuration+manager|ordered-list-item|434842|单击SQL+Server+Services+(在我要启动的SQL+Server实例上的left)|434843|Double-click上)|434844|选择Built-in+account选项卡中的Built-in+account单选按钮，然后从下拉菜单中选择本地系统<+Log+On+>H111>单击底部的应用，然后右键单击该实例并选择代码|offset|length|style|CODE|434845|434846|entityMap^0|0|0|0|0|0|2|G|N|G|1O|6|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|W|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|X|8|@$L|Y|M|Z|N|O]|$L|10|M|11|N|O]|$L|12|M|13|N|O]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|R|$]]

Had the same problem, I fixed it.

<ol>
<li>Open SQL Server Configuration manager</li>
<li>Click on the SQL Server Services (on the left)</li>
<li>Double-click on the SQL Server Instance that I wanted to start</li>
<li>Select the <code>Built-in account</code> radio button in the <code>Log On</code> tab and choose Local system from the dropdown menu</li>
<li>Click apply at the bottom, then right click the instance and select <code>Start</code></li>
</ol>

blocks|key|1733624|text|这真的很有效-我已经验证了很多网站，最终得到了答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1733625|当master.mdf或mastlog.ldf损坏时，可能会发生这种情况。为了解决这个问题，转到下面的路径。|1733626|在C:\Program+Files\Microsoft+SQL+Server\MSSQL10_50.MSSQLSERVER\MSSQL中，您将找到一个文件夹“Template+Data”，复制master.mdf和mastlog.ldf并将其替换为|offset|length|style|CODE|1733627|C:\Program+Files\Microsoft+SQL+Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA文件夹。|1733628|就这样。现在启动MS+SQL服务，您就完成了。|1733629|entityMap^0|0|0|1|1U|0|0|1Z|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@$F|V|G|W|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|O|$]]

This really works - i had verified lot of sites and finally got the answer.

This may occurs when the master.mdf or the mastlog.ldf gets corrupt . In order to solve the issue goto the following path.

<code>C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL</code> , there you will find a folder ” Template Data ” , copy the master.mdf and mastlog.ldf and replace it in

<code>C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA</code> folder .

That's it. Now start the MS SQL service and you are done.

blocks|key|1735302|text|如果您在本地环境中运行SQL+Server，而不是通过TCP/IP连接。转到“SQL+Server配置管理器”、“属性”下的“协议”，然后禁用TCP/IP。一旦完成此操作，当重新启动服务时，错误消息将消失。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1735303|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|$]]

If you are running SQL Server in a local environment and not over a TCP/IP connection. Go to Protocols under SQL Server Configuration Manager, Properties, and disable TCP/IP. Once this is done then the error message will go away when restarting the service.

blocks|key|336217|text|如果您最近更改了与服务帐户关联的密码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|336218|启动左侧窗格中的SQL+Server+Configuration+Manager.|336219|Select和SQL+Server+Services。在右侧窗格中右键单击要启动的服务，然后单击Properties.|unordered-list-item|offset|length|style|BOLD|336220|
|336221|Enter+|336222|336223|+Confirm+Password。|336224|336225|entityMap^0|0|0|1C|A|0|0|0|0|0|I|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@$G|X|H|Y|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|Z|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|10|8|@]|9|@]|A|$]]|$1|O|3|L|5|6|7|11|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|12|8|@$G|13|H|14|I|J]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|T|$]]

If you recently changed the password associated with the service account:

<ol>
<li>Start SQL Server Configuration Manager.</li>
<li>Select SQL Server Services in the left pane.</li>
<li>Right click the service you are trying to start in the right pane and click Properties.</li>
<li>Enter the new Password and Confirm password.</li>
</ol>

blocks|key|1743173|text|当我遇到同样的问题时，这是非常乏味的。当我遇到这个问题时，我卸载了我的SQL+Server2008，但在再次安装SQL+Server2008之后，我又遇到了同样的问题。我太紧张了，而且我还没有从任何网站上得到任何帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1743174|来克服这个问题。您只需进入SQL+Server配置管理器，然后单击左侧面板上的协议。如果您运行网络服务，只需禁用'VIA‘协议即可。然后尝试启动您的SQL服务，它将成功运行。|1743175|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|$]]

It was very tedious when I get same problem. When I got this problem, I uninstall my SQL Server 2008 but after installing the SQL Server 2008 again,I got the same problem. I was so tensed plus, I had not gotten any help from any site.

To over come this problem. Simply You Need to go on SQL Server Configuration Manager and then click On Protocols on left panel. If you running Network service just disable 'VIA' Protocol.
And after that try to start your SQL service it will run successfully.

blocks|key|336282|text|在追踪此问题几个小时后，我们在SQL+Server代理日志中发现了一个日志，其中说明了以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|336283|This+installation+of+SQL+Server+Agent+is+disabled.+The+edition+of+SQL+server+that+installed+this+service+does+not+support+SQL+server+agent.|code-block|syntax|javascript|336284|我们使用的是SQL+Server+Express。在谷歌了一下之后，似乎SQL+Server+Express不支持SQL+Server代理。|offset|length|style|BOLD|336285|我没有发现任何直接的Microsoft通信表明SQL+Express不支持SQL+Server代理，然而，这种观点似乎在许多论坛中得到了回应。|336286|entityMap^0|0|0|V|13|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

After chasing this issue for some hours, we found an log in the SQL Server Agent logs stating the following:

<pre><code>This installation of SQL Server Agent is disabled. The edition of SQL server that installed this service does not support SQL server agent.
</code></pre>

We were using SQL Server Express. After some Googling it appears SQL Server Express does not support SQL Server Agent.

I didn't find a direct piece of Microsoft communications stating that SQL Express doesn't support SQL Server Agent, however this sentiment seems to be echoed across many forums.

blocks|key|1733817|text|在我的例子中，问题是我正在运行另外两个SQL+Server实例，这两个实例正在(或至少其中一个)导致冲突。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1733818|解决方案只是停止另一个SQL+Server实例并对其附带的SQL+Server代理执行操作。|offset|length|style|BOLD|1733819|​|1733820|📷|atomic|1733821|1733822|在此期间，我还建议确保在服务器的协议设置中启用了Named+Pipes|CODE|1733823|1733824|1733825|1733826|1733827|1733828|1733829|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a703e1f46916704a36ace8be8127596f.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/7049c1ddb1489c4b559a64cbd9d301a3.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/a0d6fa941e53132e0fb57ff326f34af4.png^0|0|N|K|0|0|0|1|0|0|0|O|B|0|0|0|1|1|0|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1D|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1E|8|@]|9|@$D|1F|E|1G|1|1H]]|A|$]]|$1|M|3|I|5|6|7|1I|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1J|8|@$D|1K|E|1L|F|P]]|9|@]|A|$]]|$1|Q|3|I|5|6|7|1M|8|@]|9|@]|A|$]]|$1|R|3|K|5|L|7|1N|8|@]|9|@$D|1O|E|1P|1|1Q]]|A|$]]|$1|S|3|I|5|6|7|1R|8|@]|9|@]|A|$]]|$1|T|3|I|5|6|7|1S|8|@]|9|@]|A|$]]|$1|U|3|K|5|L|7|1T|8|@]|9|@$D|1U|E|1V|1|1W]]|A|$]]|$1|V|3|I|5|6|7|1X|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]|15|$5|Z|10|11|A|$12|16|14|-4]]|17|$5|Z|10|11|A|$12|18|14|-4]]]]

In my case, the issue was that I was running two other SQL Server instances which were (or at least one of them was) causing a conflict.

The solution was simply to stop the other SQL Server instance and its accompanying SQL Server Agent.

<a href="https://i.stack.imgur.com/Ly2pC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ly2pC.png" alt="stop sql server service"></a>

While I'm at it, I'll also recommend making sure <code>Named Pipes</code> is enabled in your server's protocol settings

<a href="https://i.stack.imgur.com/Fwmcz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fwmcz.png" alt="SQL Server Protocols Named Pipes 1"></a>

<a href="https://i.stack.imgur.com/ruvac.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ruvac.png" alt="SQL Server Protocols Named Pipes 2"></a>

blocks|key|336689|text|我也遇到过类似的问题。下一个解决方案是在*情况下无法在本地启动服务器*，您将看到相同的错误消息。(图1)|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|336690|​|336691|📷|atomic|336692|图像1|336693|336694|336695|图像2|336696|要解决这个问题并让服务器正常工作，您必须执行以下步骤。|336697|SQL+server转到SQL+Server+Services|336698|Right单击以打开properties|unordered-list-item|336699|
|336700|Go+to++LogOn选项卡(默认情况下，您将看到类似于图3的内容)|336701|336702|选择单选按钮Built-in+account+(图4)|336703|336704|单击Ok|336705|336706|Go+back+to+SQL+Server服务并再次启动服务器(图5)，之后您必须能够看到它的运行。|336707|336708|336709|336710|图像3|336711|336712|336713|图像4|336714|336715|336716|图像5|336717|我希望这对你或其他有类似问题的人都有效。请关注我以获取更多提示。|336718|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/2617826821a2b76cb4760bc1e806ce10.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/afe8ad5cdec261f6ac517e1cfee3b7c3.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/b14b40578230808cdb47d4a69491e093.png|3|https://ask.qcloudimg.com/http-save/yehe-900000/0b6d0c414c02779e9e772b2bd75b4bc1.png|4|https://ask.qcloudimg.com/http-save/yehe-900000/ded80facc6dc417f46b83cd03c7415c1.png^0|K|F|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|A|A|0|0|7|S|0|0|0|R|0|0|0|4|0|0|0|1E|0|0|0|1|0|0|1|0|1|2|0|0|3|0|0|1|0|0|1|0|1|3|0|0|3|0|0|1|0|0|1|0|1|4|0|0|3|0|0|W|0^^$0|@$1|2|3|4|5|6|7|26|8|@$9|27|A|28|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|29|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|2A|8|@]|D|@$9|2B|A|2C|1|2D]]|E|$]]|$1|K|3|L|5|6|7|2E|8|@]|D|@]|E|$]]|$1|M|3|G|5|6|7|2F|8|@]|D|@]|E|$]]|$1|N|3|I|5|J|7|2G|8|@]|D|@$9|2H|A|2I|1|2J]]|E|$]]|$1|O|3|P|5|6|7|2K|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|2L|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|2M|8|@]|D|@]|E|$]]|$1|U|3|V|5|W|7|2N|8|@$9|2O|A|2P|B|C]]|D|@]|E|$]]|$1|X|3|Y|5|6|7|2Q|8|@]|D|@]|E|$]]|$1|Z|3|10|5|W|7|2R|8|@$9|2S|A|2T|B|C]]|D|@]|E|$]]|$1|11|3|Y|5|6|7|2U|8|@]|D|@]|E|$]]|$1|12|3|13|5|W|7|2V|8|@$9|2W|A|2X|B|C]]|D|@]|E|$]]|$1|14|3|Y|5|6|7|2Y|8|@]|D|@]|E|$]]|$1|15|3|16|5|W|7|2Z|8|@$9|30|A|31|B|C]]|D|@]|E|$]]|$1|17|3|Y|5|6|7|32|8|@]|D|@]|E|$]]|$1|18|3|19|5|W|7|33|8|@$9|34|A|35|B|C]]|D|@]|E|$]]|$1|1A|3|-4|5|6|7|36|8|@]|D|@]|E|$]]|$1|1B|3|G|5|6|7|37|8|@$9|38|A|39|B|C]]|D|@]|E|$]]|$1|1C|3|I|5|J|7|3A|8|@$9|3B|A|3C|B|C]]|D|@$9|3D|A|3E|1|3F]]|E|$]]|$1|1D|3|1E|5|6|7|3G|8|@$9|3H|A|3I|B|C]]|D|@]|E|$]]|$1|1F|3|G|5|6|7|3J|8|@$9|3K|A|3L|B|C]]|D|@]|E|$]]|$1|1G|3|I|5|J|7|3M|8|@$9|3N|A|3O|B|C]]|D|@$9|3P|A|3Q|1|3R]]|E|$]]|$1|1H|3|1I|5|6|7|3S|8|@$9|3T|A|3U|B|C]]|D|@]|E|$]]|$1|1J|3|G|5|6|7|3V|8|@$9|3W|A|3X|B|C]]|D|@]|E|$]]|$1|1K|3|I|5|J|7|3Y|8|@$9|3Z|A|40|B|C]]|D|@$9|41|A|42|1|43]]|E|$]]|$1|1L|3|1M|5|6|7|44|8|@$9|45|A|46|B|C]]|D|@]|E|$]]|$1|1N|3|1O|5|6|7|47|8|@$9|48|A|49|B|C]]|D|@]|E|$]]|$1|1P|3|-4|5|6|7|4A|8|@]|D|@]|E|$]]]|1Q|$1R|$5|1S|1T|1U|E|$1V|1W|1X|-4]]|1Y|$5|1S|1T|1U|E|$1V|1Z|1X|-4]]|20|$5|1S|1T|1U|E|$1V|21|1X|-4]]|22|$5|1S|1T|1U|E|$1V|23|1X|-4]]|24|$5|1S|1T|1U|E|$1V|25|1X|-4]]]]

I had a similar issue. The next solution is in *case to can't launch the server Locally * and you will see the same error msg.(Image 1)

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

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

To solve that and have the server working you must have the next steps.

<ol>
<li>Go to SQL Server Services</li>
<li>Right click to open properties</li>
<li>Go to LogOn tab (By default you will see something like Image 3)</li>
<li>Select the radio button Built-in account (Image 4)</li>
<li>Click on Ok</li>
<li>Go back to SQL Server Services and launch again the server (Image 5)
After that you must be able to see run it.</li>
</ol>

<a href="https://i.stack.imgur.com/Yein1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Yein1.png" alt="Image 3"></a>
Image 3

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

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

I hope that works for you or others with similar issues. Follow me for more tips.

blocks|key|336128|text|只需在sql+server配置管理器中禁用VIA协议。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|336129|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|$]]

Just disable the VIA protocol in sql server configuration manager

blocks|key|1743640|text|我从事件日志中发现我的SQL+server评估已过期。我需要升级或者需要使用社区版。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1743641|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 found from event logs that My SQL server evaluation has expired.
I needed to upgrade or needed to use community edition.

blocks|key|1743349|text|我认为这个解决方案更合适，因为它不会阻止您使用TCP/IP访问。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1743350|在|1743351|防火墙中打开端口以进行TCP访问。|blockquote|1743352|1743353|在“开始”菜单上，单击“运行”，键入WF.msc，然后单击“确定”。|1743354|在“具有高级安全性的Windows防火墙”的左窗格中，右键单击“入站规则”，然后在操作窗格中单击“新建规则”。|1743355|在规则类型对话框中，选择端口，然后单击下一步。|1743356|在协议和端口对话框中，选择TCP。选择特定的本地端口，然后键入数据库引擎实例的端口号，例如1433表示默认实例。单击下一步。|1743357|在操作对话框中，选择允许连接，然后单击下一步。|1743358|在“配置文件”对话框中，选择描述要连接到数据库引擎时的计算机连接环境的任何配置文件，然后单击“下一步”。|1743359|在“名称”对话框中，键入此规则的名称和说明，然后单击“完成”。|1743360|1743361|(来源：https://msdn.microsoft.com/en-us/library/ms175043.aspx)|offset|length|1743362|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ms175043.aspx^0|0|0|0|0|0|0|0|0|0|0|0|0|4|1I|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1A|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1D|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1E|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1F|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1G|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1H|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1I|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1K|8|@]|9|@$Y|1L|Z|1M|1|1N]]|A|$]]|$1|10|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]]]

I think this solution is more appropriate, because it does not prevent you from using TCP/IP access.

<blockquote>
 To open a port in the Windows firewall for TCP access
 
 On the Start menu, click Run, type WF.msc, and then click OK.
 
 In the Windows Firewall with Advanced Security, in the left pane,
 right-click Inbound Rules, and then click New Rule in the action pane.
 
 In the Rule Type dialog box, select Port, and then click Next.
 
 In the Protocol and Ports dialog box, select TCP. Select Specific
 local ports, and then type the port number of the instance of the
 Database Engine, such as 1433 for the default instance. Click Next.
 
 In the Action dialog box, select Allow the connection, and then click
 Next.
 
 In the Profile dialog box, select any profiles that describe the
 computer connection environment when you want to connect to the
 Database Engine, and then click Next.
 
 In the Name dialog box, type a name and description for this rule, and
 then click Finish.
</blockquote>

(Source: <a href="https://msdn.microsoft.com/en-us/library/ms175043.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms175043.aspx</a>)

blocks|key|336479|text|对于我来说，一个简单的windows更新就能修复它，我希望我以前也尝试过。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|336480|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|$]]

For me a simple windows update fixed it, I wish I tried it before.

blocks|key|434432|text|我安装了SQL+2017，在免费试用/评估期结束时出现此问题，问题的解决方案如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|434433|1-转到windows的开始按钮，找到Microsoft+SQL+Server+20XX文件夹|434434|2-然后，SQL+Server+20XX安装中心|434435|3-在左侧，选择"Maintenance“选项|434436|4-然后单击“Edition+upgrade”|434437|5-然后在combox中选择"developer“选项，然后单击”next“按钮|434438|6-单击"I+accept+the+license+terms“选项，然后单击”next|434439|7-最后，单击“下一步”，然后单击“升级”，等待大约15分钟。|434440|8-在此之后，在"Services.msc“中重新启动SQL+Server服务，并再次打开SQL，它应该可以工作。欲了解更多信息，请观看视频：https://www.youtube.com/watch?v=EVG35ahhjec|offset|length|434441|entityMap|0|LINK|mutability|MUTABLE|url|https://www.youtube.com/watch?v=EVG35ahhjec^0|0|0|0|0|0|0|0|0|1Z|17|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|17|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@]|9|@$R|1A|S|1B|1|1C]]|A|$]]|$1|T|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10]]]]

I have SQL 2017 installed and this issue happens when the free trial / evaluation period ends, the solution to the problem is the following:
1 - Go to the windows start button, find the Microsoft SQL Server 20XX folder
2- Then, SQL Server 20XX Installation Center
3- On the left, select the option &quot;Maintenance&quot;
4- Then click on “Edition upgrade”
5- Then in the combox select &quot;developer&quot; option, and then click on “next” button
6- Click on the option &quot;I accept the license terms&quot; and then next
7- Finally, click on &quot;Next&quot; and click on &quot;Upgrade&quot;, and wait approximately 15 minutes.
8- After this, restart the SQL Server service in &quot;Services.msc&quot; and open SQL again, it should work.
For more information: watch this video: <a href="https://www.youtube.com/watch?v=EVG35ahhjec" rel="nofollow noreferrer">https://www.youtube.com/watch?v=EVG35ahhjec</a>

blocks|key|336825|text|如果你还在浏览答案，这里还有一个步骤你可能已经错过了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|336826|使用管理员访问权限打开SQL+server配置管理器。|336827|首先(对本地系统)应用更改，然后尝试运行。|336828|​|336829|📷|atomic|offset|length|336830|336831|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9f1ae3802ad1d502b67337447f97093f.png|imageAlt^0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@$K|11|L|12|1|13]]|A|$]]|$1|M|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

If you are still scrolling through the answers, here is one more step you might have missed.
Open SQL server configuration manager with admin access.
Apply the changes first(to local System) and then try to run.
<a href="https://i.stack.imgur.com/ioyuU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ioyuU.png" alt="enter image description here" /></a>

blocks|key|1743954|text|如果在企业或公司环境中使用管理工具下的Computer+Management或SQL+Server+Configuration+Manager配置SQL+Server连接，请确保以管理员身份打开计算机管理或SQL+Server配置管理器，或者|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|BOLD|entityRanges|data|1743955|1743956|管理权限|blockquote|1743957|1743958|1743959|以上所有答案都不适用于我，但当我以管理模式运行它时，我现在可以启动我的SQL+Server代理或SQL+Server服务。|1743960|entityMap^0|J|J|13|W|2I|3|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|D]]|E|@]|F|$]]|$1|G|3|-4|5|6|7|X|8|@]|E|@]|F|$]]|$1|H|3|I|5|J|7|Y|8|@]|E|@]|F|$]]|$1|K|3|-4|5|6|7|Z|8|@]|E|@]|F|$]]|$1|L|3|-4|5|6|7|10|8|@]|E|@]|F|$]]|$1|M|3|N|5|6|7|11|8|@]|E|@]|F|$]]|$1|O|3|-4|5|6|7|12|8|@]|E|@]|F|$]]]|P|$]]

If you are configuring your SQL Server connection using <code>Computer Management</code> under Administrative Tools or <code>SQL Server Configuration Manager</code> in Enterprise or Corporate environment,
make sure you open your Computer Management or SQL Server Configuration Manager as an Administrator or you have
<blockquote>
Administrative Privileges
</blockquote>
All answers above didn't work for me, but when I run it as Administrative mode, I can now start my SQL Server Agent or SQL Server service.

blocks|key|435245|text|对于我来说，当我卸载Microsoft+C%2B%2B+2015-2020+Redistributable并安装+Visual+C%2B%2B+2017版本时，也遇到了类似的问题|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|435246|修复了重新安装Microsoft+Visual+C%2B%2B+2015-2020+Redistrubutable版本时的此问题。然后服务自动启动。|435247|entityMap^0|1G|T|0|0|1Y|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

For me happened similar issue when I did uninstall Microsoft Visual C++ 2015-2020 Redistributable and installed the Microsoft Visual C++ 2017 version
Fixed this issue when re-installed Microsoft Visual C++ 2015-2020 Redistrubutable versions. then services started automatically.

blocks|key|336419|text|https://social.technet.microsoft.com/wiki/contents/articles/52394.sql-server-troubleshooting-logon-failure-the-user-has-not-been-granted-the-requested-logon-type-at-this-computer.aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|336420|事件查看器显示登录失败-用户在此计算机上未被授予所请求的登录类型|336421|entityMap|0|LINK|mutability|MUTABLE|url^0|0|53|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@$A|N|B|O|1|P]]|C|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|4]]]]

<a href="https://social.technet.microsoft.com/wiki/contents/articles/52394.sql-server-troubleshooting-logon-failure-the-user-has-not-been-granted-the-requested-logon-type-at-this-computer.aspx" rel="nofollow noreferrer">https://social.technet.microsoft.com/wiki/contents/articles/52394.sql-server-troubleshooting-logon-failure-the-user-has-not-been-granted-the-requested-logon-type-at-this-computer.aspx</a>

event viewer shows 
Logon failure - the user has not been granted the requested logon type at this computer

I have the following error while I connect to SQL Server 2008 Management Studio with Windows authentication.

<pre><code>"The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details."
</code></pre>

Is anybody tell me why i am getting this error, whereas my SQL Server is running under network service built in a/c????

I googled it but not getting solution..

Thanks

The request failed or the service did not respond in a timely fashion?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

使用Windows身份验证连接到SQL Server 2008 Management Studio时出现以下错误。"The request failed or the service did not respond in a timely fashion.Consult the event log or other applicable error logs for details."谁能告诉我为

问请求失败还是服务没有及时响应？
EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问请求失败还是服务没有及时响应？EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问请求失败还是服务没有及时响应？
EN