SQL Server2008连接错误'233',帮你解决

连接SQL Server2008时出现错误提示：已经成功与服务器建立连接，但是在登录过程中发生错误。（Provider:命名管道提供程序，error:0-管道的另一端上无任何过程。）（Microsoft SQL Server,错误：233）。

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family:SimSun;font-size:18px;background-color: rgb(255, 255, 255);">    造成这种错误的原因可能是在安装SQL Server2008时没有设置TCP端口，或者TCP/IP协议未启动。具体解决步骤如下:</span>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family:SimSun;font-size:18px;background-color: rgb(255, 255, 255);">    1，打开“MicrosoftSQL Server 2008--配置工具--SQL Server配置管理器”</span>

<pre>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family:SimSun;background-color: rgb(255, 255, 255);"><span style="font-size:18px;">    2，如图，在SQLServer配置管理器对话框中找到“SQL Server服务”单击——>右面内容窗口中的服务项目确保处于运行状态：选中——>鼠标右键单击——>单击“启动”</span></span>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family:SimSun;background-color: rgb(255, 255, 255);"><span style="font-size:18px;"><img alt="" src="https://img-blog.csdn.net/20130816172207046?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMDc3MzY2Nw==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" /></span></span>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family:SimSun;background-color: rgb(255, 255, 255);"><span style="font-size:18px;"><span style="font-family:SimSun;line-height: 26px;"> </span></span></span><span style="font-family:SimSun;font-size:18px;background-color: rgb(255, 255, 255);">   3，在左边的活动窗口中找到“SQL Server网络配置”单击——>单击“MSSQLSERVER的协议”——>启用"TCP/IP"和"NamedPipes"。</span>

<pre>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-size:18px;"><img alt="" src="https://img-blog.csdn.net/20130816172230296?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMDc3MzY2Nw==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" /></span>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family:SimSun;font-size:18px;background-color: rgb(255, 255, 255);">    4，在启动TCP/IP协议后,还要把其属性中的TCP端口号改为1433(动态端口)或修改为自己想要的端口号.。步骤：右击"TCP/IP属性"，在弹出的快捷菜单列表中选中”属性“选项并单击。</span><span style="font-family:SimSun;font-size:18px;background-color: rgb(255, 255, 255);">在弹出的属性对话框中单击”IP地址“选项卡，在TCP端口中输入”1433“。</span>

<pre>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family: SimSun; background-color: rgb(255, 255, 255);"><span style="font-family:SimSun;line-height: 26px;"><span style="font-family:SimSun;line-height: 26px;"><span style="font-size:18px;"><img alt="" src="https://img-blog.csdn.net/20130816172256734?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMDc3MzY2Nw==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" /></span></span></span></span>

<pre style="padding: 0px; margin-top: 10px; margin-bottom: 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;" class="line mt-10 q-content" name="code"><span style="font-family: SimSun; background-color: rgb(255, 255, 255);"><span style="line-height: 26px; font-family: SimSun;"><span style="font-family:SimSun;line-height: 26px;"><span style="font-family:SimSun;line-height: 26px;"><span style="font-size:18px;">   单击确定就OK啦。</span></span></span></span></span>