连接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>